If you wonder what the standard indexes are, there's a link to the SVN source on https://wiki.toolserver.org/view/Database_access#Database_schema
Regards, Morten
On 16 March 2013 12:20, Tim Landscheidt tim@tim-landscheidt.de wrote:
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