DirectAdmin面板Mysql优化my.cnf
vi /etc/my.cnf按i
然后复制如下配置文本：[*]
[*]local-infile=0
[*]skip-locking
[*]query_cache_limit=1M
[*]query_cache_size=32M
[*]query_cache_type=1
[*]max_connections=500
[*]interactive_timeout=100
[*]wait_timeout=100
[*]connect_timeout=10
[*]thread_cache_size=128
[*]key_buffer=16M
[*]join_buffer=1M
[*]max_allowed_packet=16M
[*]table_cache=1024
[*]record_buffer=1M
[*]sort_buffer_size=2M
[*]read_buffer_size=2M
[*]max_connect_errors=10
[*]# Try number of CPU's*2 for thread_concurrency
[*]thread_concurrency=2
[*]myisam_sort_buffer_size=64M
[*]server-id=1
[*]
[*]
[*]err-log=/var/log/mysqld.log
[*]open_files_limit=8192
[*]
[*]
[*]quick
[*]max_allowed_packet=16M
[*]
[*]
[*]no-auto-rehash
[*]#safe-updates
[*]
[*]
[*]key_buffer=64M
[*]sort_buffer=64M
[*]read_buffer=16M
[*]write_buffer=16M
[*]
[*]
[*]key_buffer=64M
[*]sort_buffer=64M
[*]read_buffer=16M
[*]write_buffer=16M
[*]
[*]
[*]interactive-timeout复制代码替换my.cnf内的文本。
保存后
然后重启Mysql
/sbin/service mysqld restart
.....优化要根据具体环境配置,具体使用情况,这样优化的结果才会最好
因为每个人Mysql使用级都不可能太一样的 呵呵
飘过....嘿嘿
loveliness.gif
上面所发来自DirectAdmin官网，适合普通用户
smile.gif
页:
[1]