key_buffer = 2324M max_allowed_packet = 32M table_cache = 2048 join_buffer_size = 52M sort_buffer_size = 52M read_buffer_size = 52M read_rnd_buffer_size = 52M myisam_sort_buffer_size = 680M query_cache_size = 484M query_cache_limit = 2M max_tmp_tables = 128 tmp_table_size = 694M max_heap_table_size = 656M thread_cache = 48 thread_concurrency = 16 max_connections = 384 max_user_connections = 120 max_connect_errors = 99999999 wait_timeout = 86400 interactive_timeout = 86400 long_query_time = 1 slow_query_log = /data0/mysql/slow-queries.log back_log = 600 myisam_repair_threads = 1 myisam-recover = DEFAULT expire_logs_days = 8 sync_binlog = 1 加上之后，重启数据库 service mysqld restart 搞定
原文：https://www.cnblogs.com/pebblecome/p/14312224.html