Method to modify MySQL's database engine to INNODB

For MySQL databases, you must use the INNODB engine if you want to use transactions and row-level locking. If you want to use a full-text index, you must use myisam. INNODB is more practical, secure, stable and less efficient than MYISAM, but has some features that MYISAM does not have. Modify MySQL engine to INNODB, can use foreign keys, transactions and other functions, high performance. This article focuses on how to modify the MySQL database engine to INNODB, so let's get started.

First modify ES13en.ini and add the following under [mysqld]

default-storage-engine=INNODB 

The blue font is the name of the database engine to specify.

Modify the engine of the built table with the sql statement:

alter table tableName type=InnoDB 

My my. ini file is posted below for your reference:

[mysqld] 
 
basedir=C:\Program Files\VertrigoServ\Mysql\ 
 
datadir=C:\Program Files\VertrigoServ\Mysql\data\ 
 
port =3306 
 
key_buffer =64M 
 
max_allowed_packet =1M 
 
table_cache =128 
 
sort_buffer_size =512K 
 
net_buffer_length =8K 
 
read_buffer_size =256K 
 
read_rnd_buffer_size =512K 
 
myisam_sort_buffer_size =68M 
 
default-storage-engine=INNODB 
 
[mysqldump] 
 
quick 
 
max_allowed_packet =116M 
 
[mysql] 
 
no-auto-rehash 
 
# Remove the next comment character if you are not familiar with SQL 
 
#safe-updates 
 
[isamchk] 
 
key_buffer =20M 
 
sort_buffer_size =20M 
 
read_buffer =62M 
 
write_buffer =62M 
 
[myisamchk] 
 
key_buffer =20M 
 
sort_buffer_size =20M 
 
read_buffer =62M 
 
write_buffer =62M 
 
[mysqlhotcopy] 
 
interactive-timeout 

Following the code prompts above, we are able to successfully modify the MySQL database engine to INNODB. This article introduces here, I believe that 1 will bring you the harvest!