How to find the type of storage engine a MySQL tables uses
Use MySQL SHOW ENGINES and SHOW TABLE STATUS to identify supported storage engines and the engine used by a specific table.
Use MySQL SHOW ENGINES and SHOW TABLE STATUS to identify supported storage engines and the engine used by a specific table.