https://bugzilla.wikimedia.org/show_bug.cgi?id=66961
--- Comment #3 from Sean Pringle <sprin...@wikimedia.org> --- The example queries I've seen so far always use both log_namespace and log_title which means the page_time index can be used partially: KEY page_time (log_namespace, log_title, log_timestamp) Using enwiki pages with 100000+ log entries the queries take ~1s on warm data. Not terrible, though the number of Handler% calls is directly proportional to the number of log entries which isn't great for long term scalability. So tentative +1 to this bug. I've been trialing the following index on enwiki slaves for a few months: KEY log_title_type_time (log_title(16), log_type, log_timestamp) It sees quite a bit of use in general, and is used in favour of page_time for counting page deletes in the larger namespaces like 10 and 828. We should investigate how it compares to (log_namespace, log_title, log_type); the latter is probably better but might service fewer queries overall as well as encroach on page_time. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
