I have a problem with my site regularly exceeding Max User Connections. The limit from my hosting provider is 10 and I am regularly exceeding this amount for 1 database user.
I'm unsure if this is due to a Coding Error / stuck or errored cfthread / malicious attack / or some other issue.
I was thinking of coding in a fix to Automatically kill processes when the site starts to error out (exceed Max_User_Connections) to limit the amount of downtime.
Does Coldfusion allow you to run the SHOWPROCESSLIST and/or KILL methods (mySQL) in a CFQUERY. If so, would anyone recommend putting in a KILL function within application.cfc? If so, which method should I put it in? OnError or Other? Anyone have any other ideas?