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.co
Here is my current My.Cnf settings.
Any Suggestions on how to optimize this for a Music Network?
[mysqld]
set-variable=local-infile=0<
socket=/var/lib/mysql/mysql.
# 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<
open_files_limit=8192Bookmark/Search this post with
- NewMusicPromote's blog
- Login or register to post comments