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

[Aleš Sušnik]

Scott,

try mysql 4.x, why?
My setup:
p3 450mhz, 320mb ram, 512mb swap, 5000 tickets, 3 very active users,
everything else (apache, mod_perl, perl) is same as you.
Runs about 10% slower then 2.0, which is not noticable!
Ow, and RT isn't the only thing running on the machine, we got also
sendmail, 7 other PHP apps, etc..

A.

-----Original Message-----
From: Scott Dexter [mailto:scott.dexter at ingenta.com] 
Sent: Monday, September 15, 2003 7:09 PM
To: rt-users
Cc: Aleš Sušnik
Subject: RE: [rt-users] Issue with DB with lots (1500+) tickets (3.04)


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