1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| # cp /etc/my.cnf /etc/my.cnf.default
# vim /etc/my.cnf
[client] default-character-set=utf8
[mysql] default-character-set=utf8
[mysqld]
character-set-server=utf8 default-storage-engine=INNODB
default-time-zone="+8:00" explicit_defaults_for_timestamp=true
max_allowed_packet=64M
back_log=800 max_connections=5000 table_open_cache=614 sort_buffer_size=2M join_buffer_size=2M
thread_cache_size=300 query_cache_size=64M query_cache_limit=4M query_cache_min_res_unit=2k
tmp_table_size=256M key_buffer_size=2048M read_buffer_size=1M read_rnd_buffer_size=16M bulk_insert_buffer_size=64M
innodb_buffer_pool_size=2048M innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=8M innodb_log_file_size=128M innodb_log_files_in_group=3
|