How to reconfigure MySQL Database Engine innodb in Linux

Sometimes, we need to reconfigure it because of our work needs.MySQLDatabase EngineInnodb. HowLinuxHow can I reconfigure the MySQL database engine innodb in the system? In this article, we will introduce this part of content. Let's take a look at it together!

1) Stop the mysql service.

[Root @ mysql ~] # Service mysqld stop.

2) modify the mysql configuration file.

[Root @ mysql ~] # Vi/etc/my. cnf.

3) delete files containing ib_logfile1 and ibdata in the datedir folder.

4) create a mysqldata folder in the root directory.

5) Enable the settings to take effect.

The content of my. cnf modification is as follows:

 
 

  
  
[mysqld]  
  
  
datadir=/var/lib/mysql  
  
  
socket=/var/lib/mysql/mysql.sock  
  
  
user=mysql 
  
  
# Default to using old password format for compatibility with mysql 3.x  
  
  
# clients (those using the mysqlclient10 compatibility package).  
  
  
old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks;  
  
  
# to do so, uncomment this line:  
  
  
# symbolic-links=0 default-storage-engine=InnoDB 
  
  
set-variable= transaction-isolation=READ-COMMITTED innodb_data_home_dir =  
  
  
innodb_data_file_path =/mysqldata/ibdata1:2000M;/mysqldata/ibdata2:2000M:autoextend innodb_buffer_pool_size=1G 
  
  
innodb_additional_mem_pool_size=20M 
  
  
innodb_log_file_size=256M 
  
  
innodb_log_buffer_size=8M 
  
  
innodb_flush_log_at_trx_commit=1 
  
  
innodb_lock_wait_timeout=50 
  
  
innodb_thread_concurrency=5 [mysqld_safe]  
  
  
log-error=/var/log/mysqld.log  
  
  
pid-file=/var/run/mysqld/mysqld.pid 
 
 

The configuration method of MySQL Database Engine innodb in Linux is introduced here. If you want to learn more about MySQL database, you can read the article here: http://database.51cto.com/mysql/, and I believe you can bring it to you!