[rt-users] TicketHistory slow on 4.2.0

Alex Vandiver alexmv at bestpractical.com
Wed Oct 23 12:34:44 EDT 2013


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






More information about the rt-users mailing list