My.Cnf File Issue on Linux Dedicated Server Running CentOS

Submitted by NewMusicPromote on Fri, 09/25/2009 - 08:10

Dear Anyone.

Hello i came across this website doing a search for My.Cnf tweeks or configurations for the SQL_Max_Connections and i was wondering some things. I have a Linux CentOS system with 2.5 gigs of Ram, Running Apache. and PHP. what would be the "proper" My.cnf file settings for a Music Website i keep getting a max connection overload on the network.

Matthew Nalett
New Music Promote
http://www.newmusicpromote.com

Here is my current My.Cnf settings.
Any Suggestions on how to optimize this for a Music Network?

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

query_cache_type=1
query_cache_limit=20M
query_cache_size=40M
max_allowed_packet=40M
max_connections=4000
key_buffer=258M
[mysql.server]
user=mysql
basedir=/var/lib

[mysqldump]
quick
max_allowed_packet=16M

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192