100 SELECT queries to display just one ticket

RT Developers
1

Hi All

I noticed when I turned on the mysql log in the mysqld startup script it was
showing about 100 select commands just to display one ticket.

Has anyone else noticed this ? Is it normal for RT-3-0-4 ? Is that why my RT is
sooooo slow – about 20+ secs to display one ticket.

I am using Solaris 8 (sparc)/MySQL 4.0.13/Perl 5.8/Apache
1.3.x/mod_perl1/RT 3-0-4

I am also using my-medium.cnf for my 4x450Mhz/4gig system

I added index, as found in rt-users mailing list, for the GroupId and MemberId
column of CachedGroupMembers Table. It seemed to improved it from 35+ secs to
20+ secs for per ticket query

Thanks ahead for any suggestions

Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1

2

Hi All

I noticed when I turned on the mysql log in the mysqld startup script it was
showing about 100 select commands just to display one ticket.

Has anyone else noticed this ? Is it normal for RT-3-0-4 ? Is that why my RT is
sooooo slow – about 20+ secs to display one ticket.

There are definitely ways we can cut down on the number of SQL queries
used to display ticket output. Generally, well-tuned systems don’t need
that level of tweaking and when we’ve worked on customer systems, we’ve
never needed to resort to that optimization path. 20 seconds for ticket
display implies that there’s something wrong with your database config
(where a missing index might count).

I am using Solaris 8 (sparc)/MySQL 4.0.13/Perl 5.8/Apache
1.3.x/mod_perl1/RT 3-0-4

I am also using my-medium.cnf for my 4x450Mhz/4gig system

I think for mysql’s purposes, you really want a hand-tweaked
my-large.cnf.

I added index, as found in rt-users mailing list, for the GroupId and MemberId
column of CachedGroupMembers Table. It seemed to improved it from 35+ secs to
20+ secs for per ticket query

Thanks ahead for any suggestions

–
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.