[rt-users] RT 3.6.4 poor query performance

[Jeff Voskamp]

Ruslan Zakirov wrote:
> Jeff, always Cc the list.
>
> Version of your mysql server?
>
> As far as I can see you suffer from mysql bug, output from your server
> is equal in both cases what is really wrong and mysql must use new
> index in those test queries I sent to the list.
>
> There are several options:
> 1) Delete any indexes on CachedGroupMembers table which starts from
> MemberId column, but that will slowdown other queries and may be
> terribly, depends on proprotions of your DB.
> 2) Upgrade to mysql 5.0.45 or greater and create index I suggested in
> this thread earlier.
> 3) I have another idea how we can improve that in the code, but that
> needs more investigation with a lot of users' feedback and a lot of
> mine and users' time.
>
> As long as MySQL 4.x has ended its life time and 5.0.x is stable
> version then I think it's fair enough to recommend recent versions
> instead of continuose refactoring of the code to make all those broken
> mysqls happy.
>   
I'll try to remember to "reply all" from here on in.

We're on Mysql-5.0.22 as packaged by RedHat for Enterprise Linux 5.1.

Dropping indexes for now.  Can re-instate later. Then I can also drop my 
coding hacks.

Will look into getting a shiny new MySQL.

jeff Voskamp