https://bugzilla.wikimedia.org/show_bug.cgi?id=18954
Krinkle <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Krinkle <[email protected]> 2011-04-11 22:54:56 UTC --- So, in order to be able to effeciently query by log_action, which indexes need to be added or changed ? Right now there is: > CREATE INDEX /*i*/type_time ON /*_*/logging (log_type, log_timestamp); > CREATE INDEX /*i*/user_time ON /*_*/logging (log_user, log_timestamp); > CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, > log_timestamp); > CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); > CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, > log_type, log_timestamp); > CREATE INDEX /*i*/log_page_id_time ON /*_*/logging > (log_page,log_timestamp); at http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup&pathrev=84394#l1185 It may take more time for WMF to do this after deployment of the code (since it most likely requires the famous musical dance with the servers), but that should not block the development of this feature. We should identify the needed changes to the indexes so that development can continue so wikis can use this feature as soon as possible (especially smaller wikis, outside WMF). In addition to the indexes there is much more that will have to be done * interface for Special:Log * stuff in the API perhaps * debugging and optimalization * whatever else that can and will go wrong If we keep postponing this just for the indexes issue, the rest will get blocked too. If it's too dangerious for WMF or if WMF won't be able to do this anytime soon, it could be disabled by default until everything is sorted (like with the category sorting). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- 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
