DirectAdmin面板Mysql优化my.cnf

cpuer

vi /etc/my.cnf
按i
然后复制如下配置文本：[ol]

[mysqld]

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

[safe_mysqld]

err-log=/var/log/mysqld.log

open_files_limit=8192

[mysqldump]

quick

max_allowed_packet=16M

[mysql]

no-auto-rehash

#safe-updates

[isamchk]

key_buffer=64M

sort_buffer=64M

read_buffer=16M

write_buffer=16M

[myisamchk]

key_buffer=64M

sort_buffer=64M

read_buffer=16M

write_buffer=16M

[mysqlhotcopy]

interactive-timeout[/ol]复制代码替换my.cnf内的文本。
保存后
然后重启Mysql
/sbin/service mysqld restart

zyypp

.....优化要根据具体环境配置,具体使用情况,这样优化的结果才会最好
因为每个人Mysql使用级都不可能太一样的 呵呵
飘过....  嘿嘿

cpuer

上面所发来自DirectAdmin官网，适合普通用户