![]() |
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 ? |
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 ? |
if its mysql, httpd.conf will be irrelevant, i'll post the solution in a minute
|
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 |
Quote:
|
Quote:
|
Quote:
|
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