mysql -e 'SHOW ENGINES;'

Category: Databases & SQL

mysql -e 'SHOW ENGINES;'

List available storage engines

Shows every engine (InnoDB, MyISAM, MEMORY) with its support level; InnoDB is the transactional default. Related: CREATE TABLE ... ENGINE=InnoDB.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.