MySQL max_connections configuration
I'm running a FreeBSD 5.2.1 box for hosting purpose.
The server is AMD 2800 with 1024M RAM.
Most of my clients are hosting PHP+MySQL forums.
So I decided to tweak the my.cnf file.
My my.cnf file as followed:
--------------------------------------------
[mysqld]
set-variable = max_connections=1500
safe-show-database
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
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
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[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
--------------------------------------------
I don't think 1500 connections is enough as I'm hosting some high traffic forum.
However, I heard some people saying that, if you set the max_connections above 1500, mysql will get unstable, and cause some trouble. Is this true?
Please post any commnet regarding to this. I'll be more than happy if you guys could provide me some better configuration.
Thanks in advance!
