Resource usage spikes

Hi,

RT newb here. My team is currently testing RT to see if (and how well)
it would serve us. So far so good, with one exception: every now and
then, the web interface is completely unresponsive for a couple of
minutes. When I get into the system’s console, I see Apache taking
100% of processors during the spike. When the usage falls, everything
goes back to normal: behavior is a lot faster and it keeps going on
like that for several hours until the next spike.

Note that I don’t think the database is being hit during these periods
as I’m watching the MySQL server (SHOW PROCESSLIST) and I can see the
connection pool there, but completely idle. Besides, right now we have
one queue with two tickets, so not much data.

The actual setup is Ubuntu Server 10.04.1 and RT from packages, which
is 3.8.7. The web server is Apache and MySQL the RDBMS (on another
server.) The hardware is a VMware ESXi virtual machine with 1 GB of
RAM and two ~ 2 GHz processors assigned to it. I initially thought of
swapping or caching issues but a quick check on the VMware host shows
no resource overcommitment (and other VMs performing as usual.)

What the best way to track what’s going on?

Best regards,
Carlos.

Hi,

RT newb here. My team is currently testing RT to see if (and how well)
it would serve us. So far so good, with one exception: every now and
then, the web interface is completely unresponsive for a couple of
minutes. When I get into the system’s console, I see Apache taking
100% of processors during the spike. When the usage falls, everything
goes back to normal: behavior is a lot faster and it keeps going on
like that for several hours until the next spike.

Hi Carlos,

I had this exact same problem with RT from packages on a CentOS machine.
When I installed it from tar.gz I didn’t have the problem. It almost seemed
like there was missing database indexes or something but when I checked the
SQL usage it was complete idle. I couldn’t ever pin down what was using all
the resources. The installation I’m running now has been upgraded once and
has been running for over a year. We are up to ticket #19469 now.

Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net