my.cnf

| | Comments (1)

參考 gslin 這篇「無論如何都應該修改的 MySQL 預設值
max_connect_errors=100
max_connections=1000
thread_cache_size=200
connect_timeout=20
skip-name-resolve
slave_net_timeout=30

max_connections 太小若連線數滿就會出現 Too many connections
show variables where Variable_name='max_connections'; 可以看目前的值
show status where Variable_name='Threads_cached'; 可以看目前的連線數

1 Comments

這樣的設定還是不夠吧?

max_connect_errors 放個 10000 都不嫌多;
connect_timeout 可以放到 60。

Leave a comment

凱莉手工坊

凱莉手工坊

November 2009

Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30          

About this Entry

This page contains a single entry by Pank published on November 12, 2009 4:41 PM.

Google paid storage getting cheaper was the previous entry in this blog.

理想的高清播放機 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.