Check the storage engine for a MySQL table via terminal

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 :)

 

Materialize

The Real-Time Data Platform for Developers

Buy me a coffeeBuy me a coffee