Zip is the system summary and mysql summary downloaded from pmm.
There is no error in the error log.
OS: RHEL 6.5 x64
MEMORY: 64G
Replication: M-M
my-5.7.22 configuration:
##Global
innodb_buffer_pool_size = 20G
key_buffer_size = 2M
tmp_table_size = 64M
max_heap_table_size = 64M
innodb_log_buffer_size = 4M
Per connection
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 2M
join_buffer_size = 2M
binlog_cache_size = 4M
Others
myisam_sort_buffer_size = 4M
myisam_max_sort_file_size = 10G
bulk_insert_buffer_size = 16M
Query cache OFF
query_cache_size = 0
query_cache_type = 0
Threads
thread_stack = 512K
thread_cache_size = 500
my-5.6.32 configuration:
##Global
innodb_buffer_pool_size = 30G
key_buffer_size = 8M
tmp_table_size = 64M
max_heap_table_size = 64M
innodb_log_buffer_size = 8M
Per connection
read_buffer_size = 16M
read_rnd_buffer_size = 16M
sort_buffer_size = 16M
join_buffer_size = 16M
binlog_cache_size = 4M
Others
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
bulk_insert_buffer_size = 32M
Query cache OFF
query_cache_size = 0
query_cache_type = 0
Threads
thread_stack = 512K
thread_cache_size = 1000