What should I do if mysql error code 1114 occurs?
- coldplay.xixiOriginal
- 2020-10-23 16:28:074139browse
The solution to the error code 1114 in mysql: first modify [max_heap_table_size = 256M] [tmp_table_size = 256M] in [my.cnf]; then restart the MySQL service.
Solution to error code 1114 in mysql:
1. Modify max_heap_table_size = 256M in my.cnf tmp_table_size = 256M, restart the MySQL service
2. Check innodb_data_file_path = ibdata1:10M:autoextend in my.cnf. The original size is allocated 10M, and it will automatically grow after exceeding it. The maximum growth can be set.
innodb_data_home_dir can configure where the ibdata1 file is stored. You can also configure the directory directly in the innodb_data_file_path parameter. If you do not specify home, it will be in the data directory under the MySQL home directory.
More related free learning recommendations: mysql tutorial(Video)
The above is the detailed content of What should I do if mysql error code 1114 occurs?. For more information, please follow other related articles on the PHP Chinese website!