linux host question

[zentz]

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]

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]

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

[pstation]

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

run this query:

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

and then run the query "FLUSH PRIVILEGES;"

[zentz]

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]

Originally Posted by pstation

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

run this query:

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

and then run the query "FLUSH PRIVILEGES;"

you have icq ?

[pstation]

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]

yah, 120671981