[MySQL] Database engine view

1. View the Database engine

Globally, show engines;

2. View the Database engine

Show variables like '%engine% ';

Or Show create TABLE Xxx\g

will show the default search engine

3. Modify the database default engine, in the configuration file

Default-storage-engine=innodb

frm myd myi represents table structure, data file, index file (MyISAM), respectively

For InnoDB, these files will also be generated, FRM,IBD (InnoDB)

http://blog.rootsmith.ca/linux/mysql-data-files-myd-myi-and-frm/