In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly explains "mysql error report error: Table" mysql "." innodb_table_stats "how to solve not found", interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "mysql error reporting error: Table" mysql "." innodb_table_stats "not found how to solve it"!
Today, I suddenly found the database and reported the following error
2016-02-15 10:02:51 7f53d051a700 InnoDB: Error: Table "mysql". "innodb_table_stats" not found.
2016-02-15 10:02:51 7f53d051a700 InnoDB: Error: Fetch of persistent statistics requested for table "shboc". "uum_userinfo_handle"
But the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
Solution:
Basically, these created for you when you directly install MySQL 5.6. Apparently, upgrading from MySQL 5.5 does not include making these 5 tables available when going to MySQL 5.6. Here are the scripts to make them:
USE mysql
CREATE TABLE `innodb_index_ stats` (
`database_ name` varchar (64) COLLATE utf8_bin NOT NULL
`table_ name` varchar (64) COLLATE utf8_bin NOT NULL
`index_ name` varchar (64) COLLATE utf8_bin NOT NULL
`last_ update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
`stat_ name` varchar (64) COLLATE utf8_bin NOT NULL
`stat_ value` bigint (20) unsigned NOT NULL
`sample_ size` bigint (20) unsigned DEFAULT NULL
`stat_ substitution` varchar (1024) COLLATE utf8_bin NOT NULL
PRIMARY KEY (`database_ name`, `table_ name`, `index_ name`, `stat_ name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0
USE mysql
CREATE TABLE `innodb_table_ stats` (
`database_ name` varchar (64) COLLATE utf8_bin NOT NULL
`table_ name` varchar (64) COLLATE utf8_bin NOT NULL
`last_ update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
`n _ rows` bigint (20) unsigned NOT NULL
`clustered_index_ size` bigint (20) unsigned NOT NULL
`sum_of_other_index_ sizes` bigint (20) unsigned NOT NULL
PRIMARY KEY (`database_ name`, `table_ name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0
USE mysql
CREATE TABLE `slave_master_ info` (
`Number_of_ lines` int (10) unsigned NOT NULL COMMENT 'Number of lines in the file.'
`Master_log_ name`text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.'
`Master_log_ Pos` bigint (20) unsigned NOT NULL COMMENT 'The master log position of the last read event.'
`Host` char (64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT''COMMENT' The host name of the master.'
`User_ name`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.'
`User_ password`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.'
`Port` int (10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.'
`Connect_ retry` int (10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.'
`Enabled_ ssl` tinyint (1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.'
`Ssl_ ca`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.'
`Ssl_ capath`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.'
`Ssl_ cert`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.'
`Ssl_ cipher`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.'
`Ssl_ Key`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.'
`Ssl_verify_server_ cert` tinyint (1) NOT NULL COMMENT 'Whether to verify the server certificate.'
`Heartbeat` float NOT NULL
`Bind`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server'
`Ignored_server_ IDs`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs'
`Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.'
`Retry_ count` bigint (20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.'
`Ssl_ Crl`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)'
`Ssl_ crlpath`text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files'
`Enabled_auto_ position` tinyint (1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.'
PRIMARY KEY (`Host`, `Port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information'
USE mysql
CREATE TABLE `slave_relay_log_ info` (
`Number_of_ lines` int (10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.'
`Relay_log_ name`text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.'
`Relay_log_ Pos` bigint (20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.'
`Master_log_ name`text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.'
`Master_log_ Pos` bigint (20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.'
`Sql_ delay` int (11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.'
`Number_of_ workers` int (10) unsigned NOT NULL
`Id` int (10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.'
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information'
USE mysql
CREATE TABLE `slave_worker_ info` (
`Id` int (10) unsigned NOT NULL
`Relay_log_ name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
`Relay_log_ Pos` bigint (20) unsigned NOT NULL
`Master_log_ name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
`Master_log_ Pos` bigint (20) unsigned NOT NULL
`Checkpoint_relay_log_ name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
`Checkpoint_relay_log_ Pos` bigint (20) unsigned NOT NULL
`Checkpoint_master_log_ name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
`Checkpoint_master_log_ Pos` bigint (20) unsigned NOT NULL
`Checkpoint_ seqno` int (10) unsigned NOT NULL
`Checkpoint_group_ size` int (10) unsigned NOT NULL
`Checkpoint_group_ bitmap` blob NOT NULL
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information'
Or install the five tables in mysqldump on a database server with mysql version 5.6
INNODB_TABLES= "innodb_index_stats"
INNODB_TABLES= "${INNODB_TABLES} innodb_table_stats"
INNODB_TABLES= "${INNODB_TABLES} slave_master_info"
INNODB_TABLES= "${INNODB_TABLES} slave_relay_log_info"
INNODB_TABLES= "${INNODB_TABLES} slave_worker_info"
Mysqldump-uroot mysql ${INNODB_TABLES} > InnoDB_MySQL_Tables.sql
At this point, I believe you have a deeper understanding of "mysql error error: Table" mysql. "innodb_table_stats" not found how to solve ", might as well come to the actual operation! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.