The role and separation of ibdata in mysqlInnodb _ MySQL

The role and separation of ibdata in mysqlInnodb bitsCN.com

Functions and separation of ibdata of mysql Innodb

In the mysql INNODB data status, ibdata is used to store file data, while the table files in the folder of the database name are only structured. be careful that you cannot delete it, shared tablespace management will cause the tablespace cannot be reduced after it is allocated, so it will become larger and larger, so it is necessary to separate it.

Parameters of the independent tablespace of INNODB:

Innodb_file_per_table

The procedure is as follows:

1. backup database mysqldump-uroot-p -- all-database> c: /all_back_database.sql2. stop database mysqladmin -- host = localhost -- user = root -- password shutdown3. delete related files ibdata1ib_logfile * 4. manually delete all database folders except Mysql, then start the database net start mysql5 and restore the data mysql-uroot-p.

 

  
 

  


  
BitsCN.com