FogBugz speed issue – an example of MySQL slow queries troubleshooting

We are using FogBugz application for the bugs and support requests tracking. And it’s configured to receive support@companyname.com emails (means tons of spam). Once the database size hit approximately 20,000 requests, we started really wonder: why so slow? It looks like there was another table BugEvent which size is around 200,000 records at that time. It could be some other application, could be your own code. Doesn’t matter – just it happens, one database size grows, performance of the application is degrading. First step to troubleshoot – enable slow queries log in the MySQL...