Hi,
We are having on weird issue since couple of days it was working fine before without any issue, our vicidial database stop responding after as soon as we cross logged in agents above 120 to150. Connected threads hits max value no matter what value I configure there, I see hundreds of table level lock queries in mysql. One database has with 16GB RAM, 16 core processor, max connections set to 400, about 200 agents login at the same time. I noticed one thing, on web servers there are many many TIME_WAIT to database server. Any help please?