Maciej Jaros <egil(a)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