My server is having some Mysql connection issues. I know that the number of queries has increased exponentially and I am also aware that the server is doing a lot more work. However, I am wondering if I can tweak some Mysql parameters to make things work better. Here are some details: Mysql frequently runs out of connections. I close every connection after I am done with it, and I try to reduce or break up all my slow queries. The server averages about 10 queries a second and the number of threads hover around mid 90s all the time. I have reduced the max_timeout and the connect errors to try and reduce the number of threads but that does not seem to make much of a difference. I have tried to increase the number of max connections and that just seems to grind the server to a halt. I […]
[Continue Reading...]
