Maciej Jaros <egil@wp.pl> 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 (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette