Mysql>show engines;+------------+---------+----------------------------------------------------------------+--------------+-----+- -----------+| Engine | Support | Comment | Transactions | XA | savepoints |+------------+---------+----------------------------------------------------------------+----------- ---+-----+------------+| MyISAM | YES | Default engine as of MySQL3.23With great Performance | NO | NO | NO | | Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO | | Blackhole | YES | /dev/NULLStorage Engine (anything youWriteto it disappears) | NO | NO | NO | | CSV | YES | CSV Storage Engine | NO | NO | NO | | MEMORY | YES | Hash based, storedinchMemory, useful forTemporary 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 | +------------+---------+----------------------------------------------------------------+--------------+-----+- -----------+7RowsinchSet (0.00Sec
view database using the engine MySQL ' %storage_engine% ' ; +----------------+--------+| Variable_name | Value |+----------------+--------+| storage_engine | InnoDB | +----------------+--------+1 in Set (0.00 sec)
MySQL Database engine