LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   max_connections in mysql (https://www.linuxquestions.org/questions/linux-newbie-8/max_connections-in-mysql-777048/)

Dshah 12-20-2009 09:56 AM
max_connections in mysql
 
hi i have centos vps whch i am connecting through putty from my local windows 7, mostly things were installed by my provider, now the problem is some of my website pages give me error sometime cant connect to database, my provider told me to increase max_connections in mysql setting maybe it could help, i don't know where to look that file, i did this # nano /etc/my.cnf and i saw the file has only two lines as below:

[mysqld]
local-infile=0


please any help how can i change maz_connections. i am very new to this all.

Thanks for the support

TB0ne 12-20-2009 10:22 AM
Quote:
Originally Posted by Dshah (Post 3798935)
hi i have centos vps whch i am connecting through putty from my local windows 7, mostly things were installed by my provider, now the problem is some of my website pages give me error sometime cant connect to database, my provider told me to increase max_connections in mysql setting maybe it could help, i don't know where to look that file, i did this # nano /etc/my.cnf and i saw the file has only two lines as below:

[mysqld]
local-infile=0

please any help how can i change maz_connections. i am very new to this all.
Well documented on the MySQL site, Google leads you to it:
http://dev.mysql.com/doc/refman/5.1/...nnections.html


All times are GMT -5. The time now is 04:31 AM.