How to change MySQL database engine to INNODB _ MySQL

This article describes how to modify the MySQL database engine to INNODB. For MySQL databases, if you want to use transactions and row-level locks, you must use the INNODB engine. If you want to use full-text indexes, you must use myisam. INNODB is more practical, secure, and stable, but less efficient than MYISAM. However, some functions are not available in MYISAM. Modify MySQL engine to INNODB. you can use foreign keys, transactions, and other functions with high performance. This article describes how to change the MySQL database engine to INNODB.

First, modify my. ini and add the following under [mysqld:

default-storage-engine=INNODB 

The blue font indicates the name of the database engine to be specified.

Use SQL statements to modify the engine of a table:

alter table tableName type=InnoDB 

The 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 

Follow the prompts in the above code to successfully modify the MySQL database engine to INNODB. This article introduces you here, and I believe it will surely bring you some benefits!