[rt-users] TicketHistory slow on 4.2.0

[Tod Detre]

I've had the mysql slow log on, but it does not show any slow queries.

Another interesting point, the mobile site does not seem to have the same
problem.


On Wed, Oct 23, 2013 at 12:34 PM, Alex Vandiver <alexmv at bestpractical.com>wrote:

> 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
>
>
>
>


-- 
Tod
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131023/f090bda1/attachment.htm>