2

I am seeing many errors like the following for my MySQL instance. It appears that it is complaining about an index that does not exist anymore. This is an InnoDB table. What do I need to do to update the innodb_index_stats to reflect the new indexes? I tried ANALYZE table goal_summary but that did not change anything.

2017-07-14 15:35:21 2b6d11b47700 InnoDB: Ignoring strange row from mysql.innodb_index_stats WHERE database_name = 'network_00576' AND table_name = 'goal_summary' AND index_name = 'goal_summary_id' AND stat_name = 'n_diff_pfx03'; because stat_name is out of range, the index has 2 unique columns

More info:

select * from mysql.innodb_index_stats
 where database_name="network_00576"
   and table_name="goal_summary"
   and index_name="goal_summary_id"
   and stat_name = 'n_diff_pfx03';

Result:

+---------------+--------------+-----------------+---------------------+--------------+------------+-------------+------------------------------+
| database_name | table_name   | index_name      | last_update         | stat_name    | stat_value | sample_size | stat_description             |
+---------------+--------------+-----------------+---------------------+--------------+------------+-------------+------------------------------+
| network_00576 | goal_summary | goal_summary_id | 2017-02-01 22:32:12 | n_diff_pfx03 |        407 |           1 | goal_summary_id,offerid,date |
+---------------+--------------+-----------------+---------------------+--------------+------------+-------------+------------------------------+

And:

show keys from goal_summary where Key_name="goal_summary_id";

Result:

+--------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table        | Non_unique | Key_name        | Seq_in_index | Column_name     | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| goal_summary |          1 | goal_summary_id |            1 | goal_summary_id | A         |         694 |     NULL | NULL   |      | BTREE      |         |               |
+--------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2
  • 1
    ever figure this out? – mbourgon Oct 11 '17 at 15:24
  • No, never got this figured out and kind of got put on the back burner due to higher priority concerns – Rob L Oct 12 '17 at 15:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.