How to Determine the Storage Engine Used by a Specific MySQL Table?

Identifying MySQL Engine Type for a Specific Table

Question:

For a MySQL database containing tables with differing storage engines (like MyISAM and InnoDB), how can you determine which tables utilize which engines?

Answer:

To check the engine type for a specific table in your MySQL database, execute the following query:

SHOW TABLE STATUS WHERE Name = 'xxx'

Replace 'xxx' with the name of the table you want to inspect.

The result will include a "Engine" column, which specifies the engine used by the table.

The above is the detailed content of How to Determine the Storage Engine Used by a Specific MySQL Table?. For more information, please follow other related articles on the PHP Chinese website!