Last modified: 2014-06-24 05:31:27 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 T59182, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 57182 - log_page_id_time index redundant
log_page_id_time 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 13:56 UTC by Sean Pringle
Modified: 2014-06-24 05:31 UTC (History)
0 users

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


Attachments

Description Sean Pringle 2013-11-18 13:56:22 UTC
mysql wmf db1051 root (none)> 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 = 'logging' AND  seq_in_index=1;
+------------+--------------------+-------------+
| table_name | index_name         | rows_read   |
+------------+--------------------+-------------+
| logging    | page_time          |    19794969 |
| logging    | times              | 15178724330 |
| logging    | type_time          |   391424823 |
| logging    | log_user_type_time |    31164428 |
| logging    | PRIMARY            |    11048025 |
| logging    | user_time          |     1442484 |
| logging    | log_page_id_time   |        NULL | <--- never used
+------------+--------------------+-------------+
7 rows in set (0.25 sec)

Same result appeared for various slaves and wikis across all WMF clusters.

log_page_id_time could be dropped.

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


Navigation
Links