"Database" MySQL change the default engine to InnoDB step method

Objective

InnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application.

The basic differences are: MyISAM types do not support advanced processing such as transaction processing, and InnoDB type support. The MyISAM type of table emphasizes performance, which is performed more quickly than the InnoDB type, but does not provide transactional support, while InnoDB provides advanced database functionality such as transactional support and external keys.

Why should I change the default engine, in fact the reason is very simple, I use the MySQL default engine is MyISAM, and MyISAM does not support transaction processing, so I need to replace its engine.

Change the Mysql default engine to InnoDB steps as follows:

MySQL default is to turn off the use of the InnoDB storage engine, set InnoDB as the default engine as follows.

1. View the MySQL storage engine: mysql>show engines InnoDB | YES This MySQL database server supports the InnoDB engine.

2. Set InnoDB as the default engine: In the configuration file under my.ini [mysqld], adddefault-storage-engine=INNODB

3. Restart the MySQL server

4. Log in to the MySQL database and, mysql>show engines  if present InnoDB |DEFAULT , set InnoDB as the default engine for success.

Summarize

The above is to change the MySQL default engine for InnoDB all content, hope that the content of this article on everyone's study or work can bring some help, if there are questions you can message exchange.

"Database" MySQL change the default engine to InnoDB step method