Bobby's Blog

Check the storage engine for a MySQL table via terminal

mysq-storage-engines-bobby-iliev

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:

The output should look something like this:

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 🙂


About the author

Bobby

Linux System Administrator