• 2019-05-04 07:05:38

Check the storage engine for a MySQL table via terminal

Check the storage engine for a MySQL database via terminal

Here's an easy way to check the storage engine for one of your tables:

mysql -u your_user -p 

USE your_db;
SHOW TABLE STATUS WHERE Name = 'table_name_here';

The output should look something like this:

+------------------+--------+---------+------------+------+
| Name             | Engine | Version | Row_format | Rows |
+------------------+--------+---------+------------+------+
| tbable_name_here | InnoDB |      10 | Compact    |    3 |
+------------------+--------+---------+------------+------+

Under the 'Engine' section you will be able to see the storage engine for this very table.

Also here's an easy way of converting your storage engine from InnoDB to MyISAM or the other way round:

Change your MySQL storage engine

This is pretty much it :)