[rt-users] Searching with RT "hangs"

[John DeBerry]

I am having an elusive problem with RT 2.0.15. It "hangs" sometimes when
displaying a search result (i.e., the user's browser sits and spins), and I
have to restart MySQL to get it going again.

We are using:
RedHat 6.2
Apache 1.3.20
MySQL 3.23.51

It seems to happen intermittently, or we cannot determine the cause of it.
(One speculation is that it sometimes happens when someone searches RT
looking for all tickets from a Requestor. In our case, we have about eight
or so Requestors that have a lot of tickets. I'm not sure if it's related or
not.)

When RT "hangs," the %CPU for mysql jumps to about 96% and stays there. And
the thing is, it will happen sometimes with the same Requestor and same
results.

If anyone has any ideas as to what I can try, it would be much appreciated.
:)

John DeBerry