Welcome to the FogBugz Knowledge Exchange

Question

0

I've been intermittently looking at slow response times from our FB instance, even for 'simple' requests for a single bug. One thing I've noticed is that FB only ever seems to have four connections to MySQL (as shown in 'Server Connections' in MySQL administrator), and when I make multiple 'concurrent' requests from a single client (ie reload a bunch of tabs in my browser) then it looks as though all my requests are being channelled down a single MySQL connection.

What is the expected behaviour here? It might make sense to force a single user down a single MySQL connection to avoid DOS when a user makes a lot of requests, but for a server supporting ~30 users only 4 DB connections seems a bit limiting - it's easy to imagine that four users could be running 'complex' queries for a large number of bugs and thus significantly delay all other access...

I can't find anything in the FB/IIS/MySQL configurations to control the number of concurrent DB connections - but maybe I'm missing something?

Also, are there any good resources on sensible MySQL configuration on Windows for 'best' FB performance?

flag	asked Jan 28 2010 at 10:46 Matt 55●6

	Also, we're currently running MySQL 5.0.37 - any strong reasons to upgrade to a newer 5.0.x version, or even 5.1.x? – Matt Jan 28 2010 at 11:07
	FogBugz 7 currently has a minimum version of 5.0.45. Some of the new queries aren't parsed correctly with older versions. Not a problem until you upgrade. – Ted♦ Feb 16 2010 at 19:54

Brett Kiefer · Accepted Answer · 2010-02-15 20:01:59Z UTC

1

First, could you check your my.ini and make sure that your max_connetions isn't dialed down to 4? I believe the default is 100.

If that looks okay, I would update to a more recent MySQL, and to FogBugz 7, which will take the MyODBC connector (a possible culprit) out of the loop.

answered Feb 15 2010 at 20:01

Brett Kiefer♦♦
2,710●3●5

	Thanks max_connections is currently 800 (not sure why so high...) We're planning to build a new server and install up-to-date MySQL plus FB7, but this is going to take some time. – Matt Feb 25 2010 at 13:02
	Hadn't rechecked this since upgrading to FB7 (and rebuilding our MySQL DB from scratch) and it now looks 'fine' - if I bounce my browser with 30+ tabs open on different bugs then I see that the number of DB connections grows while FB is servicing these queries. Currently it's showing 14 connections from the IIS server for example. – Matt Feb 3 2011 at 11:52

FB 6.x, Windows, MySQL - DB connections limited to 4?

1 Answer