linux host question - GoFuckYourself.com

zentz · 04-07-2005, 03:38 AM

sometimes i get mysql errors like "too many connections" etc..

someone told me i should change MaxClients number in my httpd.conf file.. is it safe if i put it to lets say... 2000 ? any recommendations ?

the default is 150, i changed it to 1500 but i still get these errors from time to time... isnt that weird that i have over 1500 users connected at the same time ?

zentz · 04-07-2005, 03:46 AM

Error
User blablabla_me87 has already more than 'max_user_connections' active connections

Query
MySQL Connection

Does this have to do anything with maxclients anyway ?

pstation · 04-07-2005, 03:46 AM

if its mysql, httpd.conf will be irrelevant, i'll post the solution in a minute

pstation · 04-07-2005, 03:51 AM

Login to mysql as root, select the "mysql" database.

run this query:

Code:

UPDATE mysql.user SET max_connections=2000 WHERE User='blablabla_me87' LIMIT 1

and then run the query "FLUSH PRIVILEGES;"

zentz · 04-07-2005, 03:51 AM

Quote:

Originally Posted by pstation

if its mysql, httpd.conf will be irrelevant, i'll post the solution in a minute

thanks. btw, could you tell me to what number should i set my MaxClients to.. is 1500 too high ?

zentz · 04-07-2005, 03:52 AM

Quote:

Originally Posted by pstation

Login to mysql as root, select the "mysql" database.

run this query:

Code:

UPDATE mysql.user SET max_connections=2000 WHERE User='blablabla_me87' LIMIT 1

and then run the query "FLUSH PRIVILEGES;"

you have icq ?

pstation · 04-07-2005, 03:54 AM

Quote:

Originally Posted by zentz

thanks. btw, could you tell me to what number should i set my MaxClients to.. is 1500 too high ?

I'm not sure about that but setting it too high may cause there to be too many child processes, which is a bad thing since it will eat away your memory, but i'm not totally sure as i havent really messed around with apache in a few years.

pstation · 04-07-2005, 03:54 AM

yah, 120671981

04-07-2005, 03:38 AM	#1
zentz Confirmed User Industry Role: Join Date: Nov 2003 Posts: 8,053	linux host question sometimes i get mysql errors like "too many connections" etc.. someone told me i should change MaxClients number in my httpd.conf file.. is it safe if i put it to lets say... 2000 ? any recommendations ? the default is 150, i changed it to 1500 but i still get these errors from time to time... isnt that weird that i have over 1500 users connected at the same time ? __________________ Programs that owe me money ---- Epassporte.com ~ $2700 \| Protraffic.com ~ $2600 \| XonDemand.com ~ $3000 Email: [email protected] Last edited by zentz; 04-07-2005 at 03:40 AM..

04-07-2005, 03:46 AM	#2
zentz Confirmed User Industry Role: Join Date: Nov 2003 Posts: 8,053	Error User blablabla_me87 has already more than 'max_user_connections' active connections Query MySQL Connection Does this have to do anything with maxclients anyway ? __________________ Programs that owe me money ---- Epassporte.com ~ $2700 \| Protraffic.com ~ $2600 \| XonDemand.com ~ $3000 Email: [email protected]

04-07-2005, 03:51 AM	#4
pstation Confirmed User Join Date: Jul 2003 Location: chicago Posts: 1,135	Login to mysql as root, select the "mysql" database. run this query: Code: UPDATE mysql.user SET max_connections=2000 WHERE User='blablabla_me87' LIMIT 1 and then run the query "FLUSH PRIVILEGES;"

04-07-2005, 03:54 AM	#8
pstation Confirmed User Join Date: Jul 2003 Location: chicago Posts: 1,135	yah, 120671981