Last modified: 2014-08-05 01:05:19 UTC
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'