https://bugzilla.wikimedia.org/show_bug.cgi?id=57185
Web browser: --- Bug ID: 57185 Summary: article_feedback indexes apparently unused Product: MediaWiki Version: 1.21.3 Hardware: All OS: All Status: NEW Severity: normal Priority: Unprioritized Component: Database Assignee: wikibugs-l@lists.wikimedia.org Reporter: sprin...@wikimedia.org Classification: Unclassified Mobile Platform: --- On enwiki: +------------------+----------------------------+-----------+ | table_name | index_name | rows_read | +------------------+----------------------------+-----------+ | article_feedback | PRIMARY | NULL | | article_feedback | article_feedback_timestamp | NULL | | article_feedback | aa_page_id | NULL | | article_feedback | aa_page_user_token | NULL | +------------------+----------------------------+-----------+ 4 rows in set (0.25 sec) NULL rows_read indicates the indexes havn't been used. Stats collection has been running here for over a week. Same results on S1 master and several slaves. Indexes outweigh data on article_feedback quite a bit, taking up space and increasing write load: +---------------------------------------+--------+-------+--------+ | CONCAT(table_schema, '.', table_name) | rows | DATA | idx | +---------------------------------------+--------+-------+--------+ | enwiki.article_feedback | 69.00M | 7.13G | 26.04G | +---------------------------------------+--------+-------+--------+ Surprising; now I'm suspicious of the stats... Are these indexes really likely to be simply unused? Is there any infrequent maintenance or reporting job that requires them? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l