InnoDB: Error: Table "mysql"."innodb_table_stats" Not Found. (Doc ID 1539343.1)

Last updated on MAY 02, 2023

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

The MySQL error log contains an error related to missing InnoDB table : innodb_table_stats.

This error is found in the error log :

The error occurs after the installation of MySQL 5.6. It did not occur in MySQL 5.5.

MySQL 5.6 introduced persistent statistics and this table innodb_table_stats stores the persistent statistics.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.