How to reconfigure MySQL database engine innodb under Linux system

This article mainly explains "how to reconfigure MySQL database engine innodb under Linux system", the explanation content in this article is simple and clear, easy to learn and understand, please follow the idea of Xiaobian slowly, study and learn "how to reconfigure MySQL database engine innodb under Linux system"!

1)Stop the MySQL service.

[chinastor.com-root@mysql~]#servicemysqldstop。

2)Modify mysql's configuration file.

[chinastor.com-root@mysql~]#vi/etc/my.cnf。

3)Delete files containing ib_logfile1 and ibdata under datedir folder.

4)Create the mysqldata folder in the root directory.

5)Start to make settings take effect.

How to reconfigure MySQL database engine innodb on Linux

My.cnf was amended to read as follows:

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql#Defaulttousingoldpasswordformatforcompatibilitywithmysql3.x#clients (thoseusingthemysqlclient10compatibilitypackage).old_passwords=1#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityrisks;#todoso,uncommentthisline:#symbolic-links=0default-storage-engine=InnoDBset-variable=transaction-isolation=READ-COMMITTEDinnodb_data_home_dir=innodb_data_file_path=/mysqldata/ibdata1:2000M;/mysqldata/ibdata2:2000M: autoextendinnodb_buffer_pool_size=1Ginnodb_additional_mem_pool_size=20Minnodb_log_file_size=256Minnodb_log_buffer_size=8Minnodb_flush_log_at_trx_commit=1innodb_lock_wait_timeout=50innodb_thread_currency =5[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid Thank you for reading, the above is "how to reconfigure MySQL database engine innodb under Linux system" content, after learning this article, I believe everyone on how to reconfigure MySQL database engine innodb under Linux system This problem has a deeper understanding, the specific use of the situation still needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!