https://bugzilla.wikimedia.org/show_bug.cgi?id=57184
Web browser: ---
Bug ID: 57184
Summary: cl_collation index redundant
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: ---
mysql wmf db1051 root enwiki> SELECT s.table_name,s.index_name,rows_read FROM
information_schema.statistics s LEFT JOIN information_schema. index_statistics
i ON (i.table_schema=s.table_schema AND i.table_name=s.table_name AND
i.index_name=s.index_name) WHERE s.table_schema='enwiki' and s.table_name =
'categorylinks' AND seq_in_index=1;
+---------------+--------------+------------+
| table_name | index_name | rows_read |
+---------------+--------------+------------+
| categorylinks | cl_sortkey | 780279158 |
| categorylinks | cl_from | 2135832387 |
| categorylinks | cl_timestamp | 150744319 |
| categorylinks | cl_collation | NULL | <-- never used
+---------------+--------------+------------+
4 rows in set (0.26 sec)
Same result appeared for various slaves and wikis across all WMF clusters.
cl_collation could be dropped.
Or could it? Does the updateCollation batch job need it?
--
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
