[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