Mysql database option settings (solved the repair with keycache problem) Today, I imported a database backup file to mysql. After running for a while, I found that it was stopped for a long time. I monitored it with workbench, the repair with keycache statement is found to be slow and some queries are made online. The two parameters are optimized to set myisam_max_sort_file_size and myisam_sort_buffer_size. The default values of these two parameters are
Java code myisam_max_sort_file_size = 2G myisam_sort_buffer_size = 8 M www.2cto.com modify the configuration file to (if there is no such two parameters, add) java code myisam_max_sort_file_size = 10G myisam_sort_buffer_size = 64 M. After that, the import program runs much faster than before, and the repair with keycache statement does not appear again. If it appears again, the two parameter values will be increased. Author lwjlaser