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.From: Scott Dexter [mailto:scott.dexter@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)
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@lists.fsck.com [mailto:rt-users-admin@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@ingenta.com
AIM scottder517