Hi there,
im running Fogbugz Version 7.1.10 (DB 736, Build 1382) here on MySQL 5.0.45. My problem is that Fogbugz keeps using up all connections and then leaves the them in "Idle" state, instead of closing them. I have seen connection idling for 30 minutes or more, and if i don't set a connection limit for the Fogbugz user in MySql it keeps using up all available connection - even if nobody is logged on. Connections are a limited resource, so whenever the database hits the connection limit of 200 all the other applications that rely on our database (forums, support system, website etc.) throw an error "connection limit reached".
I set the Connection limit to 5 for the MySql user 'Fogbugz' now so at least the other application won't break, but every couple of days i have to go into the database and kill the idle connections, because Fogbugz complains that it cannot create more connections. is there a way to fix this? It seems quite a resource hog; our database load has pretty much doubled since we updated from our previous (slightly dated) version to 7.1.10 a few weeks ago, and from my stats it looks like Fogbugz alone is doing ~10 queries each second. It seems quite a lot to me, there are only 15 users in the Fogbugz user table, and maybe 5 of them check Fogbugz once or twice a day. Is there a way to slow it down?
