https://bugzilla.wikimedia.org/show_bug.cgi?id=54107
Tim Landscheidt <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|SQL queries on replica |*_userindex tables need to |tables take much longer |be documented |than on the Toolserver | --- Comment #1 from Tim Landscheidt <[email protected]> --- For queries that select on rev_user, there is the table "revision_userindex": | MariaDB [dewiki_p]> select rev_timestamp from revision_userindex where rev_user=336793 order by rev_timestamp asc limit 1; | +----------------+ | | rev_timestamp | | +----------------+ | | 20070115154431 | | +----------------+ | 1 row in set (0.05 sec) | MariaDB [dewiki_p]> Unfortunately, it isn't documented at [[wikitech:Nova Resource:Tools/Help]] (so far :-)). I'll leave that to Coren as my knowledge of what and when is purely based on word of mouth. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
