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: [email protected] * Yahoo IM: gbrown2hm Text msg: [email protected] 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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
