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

How DigitalOcean Simplifies Cloud Computing for Developers
2023-01-18 12:35:28
How to Get Current Route Name in Laravel
2020-11-08 08:57:11
How to check the logs of running and crashed pods in Kubernetes?
2020-10-28 09:01:44
Top 10 VScode Shortcuts For Mac and Windows to Help You be More Productive
2020-10-28 07:12:51