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

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)

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.