View mysql Engines

To view the mysql engine, mysql provides multiple storage engines by default. You can view the following information to see what storage engine your mysql currently provides: mysqlshowengines; check the default storage engine of your mysql instance: mysqlshowvariableslike % storage_engine %; you need to check the engine used by a table (

To view the mysql engine, mysql provides multiple storage engines by default. You can view the following information to see what storage engine your mysql currently provides: mysql show engines; check the default storage engine of mysql: mysql show variables like '% storage_engine % '.

View mysql Engine

In general, mysql provides multiple storage engines by default. You can view the following information:

Check what storage engine your mysql currently provides:
Mysql> show engines;

Check the default storage engine of your mysql instance:
Mysql> show variables like '% storage_engine % ';

You need to check the engine used by a table (the storage engine used for the table is displayed after the parameter engine in the display result ):
Mysql> show create table name