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             |
    +--------------------------------------------------------+---------------+
    


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




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2