Preferred db for rt?

My NOC guys are complaining about performance with rt (mysql backend). I
migrated everything to faster hardware but I’m still getting “complaints” on
searches and ticket content draws.

Is postgres any better than rt? Has anyone ported this over to Oracle or
Sybase?

Are they any tweaks I can make the the db or the rt config ?

matthew zeier - “In mathematics you don’t understand things. You just
get used to them.” - John von Newmann

|+ Is postgres any better than rt? Has anyone ported this over to Oracle or
|+ Sybase?

The Oracle port is still in development stages. The README warns that
you shouldn’t use Oracle in a production enviornment.

|+ Are they any tweaks I can make the the db or the rt config ?

There are various database tweaks you can do. You should check the
mailing list archives for this. Also, you may want to consider dumping
your database data, dropping the database, and loading the new
schema. It has some new indexes, etc which also helps.

Search the mailing list archive. It explains some tweaks you can make to
your my.cnf for better performance.

-darrin

matthew zeier mrz@intelenet.net said:

My NOC guys are complaining about performance with rt (mysql backend). I
migrated everything to faster hardware but I’m still getting “complaints” on
searches and ticket content draws.

Are you sure mySQL is the bottleneck? I don’t like the database, but I cannot
say it’s slow.

I had similar issues - turned out that the FCGI process is single
threaded, so if you have an FCGI configuration a long attachment
download will block access to RT for others. Adding ‘-processes 5’ to
the FastCgiServer configuration line solved that. Something along that
line may be your problem, maybe?

Cees de Groot http://www.cdegroot.com cg@cdegroot.com
GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B

matthew zeier mrz@intelenet.net said:

My NOC guys are complaining about performance with rt (mysql backend). I
migrated everything to faster hardware but I’m still getting "complaints"
on

searches and ticket content draws.

Are you sure mySQL is the bottleneck? I don’t like the database, but I
cannot
say it’s slow.

No, I guess I don’t know for certain it’s a db issue.

I moved from a Sun Netra T1 105 360Mhz 512MB to Redhat 7.2 4GB RAM, 4x550Mhz
Xeon. Both running mysql and Apache+mod_perl+mod_ssl.

  • mz

Is it always slow? or just slow when alot of users are using it?

Eg, If you do a search at 3am in the morning when there are no other users
on does it seem fast.

Is everything slow or just certain searches?

I found that mysql runs into problem with locking, due to the fact the
mysql’s default table type uses table level locking, which causes major
issues
when there are lots of people using RT2. postgres uses row level which
seems to work better. I haven’t moved over to postgres yet, however my
initial testing seems to indicate that searchs are in general a little
slower
on postgres when there is only one user, however you don’t end up with
everyone waiting for a table to unlock so their query can run, so it runs
better overall when there are lots of users.

mysql certainly seems faster when 99% of the queries are selects, but throw
a
few updates in there and it soon locks up.

Also… how have you configured mysql, at first I got bitten not knowing
that
you actually have to tell mysql how much ram it can use, which resulted in
mysql continuely having to write searches out to disk, drematically slowing
down the queries.

Regards,
Mat.