Page 1 of 1

InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

Posted: Wed Jan 11, 2017 12:26 am
by jeniffer
I am getting the below error in mysql logs. Please help

InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.

Posted: Wed Jan 11, 2017 12:30 am
by Martin
Hello,

Drop "innodb_table_stats" table.

do the below steps to create the table

mysql>

mysql> USE mysql;

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;


------------------------------
Martin N
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree