Reputation
Top tag
Next privilege 10 Rep.
Answer protected questions
Badges
2
Newest
 Student
Impact
~142 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Oct
17
comment MySQL server hangs without reason
I have been raising max connections from 10 to 40. Reason of raising was that while having little amount of connections web clients often got "database server unavailable" error. On 40 connections quantity of such errors isn't that large and CPU load reaches 100% reasonable often. What is the proper approach? Keep amount of max connections to MySQL server small and queue HTTP requests on Apache side until connection is freed up? Or allow unlimited amount of MySQL connections and investigate MySQL load?
Oct
8
comment MySQL server hangs without reason
I'm increasing number of connections slowly. But 10 connections weren't initially set. Initially there was no setting, so I assume it was some large default value. This raises a question - shouldn't amount of connections be reasonable unlimited? If I have one connection per HTTP request it shouldn't be a problem, should it?
Oct
5
comment MySQL server hangs without reason
I have slow query logging. slow-query log is exactly the result of that :-) max_connections = 10 max_used _connections = 11
Sep
25
awarded  Student
Sep
25
asked MySQL server hangs without reason
Jan
7
awarded  Tumbleweed