Forums »
MySQL Forums And Topics Discussions About Open Source Database »
Too Many Connections

Too Many Connections

Description: this page will show you how you can fix the problem if you are getting Too many connections error on mysql/php server

Tags: too ,many ,connections

Posted On Mon Jan 05, 2009 By wallpaperama In MySQL Forums And Topics Discussions About Open Source Database Forums

today i was working on my wallpaper website and lately i've noticed that i have been getting alot of people on my site and while i was in the admin panel i kept getting an error saying:

Too many connections

so to fix this, this is what i did... i logged in to my dedicated server with ssh and loged in as root in the shell and send this command:

edit the my.cnf file to chage max_connections:

nano /etc/my.cnf

then add this line or change it to a higher number if you already have this variable: (i will increase it by 1000, the default its 100 for mysql server)

max_connections = 1000

save the changes and then restart your server:

/etc/init.d/mysqld restart

i will monitor to see how it goes

farahum Tue Jan 06, 2009

wow i can't believe i was able to find the solution to my problem i have been looking all over for this, very much thanks

Information

Title: Too Many Connections

Info: This Post Has Been Viewed 0 Times Since
Date: Mon Jan 05, 2009
Author wallpaperama Received 1 Replies #914

How To Mysql Select And Update In One Query