Maciej Jaros <[email protected]> wrote: > I've notice that there are no keys and so probably no > indexes on toolserver databases. Is this intentional? > I've used below queries - both show no keys/indexes on revision table:
> SHOW COLUMNS FROMplwiki_p.revision; > SHOW INDEX FROM plwiki_p.revision; > I've also exported the whole schema and see no indexes at > all... The same for random wiki on s2 - nlwiki_p. > [...] They are /views/, not tables; use "SHOW CREATE VIEW revision;" to see the definition. Unfortunately, MySQL doesn't make this obvious. You cannot see if there are keys/indexes defined for the underlying tables as a normal user. Tim _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
