mysql_engines []

This is an old revision of the document!

select engine,count(*),sum(index_length+data_length)/1024/1024 "Table Engine Size in MB" from information_schema.tables group by engine;

Repalce database_name and table_name to your desired values

select engine, table_name from information_schema.tables where table_schema = 'database_name' and table_name = 'table_name';

Replace magento and %xml%

select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%';

select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%' and engine = InnoDB';