Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F4710
timestamp_usertext.patch
Public
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
•
bzimport
Nov 21 2014, 10:05 PM
2014-11-21 22:05:14 (UTC+0)
Size
680 B
Referenced Files
None
Subscribers
None
timestamp_usertext.patch
View Options
Index: maintenance/tables.sql
===================================================================
--- maintenance/tables.sql (revision 32915)
+++ maintenance/tables.sql (working copy)
@@ -282,7 +282,8 @@
INDEX rev_timestamp (rev_timestamp),
INDEX page_timestamp (rev_page,rev_timestamp),
INDEX user_timestamp (rev_user,rev_timestamp),
- INDEX usertext_timestamp (rev_user_text,rev_timestamp)
+ INDEX usertext_timestamp (rev_user_text,rev_timestamp),
+ INDEX timestamp_usertext (rev_timestamp,rev_user_text)
) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=1024;
-- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit
File Metadata
Details
Attached
Mime Type
text/x-diff
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4276
Default Alt Text
timestamp_usertext.patch (680 B)
Attached To
Mode
T15622: Create (rev_timestamp,rev_user_text) index
Attached
Detach File
Event Timeline
Log In to Comment