MySQL storage engine MyISAM and InnoDB

MyISAM and InnoDB

MyISAM is the storage engine used before the mysql5.7 version.
The advantage is used in the case of high query frequency, such as the data fetch of the website store.
The disadvantage is not to support transactions, not suitable for banks, securities and so on.
Table-locked read and write blocking

InnoDB is the storage engine used by the mysql5.7 version.
Benefits Support Transactions
The disadvantage is that the data fetch speed is not myisam so fast
Row locking record read and write blocking

Mysql> show engines; View MySQL default storage engine

Mysql> Show create table list; View the storage engine that created the table list

mysql> ALTER TABLE list Engine=myisam; Modify the existing table's storage engine to MyISAM

Vim/etc/my.cnf
Under the Mysqld module, add the row
Default-storage-engine=myisam
Restart MySQL
Subsequent tables are created with Mylsam as the default storage engine

Bulk Change Tables
Yum Install Perl-dbi-y
Yum Install Perl-dbd-mysql-y
To install a two package first
Vim/usr/local/mysql/bin/mysql_convert_table_format//Modify the configuration file for this command
"E|engine|type=s" = $opt _engine//32 Line Modification
Mysql_convert_table_format--host=localhost--user=root--password=123123--socket=/home/mysql/mysql.sock--engine= InnoDB school list; Use this command to bulk modify

Change to MyISAM again
Mysql_convert_table_format--user=root--password=123123--socket=//home/mysql/mysql.sock--engine=MyISAM School List

Note:
Bulk Modify the MySQL password set by root--password= itself
--socket= the path specified at compile time/mysql.scok
--engine=myisam Library Table ...

MySQL storage engine MyISAM and InnoDB