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

You cannot increase the size of an existing system tablespace data file by changing its size attribute. For example, changing the innodb_data_file_path setting from ibdata1:10M:autoextend to ibdata1:12M:autoextend produces the following error when starting the server: the error message is as follows: [ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file'. / ibdata1' is of a different size 640pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages the error indicates that the existing data file size (expressed in InnoDB pages) is different from the size specified in the configuration file. If you encounter this error, restore the previous innodb_data_file_path setting, and refer to the system tablespace resizing instructions. The default parameters are as follows: innodb_data_file_path=ibdata1:12M:autoextend wants to directly resize the system tablespace, and the following adjustment will directly report an error. Innodb_data_file_path=ibdata1:100M:autoextend View the official document https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html

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.