'Mysql.innodb_table_stats & mysql.innodb_index_stats not updating

I believe I have persitent stats configured correctly and there are records in INFORMATION_SCHEMA.STATISTICS table but the following tables have no data for many of the tables/indexes. mysql.innodb_table_stats & mysql.innodb_index_stats . Has anyone ever seen this before? I tried running ANALYZE but still there were no records added.

+--------------------------------------------------------+---------------+
| Variable_name                                          | Value         |
+--------------------------------------------------------+---------------+
| innodb_stats_auto_recalc                               | ON            |
| innodb_stats_include_delete_marked                     | OFF           |
| innodb_stats_persistent                                | ON            |
| innodb_stats_persistent_sample_pages                   | 20            |
| innodb_stats_sample_pages                              | 8             |
| innodb_stats_transient_sample_pages                    | 8             |
+--------------------------------------------------------+---------------+
mysqlstatistics


Solution 1:[1]

Figured it out. There is a row in the table for each partion. I was the filtering on table name not the partition name.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 8adger

Related Questions