=== Find the Total number of tables/engines (All Databases) ===
<sxh bash>
select engine,count(*),sum(index_length+data_length)/1024/1024 "Table Engine Size in MB" from information_schema.tables group by engine;
</sxh>
\\
\\
=== Find the Engines for a specific db ===
Replace **__magento__** with your db name
<sxh bash>
select engine,count(*),sum(index_length+data_length)/1024/1024 "Table Engine Size in MB" from information_schema.tables where table_schema = 'magento' group by engine;
</sxh>
\\
\\
=== Find Engines for a specific db (Either InnoDB or MyISAM) ===
Replace **__magento__** with your db name and **InnoDB** with your desired engine
<sxh bash>
select engine,count(*),sum(index_length+data_length)/1024/1024 "Table Engine Size in MB" from information_schema.tables where table_schema = 'magento' and engine = 'InnoDB' group by engine;
</sxh>
\\
=== Find Engine for a Specific Table (Specific Database) ===
Repalce **__database_name__** and **__table_name__** to your desired values 
<sxh bash>
select engine, table_name from information_schema.tables where table_schema = 'database_name' and table_name = 'table_name';
</sxh>
\\
\\
=== Find Engine for a range of tables ===
Replace **__magento__** and **__%xml%__**
<sxh bash>
select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%';
</sxh>
\\
=== Find a Range of Tables with a Specific Engine ===
<sxh bash>
select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%' and engine = 'InnoDB';
</sxh>