[Labs-l] Database Indexing Doesn't seem to be working

• Previous message: [Labs-l] Database Indexing Doesn't seem to be working
• Next message: [Labs-l] Database Indexing Doesn't seem to be working
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

revision user index is indexed on user name not user ID

On Sun, Nov 9, 2014 at 1:25 PM, Maximilian Doerr <maximilian.doerr at gmail.com
> 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
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20141109/84e7e193/attachment.html>

• Previous message: [Labs-l] Database Indexing Doesn't seem to be working
• Next message: [Labs-l] Database Indexing Doesn't seem to be working
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]