[rt-users] Issue with DB with lots (1500+) tickets (3.04)

[Scott Dexter]

On Mon, 2003-09-15 at 13:02, Aleš Sušnik wrote:
> Scott,
> 
> send your HW (CPU & RAM) info also it might help alot!

 Right now it's a 500 mhz processor with 256mb ram.

> How many users do you have?

Only like 4 active (admin)users of the web interface. 

> How much swap?
> 
512mb

> Perl version?
5.8.0 (that came with RH 8)

> mod_perl or fastcgi?
mod_perl

> Apache version?

1.3.28

> I think mysql 4.x is very highly recommended!
> 
> A.
> 
> -----Original Message-----
> From: rt-users-admin at lists.fsck.com [mailto:rt-users-admin at lists.fsck.com]
> On Behalf Of Scott Dexter
> Sent: Monday, September 15, 2003 5:17 PM
> To: rt-users
> Subject: [rt-users] Issue with DB with lots (1500+) tickets (3.04)
> 
> 
> I started the system from scratch, and tickets went into an empty rt3 db
> fine, but when I put in the old DB of 1500+ tickets it's then that I
> have huge perfromacne issues, mostly on inserts. I switched to using
> my-large.vnf with MySQL3, is moving to Mysql4 really my only option, is
> there some way to optimize the tickets part of the DB?
> 
> Scott
-- 
Scott Dexter
Jr Unix Administrator
Ingenta, Inc.
111R Chestnut Street, Providence, RI 02903
T  +1.401.331.2014
F  +1.401.331.2015
E   scott.dexter at ingenta.com
AIM scottder517