cpanel mysql优化

发布于 2014-02-10  107 次阅读

  1. 备份 my.cnf 文件
    # cp /etc/my.cnf /etc/my.cnfbackup
  2. 编辑 my.cnf 文件 
    #nano -w /etc/my.cnf 
    加入以下代码或替换现有 my.cnf 文件 ：

[mysqld]

open_files_limit=50000

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

query_cache_limit=8M

query_cache_size=256M

query_cache_type=1

max_connections=500

max_user_connections=10

interactive_timeout=20

wait_timeout=20

connect_timeout=6

thread_cache_size=128

key_buffer=16M

join_buffer=1M

max_allowed_packet=16M

table_cache=1024

sort_buffer_size=2M

read_buffer_size=2M

max_connect_errors=10

# Try number of CPU's*2 for thread_concurrency

thread_concurrency=8

myisam_sort_buffer_size=64M

#log-bin

server-id=1

 

[mysqldump]

quick

max_allowed_packet=16M

 

[mysql]

no-auto-rehash

#safe-updates

 

[isamchk]

key_buffer=32M

sort_buffer=32M

read_buffer=16M

write_buffer=16M

 

[myisamchk]

key_buffer=32M

sort_buffer=32M

read_buffer=16M

write_buffer=16M