Innodb system table space maintenance method

Environmental Description:

There is a running MySQL environment. Because the previous configuration file settings were too simple (no innodb_data_file_path changes were configured), the system table space is now full.

If innodb_data_file_path has not been set before, it will use the default value: innodb_data_file_path=ibdata1:12M; the problem lies here that it is not set

autoextend

Solution:

1. Shut down the already running MySQL

mysqladmin -h127.0.0.1 -uroot -pxxxx shutdown

2. Add a second system tablespace file for mysql, set its size and add the autoextend attribute

[mysqld]
innodb_data_file_path = ibdata1:12M;ibdata2:12M:autoextend

3. Restart mysql

service mysqld start

By the way, if you want to reduce the system table space, you can do it. Generally speaking, you have to start with one;

The general steps are as follows

1. Back up your database with mysqldump

2. Close your mysql database and delete the files under datadir

3. Edit the configuration file to your desired configuration and re-initialize a new MySQL database

4. Restore the database from the dump file in the first step

The above innodb system tablespace maintenance method is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.