Debugging Bad MySQL Performance

If your MySQL database seems to be bogged down, you can try enabling the slow queries log in MySQL and set the threshold to something like 10 seconds. When you have the actual queries that are causing MySQL to be sluggish, we can help you determine what might be going wrong in FogBugz.