[mysqld] myisam_repair_threads=4 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M table_cache = 1024 thread_cache_size = 16K wait_timeout = 20 connect_timeout = 10 tmp_table_size = 128M max_heap_table_size = 128M max_allowed_packet = 160M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 16M query_cache_type = 1 [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 512M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M
Does adding the quick help with 10GB mysql database dumps every night?
I also added
myisam_repair_threads=4 would that help fix corrupted tables issues
sometimes it seems like dumping big databases causes corruptions