Jump to Navigation

MySQL: Check table engines in use

To determine whether tables in your MySQL database use MyISAM or InnoDB, you can use the following query:

SELECT TABLE_SCHEMA DB,ENGINE,COUNT(1)
FROM INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA,ENGINE
ORDER BY
TABLE_SCHEMA,ENGINE;

This shows all engines used for each database. Most tables will use either MyISAM or INNODB, but there are other engines, like MEMORY, CSV and PERFORMANCE_SCHEMA.

Tags:


Technical_article | by Dr. Radut