[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