In my process list I can see many, many threads with time over 30.000 and status SLEEP!! And after some time the server get stock with: "too many connections...".
I did increased alread max_connections but this is not a solution, I got more and more hints and I can not increased it infinitly...
So do you know guys how to set maximum timout for the threads? Or how to flush it in mysql query?
I tried query: "flush" but Im getting syntax error..
Thx for any help
I did increased alread max_connections but this is not a solution, I got more and more hints and I can not increased it infinitly...
So do you know guys how to set maximum timout for the threads? Or how to flush it in mysql query?
I tried query: "flush" but Im getting syntax error..
Thx for any help