Comment 5 for bug 993714

Revision history for this message
astrostl (astrostl) wrote :

Cool, thanks! Also, what about

    'select TABLE_SCHEMA, TABLE_NAME, ENGINE from information_schema.tables where ENGINE not like "InnoDB"'

as an alternative to a SHOW TABLE STATUS loop? Is it polling for more than the engine type, or something that couldn't/shouldn't be divined from the information_schema table? I find those lookups to be the biggest source of slowdowns, when dealing with massive amounts of schemas/tables.