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:
回复 2# 的帖子
上面所发来自DirectAdmin官网，适合普通用户 :)
页:
[1]