Question

MySQL seems to be bogging down. How can I find what it's spending its time on?

Answer 1

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.

Answer 2

Howdy,

I know this is kind of old but you could use the msyqltuner.pl to check the server out.

wget mysqltuner.pl #don't worry it is redirected to the latest version

perl mysqltuner.pl --nogood 

If you're getting errors about fragmented tables add this to your cron now and again.

0 2 * * * mysqlcheck -oA #this alone typically helps

This assumes the MySQL server can be connected w/o using a password. You may need to add in the user and password options depending on your local .my.cnf for the given user.

Thanks!

--Eric