Shulou(Shulou.com)05/31 Report--

MySQL database how to modify the engine for INNODB, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

For MySQL databases, you must use the INNODB engine if you want to use transaction and row-level locks. If you want to use full-text indexing, you must use myisam. INNODB is more practical, secure and stable, but slightly less efficient than MYISAM, but some functions are not available in MYISAM. Modify the engine of MySQL to INNODB, you can use foreign keys, transactions and other functions, high performance. The following editor will explain how to change the MySQL database engine to INNODB?

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 is the name of the database engine to be specified.

Use the SQL statement to modify the engine of the completed table

AltertabletableNametype=InnoDB

How to change the MySQL database engine to INNODB

[mysqld] basedir=C:\ ProgramFiles\ VertrigoServ\ Mysql\ datadir=C:\ ProgramFiles\ VertrigoServ\ Mysql\ data\ port=3306key_buffer=64Mmax_allowed_packet=1Mtable_cache=128sort_buffer_size=512Knet_buffer_length=8Kread_buffer_size=256Kread_rnd_buffer_size=512Kmyisam_sort_buffer_size=68Mdefault-storage-engine= INODB [mysqldump] quickmax_allowed_packet= 116M [MySQL] no-auto-rehash#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL#safe- updates [isamchk] key_buffer=20Msort_buffer_size=20Mread_buffer=62Mwrite_buffer= 62m [myisamchk] key_buffer=20Msort_buffer_size=20Mread_buffer=62Mwrite_buffer= 62m [mysqlhotcopy] interactive-timeout

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.