[Labs-l] Not seeing any indexes

[Morten Wang]

As far as I know, there are two additional tables with specific indexes for
queries with usernames, revision_userindex and logging_userindex.  They're
described here:
https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database#Tables_for_revision_or_logging_queries_involving_user_names_and_IDs

Apart from those, I use the MediaWiki database schema as my go-to place for
documentation:
https://phabricator.wikimedia.org/diffusion/MW/browse/master/maintenance/tables.sql


Cheers,
Morten


On 29 August 2015 at 09:18, Huji Lee <huji.huji at gmail.com> wrote:

> Is there documentation on the indexes used on underlying tables? (Or, how
> they defer from default MW indexes)
>
> On Fri, Aug 28, 2015 at 4:31 PM, John <phoenixoverride at gmail.com> wrote:
>
>> Neither. What you are seeing from the shared databases are views. Views
>> do not have indexes, however the underlying data does.
>>
>> On Fri, Aug 28, 2015 at 4:28 PM, Huji Lee <huji.huji at gmail.com> wrote:
>>
>>> Hi,
>>>
>>> When I run a query like   *SELECT INDEXES FROM revision  *or any other
>>> table on the labsdb databases (such as enwiki.labsdb) I get no results. Is
>>> it because I don't have proper permissions, or because none of the labsdb
>>> tables have any indexes?
>>>
>>> Thanks,
>>>
>>> Huji
>>>
>>> _______________________________________________
>>> Labs-l mailing list
>>> Labs-l at lists.wikimedia.org
>>> 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
>>
>>
>
> _______________________________________________
> 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/20150829/2bd63841/attachment.html>