Skip to content

Instantly share code, notes, and snippets.

@jayjanssen
Created February 22, 2013 15:24
Show Gist options
  • Select an option

  • Save jayjanssen/5014173 to your computer and use it in GitHub Desktop.

Select an option

Save jayjanssen/5014173 to your computer and use it in GitHub Desktop.
Non Innodb tables outside of system schemas
select table_schema, table_name, engine from information_schema.tables where engine != 'InnoDB' and table_schema not in ('information_schema', 'performance_schema', 'mysql');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment