mysql 5.1.73 优化_一份生产环境下MySQL服务配置优化参考/CentOS 6.x MySQL 5.1.73

环境 CentOS 6.x 自带的MySQL 5.1.73

在原始配置文件  /etc/my.cnf 基础上，在 [mysqld] 节内增加配置参数。实际应用中，请按硬件及负载酌情修改。

#add by feng 120418  --------------------------

#skip-locking

skip-name-resolve

skip-external-locking

key_buffer_size = 256M

#table_cache = 3072

table_open_cache = 3072

read_buffer_size = 2M

read_rnd_buffer_size = 2M

sort_buffer_size = 2M

myisam_sort_buffer_size = 256M

thread_cache_size = 8

query_cache_size= 512M

query_cache_limit= 5M

tmp_table_size=1024M

max_heap_table_size=3000M

max_allowed_packet = 16M

innodb_buffer_pool_size = 512M

innodb_log_file_size = 512M

innodb_additional_mem_pool_size=512M

innodb_log_buffer_size=64M

max_connections=2000

max_user_connections=800

join_buffer_size = 8M

open_files_limit = 65535

#tmpdir=/dev/shm

max_connect_errors=1000

#add by feng 120418  end ---------------------