Tagged Questions
0
votes
0answers
44 views
MySQL max_connections Changed Without Notice
I'm running a Linux (512MB of RAM) server with MySQL 5.1.
I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would ...
0
votes
1answer
165 views
mysql fine tuning: open_tables, opened_tables
I'm a novice to database administration and have been depending on forum suggestions and answers to help resolve my database hang ups and too many connections errors; I've managed to reduce the ...
0
votes
1answer
169 views
Show processlist / Max concurrent connections seem to max out at 131
When I put my database under a load test (basically just a basic write and basic read from our app), and run show processlist; in the middle of it, there is always 131 rows in the set and that's it. ...
0
votes
1answer
56 views
Mysql not closing connections
I have a Java application that configured with a connection pool. I have ensured that the application terminates the connections properly.
However when I run this command on mysql command line -
...
0
votes
1answer
556 views
Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
I always wonder, why does the max_used_connections value not come down, once it reaches the peak value of max_connections?
I always flush the status and bring down this value to avoid DB connection ...
1
vote
1answer
126 views
Sudden MySQL connection issue
We have almost 60 network guys working via a proxy server, developing on one Linux-based in-house server.
Suddenly, it is saying to everyone:
Warning: mysql_connect() [function.mysql-connect]:
Too ...
1
vote
1answer
131 views
“Mysql server has gone away” debugging methods
I have been repeatedly facing the issues with mysql on my server recently. I have tried changing "wait_timeout" , "connect_timeout" and several options which I found using google. Are there any ...
4
votes
1answer
979 views
What are user connections - when are the created and destroyed?
We've been getting an intermittent error on out site:
Warning: mysql_connect() [function.mysql-connect]: User '557574_prod' has exceeded the 'max_user_connections' resource (current value: 10)
...
14
votes
3answers
8k views
How do you calculate mysql max_connections variable?
How do you calculate mysql max_connections ?
What do you take into consideration ?
