MySQL running on Windows 7 64 bit.
I'm trying to track down a leak of connections, I'm pretty sure the only ASP.NET app using the server is at fault here.
We received the "Too many connections" error and checking the server we saw many connections with status
I know that, fiddling with
my.cf, MySQL can be forced to close sleeping connection after a shorter time, but I would rather fix the actual problem instead of the symptoms.
So I was wondering if there's a way to retrieve the SQL statement that was last executed on a given connection. I think if I could do that on older sleeping connections, I might have an easier time tracking down this leak.
Of course, if anyone can think of an alternative solution for this scenario, any suggestion is very welcome.