revision user index is indexed on user name not user ID On Sun, Nov 9, 2014 at 1:25 PM, Maximilian Doerr <[email protected] > wrote:
> Every tool I use seems to be slow. It seems we have some broken indexes > on the databases. > > Here is an execution report from my super count tool when it looked me > up. Time is logged in seconds. > > [executiontime] => Array > ( > [basic_stats] => Array > ( > [queries] => Array > ( > [0] => Array > ( > [time] => 0.77 > [query] => SELECT COUNT(*) AS count FROM > archive_userindex WHERE (`ar_user` ='14836860'); > [result] => succeeded > ) > > [1] => Array > ( > [time] => 18.95 > [query] => SELECT rev_timestamp, > page_title, page_namespace FROM revision_userindex JOIN page ON page_id = > rev_page WHERE (`rev_user` = '14836860') AND `rev_timestamp` > 1 ORDER BY > rev_timestamp ASC LIMIT 0,2688354; > [result] => succeeded > ) > > ) > > [total] => 19.89 > ) > > [replag] => Array > ( > [total] => 0 > [queries] => Array > ( > [0] => Array > ( > [time] => 0 > [query] => SELECT UNIX_TIMESTAMP() - > UNIX_TIMESTAMP(rc_timestamp) as replag FROM recentchanges_userindex ORDER BY > rc_timestamp DESC LIMIT 1; > [result] => succeeded > ) > > ) > > ) > > [usergroups] => Array > ( > [total] => 0.06 > [queries] => Array > ( > [0] => Array > ( > [query] => > http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Cyberpower678&usprop=groups&format=php > [time] => 0.06 > [result] => succeeded > ) > > ) > > ) > > [namespaces] => Array > ( > [total] => 0.1 > [queries] => Array > ( > [0] => Array > ( > [query] => > http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php > [time] => 0.1 > [result] => succeeded > ) > > ) > > ) > > ) > > > Cyberpower678 > English Wikipedia Account Creation Team > Mailing List Moderator > > > > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
