[Labs-l] Not seeing any indexes

Sat Aug 29 16:25:43 UTC 2015

Thanks. Good to know.

On Sat, Aug 29, 2015 at 10:32 AM, Morten Wang <nettrom at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/8550fc20/attachment.html>