Shulou(Shulou.com)06/01 Report--

The following brings you a simple way to expand the tablespace of the MySQL system, if you are interested, let's take a look at this article. I believe that the simple method of expanding the tablespace of the MySQL system will be of some help to you.

1. System table space expansion method 1: add autoextend parameter after innodb_data_file_path parameter innodb_data_file_path=ibdata1:12M:autoextend method 2: add a new data file innodb_data_file_path= / ibdata/ibdata1:988M;/disk2/ibdata2:50M: autoextend 2 after innodb_data_file_path parameter, operation step 1. Modify the parameter innodb_data_file_path2. Close the database, shutdown3. Start the database, mysqld_safe & 4. Verify whether the parameters are valid show variables like 'innodb_data_file_path'; III, case 1. View the default parameter mysql > show variables like 'innodb_data%' +-+ | Variable_name | Value | +-+ | innodb_data _ file_path | ibdata1:12M:autoextend | | innodb_data_home_dir | / zxdata/my3311/data | +-+ 2 rows in set (0.00 sec) 2. Close the database mysql > shutdown;3. Modify the my.cnf parameter file [root@roidb1 ~] # grep "path" / zxdata/my3311/etc/my.cnfinnodb_data_file_path = ibdata1:12M;ibdata2:50M:autoextend4. Start the database # / usr/local/mysql/bin/mysqld_safe-- defaults-file=/zxdata/my3311/etc/my.cnf & 5. Verify whether it is in effect mysql > show variables like 'innodb_data%' +-+ | Variable_name | Value | + -- + | innodb_data_file_path | ibdata1:12M Ibdata2:50M:autoextend | | innodb_data_home_dir | / zxdata/my3311/data | +-+

2 rows in set (0.01sec)

Read the details of the above simple method of expanding the tablespace of the MySQL system, and whether you have gained anything. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.