https://bugzilla.wikimedia.org/show_bug.cgi?id=57186
Web browser: ---
Bug ID: 57186
Summary: blob_tracking indexes apparently unused
Product: MediaWiki
Version: 1.21.3
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
On enwiki:
+---------------+------------+-----------+
| table_name | index_name | rows_read |
+---------------+------------+-----------+
| blob_tracking | bt_moved | NULL |
| blob_tracking | bt_cluster | NULL |
+---------------+------------+-----------+
NULL rows_read indicates the indexes havn't been used for reading or writing.
Stats collection has been running here for over a week. Same results on S1
master and several slaves, and various other wikis.
Data / index disk usage for blob_tracking is roughly 50/50 split. Dropping
unused indexes would be good to reduce write load and save disk space.
But 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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
