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 <[email protected]> wrote: > 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
_______________________________________________ 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
