https://bugzilla.wikimedia.org/show_bug.cgi?id=69127
Bug ID: 69127
Summary: Database upgrade MariaDB 10: Discrepancies with
logging table on different wikis
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Infrastructure
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected]
Web browser: ---
Mobile Platform: ---
Queries on logging-table perform different on different wikis.
Atm there are different key definitions on eg. enwiki and dewiki
- enwiki has a key `log_user_text_time`(ok to have), dewiki doesn't
- dewiki has a key `log_user_type_time`(important to have), enwiki doesn't
- same for `log_title_time` / `log_page_id_time`
enwiki | CREATE TABLE `logging`
...
PRIMARY KEY (`log_id`),
KEY `type_time` (`log_type`,`log_timestamp`),
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`),
KEY `log_page_id_time` (`log_page`,`log_timestamp`),
KEY `log_user_text_time` (`log_user_text`(16),`log_timestamp`),
KEY `log_title_time` (`log_title`(16),`log_timestamp`)
) ENGINE=TokuDB AUTO_INCREMENT=58015836 DEFAULT CHARSET=binary
`compression`='tokudb_zlib'
dewiki | CREATE TABLE `logging`
...
PRIMARY KEY (`log_id`),
KEY `type_time` (`log_type`,`log_timestamp`),
KEY `user_time` (`log_user`,`log_timestamp`),
KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
KEY `times` (`log_timestamp`),
KEY `log_user_type_time` (`log_user`,`log_type`,`log_timestamp`),
KEY `log_page_id_time` (`log_page`,`log_timestamp`)
) ENGINE=TokuDB AUTO_INCREMENT=62684641 DEFAULT CHARSET=binary
`compression`='tokudb_zlib'
--
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
