[rt-users] Resource usage spikes

[Carlos A. Carnero Delgado]

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.