Modify MySQL Engine

Modify MySQL engine to InnoDB. You can use foreign keys, transactions, and other functions with high performance.

Modify my. ini and add

Default-storage-engine =InnoDB

The red font indicates the engine name to be specified.

Use SQL statements to modify the engine of a table:

Alter table tablename type = InnoDB

My. ini file for reference (http://www.my400800.cn) is posted below ):

[Mysqld]
Basedir = c: \ Program Files \ vertrigoserv \ mysql \
Datadir = c: \ Program Files \ vertrigoserv \ mysql \ data \
Port = 3306
Key_buffer = 64 m
Max_allowed_packet = 1 m
Table_cache = 128
Sort_buffer_size = 512 K
Net_buffer_length = 8 K
Read_buffer_size = 256 K
Read_rnd_buffer_size = 512 K
Myisam_sort_buffer_size = 68 m
Default-storage-engine = InnoDB

[Mysqldump]
Quick
Max_allowed_packet = 116 m

[MySQL]
No-auto-rehash
# Remove the next comment character if you are not familiar with SQL
# Safe-Updates

[Isamchk]
Key_buffer = 20 m
Sort_buffer_size = 20 m
Read_buffer = 62 m
Write_buffer = 62 m

[Myisamchk]
Key_buffer = 20 m
Sort_buffer_size = 20 m
Read_buffer = 62 m
Write_buffer = 62 m

[Mysqlhotcopy]
Interactive-Timeout