[rt-users] displaying query builder screen taking forever

[Gary Lon Brown]

We've been on RT 3.8.0 now since Nov. 2008. In the last couple of weeks,
whenever you try and go to the query builder screen, it causes mysqld to
take 100% of the cpu for several minutes before displaying the query
builder screen.

Any idea what could cause that all of a sudden? Some suspect entries in the
http logs when this happens include:

[11/Feb/2009:10:04:15 -0600] 162.94.28.110 SSLv3 RC4-MD5
"GET /RTFM/Article/Search.html?HideOptions=1&Summary%7E=blocking+lock
HTTP/1.1" 6210
[11/Feb/2009:12:22:54 -0600] 162.94.28.110 TLSv1 DHE-RSA-AES256-SHA
"GET /RTFM/Article/Search.html?HideOptions=1&Summary%7E=blocking HTTP/1.1"
6205

Why would just trying to display this screen cause anything of significance
to run against the database? We are on MySQL version 5.0.45.

Gary
______________________________
Gary Lon Brown
Internet Support Team Lead
Hallmark Cards, Inc.
2501 McGee, 5C-L04-4, MD#100
Kansas City, MO 64108
Desk: 816-545-2853 * Cell: 816-718-8804
E-Mail: gbrown2 at hallmark.com * Yahoo IM: gbrown2hm
Text msg: 8167188804 at cingularme.com
http://www.hallmark.com

This message, including any attachments, is for the designated recipient
only and/or Hallmark Cards, Inc. employees.  It may contain privileged,
proprietary, or otherwise private information.  If you have received it in
error, please notify the sender immediately and delete the original.  Any
other use of the e-mail, disclosure of the information, or distribution by
you is prohibited.