On Wed, 2013-10-23 at 12:27 -0400, Tod Detre wrote: > Mysql 5.5.23 You'll want to turn on the MySQL slow query log to find what SQL queries are taking overly long -- see http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html for instructions, but they mostly boil down to setting http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_slow_query_log
Providing `SHOW INDEXES FROM Transactions` and `SHOW INDEXES FROM Attachments` may also be useful. - Alex
