<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>when we open some tickets on RT 3.6.0 (plan to upgrade to 3.6.1 when i
can) the httpd process uses 100% CPU and never stops.</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>here's what top looks like with two requests to open the same
ticket:</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2> PID USER PR NI
VIRT RES SHR S %CPU %MEM TIME+
COMMAND<BR>17556 httpdnin 25 0 423m 406m 2760 R 99.9
26.8 8:20.84 httpd<BR>20343 httpdnin 25 0
391m 372m 2624 R 99.6 24.6 2:51.43 httpd<BR>20429
root 16 0 1968 1108 828
R 0.3 0.1 0:00.04 top</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>here's the mysql process list:</FONT></SPAN></DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=363051107-06092006><FONT face="Courier New" color=#800000
size=2>| 3 | rt_nintek | localhost | rt_nintek | Query
| 290 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 5 | rt_nintek | localhost | rt_nintek | Query
| 280 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 6 | rt_nintek | localhost | rt_nintek | Query
| 290 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 7 | rt_nintek | localhost | rt_nintek | Query
| 203 | User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600)
|<BR>| 8 | rt_nintek | localhost | rt_nintek | Sleep
| 193 | |
NULL
|<BR>| 9 | rt_nintek | localhost | rt_nintek | Query
| 379 | User lock | SELECT
GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) |<BR>|
10 | rt_nintek | localhost | rt_nintek | Query | 413 | User
lock | SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 11 | rt_nintek | localhost | rt_nintek | Sleep |
193 | |
NULL
|<BR>| 13 | rt_nintek | localhost | rt_nintek | Query |
203 | User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) |<BR>| 399 |
rt_nintek | localhost | rt_nintek | Query | 236 | User lock |
SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600) |<BR>|
400 | rt_nintek | localhost | rt_nintek | Query | 234 | User
lock | SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613', 3600)
|<BR>| 401 | rt_nintek | localhost | rt_nintek | Query | 230 |
User lock | SELECT GET_LOCK('Apache-Session-8dc6987e94c140bf84fb5fe379594613',
3600) |<BR>| 402 | rt_nintek | localhost | rt_nintek | Query |
203 | User lock | SELECT
GET_LOCK('Apache-Session-db0718c787b8a257d22087a9a99fb51a', 3600) |<BR>| 403 |
rt_nintek | localhost | rt_nintek | Sleep | 2
| |
NULL
|<BR>| 411 | rt_nintek | localhost | rt_nintek | Sleep | 127
| |
NULL
|<BR>| 413 | rt_nintek | localhost | rt_nintek | Sleep | 127
| |
NULL
|<BR>| 415 | rt_nintek | localhost | rt_nintek | Sleep |
47 | |
NULL
|<BR>| 416 | rt_nintek | localhost | rt_nintek | Sleep
| 0
| |
NULL
|<BR>| 417 | rt_nintek | localhost | rt_nintek | Sleep
| 1
| |
NULL
|<BR>| 418 | rt_nintek | localhost | rt_nintek | Sleep
| 1
| |
NULL
|<BR></FONT></DIV>
<DIV><SPAN class=363051107-06092006></SPAN><FONT face="Courier New"
color=#800000 size=2>h<SPAN class=363051107-06092006>elp!</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#800000 size=2><SPAN
class=363051107-06092006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" color=#800000 size=2><SPAN
class=363051107-06092006>it's at the point now where i have a script that runs
every minute killing httpd processes that have been running for a long time with
high cpu usage.</SPAN></DIV>
<DIV><BR></DIV></FONT></SPAN>
<DIV><FONT face="Courier New" color=#800000 size=2></FONT> </DIV>
<DIV class=Section1 align=left>
<P class=MsoNormal><SPAN class=GramE><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: 'Courier New'">[
byron</SPAN></SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: 'Courier New'"> <SPAN
class=SpellE>jones</SPAN><BR>[ zoom <SPAN
class=SpellE>itg</SPAN>
"In 3010, the potatoes triumphed"<BR>[ phone +61 8 9389
5235
- N. <SPAN class=SpellE>Gertler</SPAN><BR
style="mso-special-character: line-break"><BR
style="mso-special-character: line-break"><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P></DIV>
<DIV><FONT face="Courier New" color=#800000
size=2></FONT> </DIV></BODY></HTML>