Skip to content

Instantly share code, notes, and snippets.

@jayjanssen

jayjanssen/gist:1d1edde1541864a5e9c4

Created August 5, 2014 13:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jayjanssen/1d1edde1541864a5e9c4 to your computer and use it in GitHub Desktop.
Save jayjanssen/1d1edde1541864a5e9c4 to your computer and use it in GitHub Desktop.
Download ZIP
Find Non Innodb Tables
Raw
gistfile1.txt
select engine, table_schema, table_name from information_schema.TABLES
WHERE table_schema NOT IN ('performance_schema','information_schema','mysql')
and engine != 'Innodb';
select table_schema, engine, count(*) as non_innodb_tables from information_schema.TABLES where table_schema NOT IN ('performance_schema','information_schema','mysql')
and engine != 'Innodb' group by table_schema, engine with rollup;
select table_schema, count(*) as non_innodb_tables from information_schema.TABLES where table_schema NOT IN ('performance_schema','information_schema','mysql')
and engine != 'Innodb' group by table_schema with rollup;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment