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