Last modified: 2014-07-20 18:15:40 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T59184, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 57184 - cl_collation index redundant
cl_collation index redundant
Status: NEW
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.21.x
All All
: Low minor (vote)
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-11-18 14:12 UTC by Sean Pringle
Modified: 2014-07-20 18:15 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sean Pringle 2013-11-18 14:12:23 UTC
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?

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links