# InnoDB: Error: Tablespace for table "mysql"."innodb\_table\_stats" is missing. **URL:** \ **Category:** Percona Server for MySQL 5.6\ **Created:** [October 7, 2017, 5:52am UTC](https://forums.percona.com/t/innodb-error-tablespace-for-table-mysql-innodb-table-stats-is-missing/5918 "2017-10-07T05:52:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![soul301](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@soul301](https://forums.percona.com/u/soul301)\ **Post date:** [October 7, 2017, 5:52am UTC](https://forums.percona.com/t/innodb-error-tablespace-for-table-mysql-innodb-table-stats-is-missing/5918/1 "2017-10-07T05:52:35Z")
Hi, I am continuoulsy getting below error in mysql error log file mysql".“innodb\_table\_stats” is missing. I am using percona mysql server 5.6 can anyone guide me how to resolve above error. I have tried following solutions. 1 Removing .ibd and .frm files of below tables and restarted mysql : innodb\_index\_stats\* innodb\_table\_stats\* slave\_master\_info\* slave\_relay\_log\_info\* slave\_worker\_info\* 2 unable to create tables in 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; ERROR 1050 (42S01): Table ‘`mysql`.`innodb_table_stats`’ already exists 3 unable to drop table : mysql\> drop table innodb\_table\_stats; ERROR 1051 (42S02): Unknown table ‘mysql.innodb\_table\_stats’ 4 I have also cheked if any orphan table exist : mysql\> SELECT \* FROM INFORMATION\_SCHEMA.INNODB\_SYS\_TABLES WHERE NAME LIKE ‘%#sql%’; Empty set (0.00 sec) Is there any way I can fix above errors for below system tables ? Please guide innodb\_index\_stats\* innodb\_table\_stats\* slave\_master\_info\* slave\_relay\_log\_info\* slave\_worker\_info\* Regards, ---
**Author:** ![zarere](https://avatars.discourse-cdn.com/v4/letter/z/ac8455/32.png) [@zarere](https://forums.percona.com/u/zarere)\ **Post date:** [July 22, 2018, 11:38pm UTC](https://forums.percona.com/t/innodb-error-tablespace-for-table-mysql-innodb-table-stats-is-missing/5918/2 "2018-07-22T23:38:42Z")
Kindly check this [url][InnoDB: Error: Table "mysql"."innodb\_table\_stats" not found after upgrade to mysql 5.6 - Database Administrators Stack Exchange](https://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys/54624#54624%5B/url%5D)