Check processlist in MySQL
mysql -p -e “show processlist”

Get each mysql db table’s engine type
select table_schema, table_name from information_schema.tables;