Mysql.innodb_table_stats & mysql.innodb_index_stats not updating

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hello,

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             |
+--------------------------------------------------------+---------------+
1 Like
2

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