Fogbugz has been very slow since we upgraded to 8.0.26 (Unix install).
When I run 'top' on the Fogbugz server, MySQL and Mono regularly take up a large chunk of the available CPU and Memory: Mono is currently using 184%CPU and 14%Memory at the moment. The server has 4 CPU cores and 3GB of RAM.
I've noticed the resource hogging behavior for the last few days. At times the site actually becomes unavailable. When this happens the only solution I have found is to stop the fogbugzctl daemon and wait for Mono and MySQL to calm down. Typically the Mono process never comes down and continues reporting 400% to 9999% CPU usage in these extreme cases. I am eventually forced to kill the rogue Mono process and restart fogbugzctl.
We've seen some of this type of behavior in past releases, but never to this degree. Do you have any suggestions on debugging this problem? or any ideas on potential culprits to investigate?