[rt-users] 2.0.9 bogs with >10K tickets

[Steve Poirier]

Hi Darren,

Check at archive there are some posts on indexes you can apply to your db
which greatly improves performance if you hardware is suitable for the
operations of your box. 10,000 tickets is relativaly small for a MySQL
database considering the schema of the archive.

> Poor MySQL is pegging CPU trying to update tickets these days. I'm not
sure
> when this began, but we just exceeded the 10,000 mark on tickets today,
which
> prompted me to spend a little time looking at the performance scaling.

Regards,
__
Steve

----- Original Message -----
From: "Darren Nickerson" <darren at dazza.org>
To: <rt-users at lists.fsck.com>
Sent: Thursday, December 20, 2001 11:37 AM
Subject: [rt-users] 2.0.9 bogs with >10K tickets


>
> Folks,
>
>
> Are there any knobs I can twiddle to improve MySQL's response time? I
haven't
> spent a lot of time digging into the schema . . . but would assume that a
great
> deal of thought had gone into this already.
>
> Thanks!
>
> -Darren
>
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>