[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 ]

It was indexed by both in the past.  And it should be that way too.  Looking up by username is an unreliable way of counting edits.

Cyberpower678
English Wikipedia Account Creation Team
Mailing List Moderator



> On Nov 9, 2014, at 14:00, John <phoenixoverride at gmail.com> wrote:
> 
> 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 <mailto: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 <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 <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 <mailto:Labs-l at lists.wikimedia.org>
> https://lists.wikimedia.org/mailman/listinfo/labs-l <https://lists.wikimedia.org/mailman/listinfo/labs-l>
> 
> 
> _______________________________________________
> 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/22f69a57/attachment-0001.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 ]