GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   linux host question (https://gfy.com/showthread.php?t=453080)

zentz 04-07-2005 03:38 AM

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 ?

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


All times are GMT -7. The time now is 08:00 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123