Mysql> Show variables like '%storage_engine% '; +------------------------+--------+| variable_name | Value |+------------------------+--------+| Default_storage_engine | InnoDB | | Storage_engine | InnoDB |+------------------------+--------+2 rows in Set (0.00 sec) mysql> Show engines;+--------------------+------ ---+----------------------------------------------------------------+--------------+------+------------+| Engine | Support | Comment | Transactions | XA | savepoints |+--------------------+---------+----------------------------------------------------------------+--- -----------+------+------------+| Performance_schema | YES | Performance Schema | NO | NO | NO | | Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV Storage Engine | NO | NO | NO | | Blackhole | YES | /dev/null Storage Engine (anything you write to it disappears) | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | InnoDB | DEFAULT | Supports transactions, Row-level locking, and foreign keys | YES | YES | YES | | ARCHIVE | YES | Archive Storage Engine | NO | NO | NO | | MyISAM | YES | MyISAM Storage Engine | NO | NO | NO | | Federated | NO | Federated MySQL Storage Engine | NULL | NULL | NULL |+--------------------+---------+----------------------------------------------------------------+--------- -----+------+------------+9 rows in Set (0.00 sec)
View the database storage engine and the default engine