Tag:mysql my.cnf optimization
[client]port = 3306socket = /tmp/mysql.sock[mysqld]port = 3306socket = /tmp/mysql.sockskip-external-lockinglog-error=/usr/local/mysql/log/error.logkey _buffer_size = 5gmax_allowed_packet = 50mtable_open_cache = 4000sort_buffer_size = 2mnet_buffer_length = 8kread_buffer_size = 2mread_rnd_buffer_size = 8Mmyisam_sort_buffer_size = 64Mthread_cache_size = 64query_cache_size = 256mthread_concurrency = 24character-set-server=utf8lower-case-table-names = 1log-bin= Mysql-binbinlog_format=mixedserver-id = 1sql_mode=no_engine_ Substitution,strict_trans_tables[mysqldump]quickmax_allowed_packet = 16m[mysql]no-auto-rehash[myisamchk]key_buffer_size = 20msort_buffer_size = 20mread_buffer = 2mwrite_buffer = 2m[mysqlhotcopy] Interactive-timeout
This article is from "Xiao Yang" blog, please be sure to keep this source http://princepar.blog.51cto.com/1448665/1650642
MySQL Optimized configuration file