[rt-users] RT2 and MySQL

[Adam Morton]

What does 'show processlist' in mySQL look like when this is happening?

When you say 'just stay put there', do you mean forever, and you have to
restart mySQL or the server, or what?  Or does it stop by itself at some
point?

----- Original Message -----
From: "Joshua Mandelberger" <josh at pwebtech.com>
To: <rt-users at fsck.com>
Sent: Thursday, May 09, 2002 3:36 PM
Subject: [rt-users] RT2 and MySQL


> Hi, I've been on the list for quite some time now but up until now have
> been lurking and reading.  Lots of great information, a good deal of which
> as been valuable to myself and the admins who over see our RT2
installation.
> I must also say its an awesome program, its improved the efficiency of our
> tech support more than I can possibly describe.
>
> That having been said, we have been seeing some problems with our RT2
> database over the last week or two that is cause for some concern.
>
> Every so often, and it is intermittent but this problem occurs at least
> once ever couple days, the MySQL thread for the RT2 database will spike up
> to 85-99% of the servers CPU power and just stay put there.  This causes
> all the sessions in Tracker to move very slowly naturally.
>
> Is there anywhere to look for a way to pin down what is causing the
> problem, or some kind of tuning we can do on the database that might
> alleviate the problems we're having?
>
> Here is the present configuration.
>
> Dual P-III 800
> 768MB of Ram
> RedHat Linux version 6.1
> Running the 2.4.17 kernel
> mysql version 3.23.39
> RT version 2.0.13
>
> There are also around 11000-12000 tickets in our database if that makes a
> difference.
>
> If there is anything else I can provide that would help with information
> please let me know.  Also if this has come up before (I hadn't seen
> anything like it) and there is already messages covering this, let me know
> where in the archives to look.  I went through them and tried to find some
> answers but didn't see anything similar to what is happening.  But I could
> have missed them.
>
> Thanks,
>
> Joshua Mandelberger
> Pegasus Web Technologies
>
>
>
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at 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
>