[client-server] !includedir /etc/my.cnf.d [mysqld] log-error = /var/lib/mysql/109-110-188-195.cprapid.com.err performance-schema = 0 max_allowed_packet = 268435456 open_files_limit=80000 innodb_buffer_pool_size = 80G innodb_file_per_table = 1 unix_socket = OFF tmp_table_size=1075M max_heap_table_size=1075M innodb_log_file_size=6G key_buffer_size=399M max_connections=1000 max_user_connections = 100 sql_mode='' thread_cache_size = 100 # from 9 to reduce threads_created count (expensive operation) thread_stack = 192K interactive_timeout = 180 query_cache_type = 1 query_cache_limit = 256K query_cache_size = 64M query_cache_min_res_unit = 512 join_buffer_size=178M sort_buffer_size = 4M read_rnd_buffer_size = 128K # from 256K to reduce handler_read_rnd_next RPS of 97 innodb_io_capacity = 1900 # from 200 to use more of your SSD io capacity read_buffer_size = 256K # from 128K to reduce handler_read_next RPS of 1,744 [mysqldump] quick SIMPAN PERUBAHAN