version | 5.5.53 | >= 5.6 |
collation_server | utf8_general_ci | utf8_general_ci |
character_set_client | utf8 | utf8 |
max_connections | 512 | >= 100 |
max_heap_table_size | 16M | >=0M |
max_allowed_packet | 1048576 | >= 16777216 |
tmp_table_size | 64M | >= 64M |
join_buffer_size | 0.125M | >= 64M |
innodb_file_per_table | OFF | ON |
innodb_buffer_pool_size | 47M | >=2M |
innodb_doublewrite | ON | OFF |
innodb_additional_mem_pool_size | 2M | >= 80M |
innodb_lock_wait_timeout | 50 | >= 50 |
innodb_flush_log_at_trx_commit | 1 | 2 |
来自mysql 监控工具 cacti 的配置文件:https://www.cacti.net/