check storage engine in mysql

How to Check MySQL Engine Type for Table

MySQL provides two storage engines InnoDB and MyISAM to store databases. Each engine provides a different set of features. Depending on your requirement you can set MySQL to store databases and tables as per a specific storage engine. Often you may need to check MySQL engine type for table, to see what features are available, and which commands are not supported. In this article, we will learn how to check MySQL engine type for table.


How to Check MySQL Engine Type for Table

You can easily check MySQL engine type for table using the following command. Log into MySQL to run this statement.

SHOW TABLE STATUS WHERE Name = 'table_name';

If you want to view engine type of all tables in a database, run the following SQL query.

SELECT TABLE_NAME,
       ENGINE
FROM   information_schema.TABLES
WHERE  TABLE_SCHEMA = 'dbname';

Please note, if a database table is corrupted, then its engine type may be displayed as null.

In this article, we have learnt how to check MySQL engine.

Also read:

How to Use LIKE Operator in SQL for Multiple Values
How to Add Column After Another Column in MySQL
How to Increase Import File Size Limit in PHPMyAdmin
How to Retrieve MySQL Username and Password
How to Find & Replace Text in Entire Table in MySQL

Leave a Reply

Your email address will not be published.