[rt-devel] Greatly increased query time after update to 4.2.9

[Jeff Albert]

Hi Chris,
Sadly a restart didn't help; the first query after the restart was even worse as the cache got repopulated, and performance has since returned to where I found it immediately after the upgrade. Thanks for the suggestion, though! Has anybody else seen this with 4.2.9 installs?

Cheers,
Jeff

-----Original Message-----
From: Christian Loos [mailto:cloos at netcologne.de] 
Sent: Wednesday, November 26, 2014 10:52 PM
To: Jeff Albert; rt-devel at lists.bestpractical.com
Subject: Re: Greatly increased query time after update to 4.2.9

Hi,

have you tried a mysql restart?
This fixed it for me (I didn't dig deeper what exactly was the problem).

Chris

Am 27.11.2014 um 02:11 schrieb Jeff Albert:
> I've just updated the development instance of our RT service, which 
> had been running at 4.0.8, to the latest 4.2.9 in preparation for a 
> planned production update to follow. Unfortunately, we've hit a 
> significant
> snag: the UI is now hugely slow in some views that were relatively 
> snappy before the update. The slow query log identifies a likely culprit: