My Oracle Support Banner

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

Last updated on MAY 04, 2021

Applies to:

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

Symptoms

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

This error is found in the error log :

Changes

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.

Cause

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
Changes
Cause
Solution
References


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