Roy,<br>Yes, we clean it 4 times the day!!! A this moment, everytime rt goes slower, i pick up the process by hand and kill them, not the best way, but the only working at this moment :-(<br><br>Torsten<br><br><div><span class="gmail_quote">
2006/12/5, Roy El-Hames <<a href="mailto:rfh@pipex.net">rfh@pipex.net</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Torsten;
<br>One other thing ..how big is your sessions table, do you clean it<br>regularly (delete old sessions)<br>Roy<br><br>Torsten Brumm wrote:<br>> At this moment, we have round about 500.000 Tickets in 700 Queues,<br>>
26.000Users<br>><br>> Torsten<br>><br>> 2006/12/5, Eric J. Feldhusen <<a href="mailto:efeldhusen.lists@gmail.com">efeldhusen.lists@gmail.com</a>>:<br>>><br>>> Just curious, how many tickets are in your RT installation?
<br>>><br>>> Torsten Brumm wrote:<br>>> > But with MySQL 4.12 and apache 2 with FastCGI<br>>> ><br>>> > 2006/12/5, Steve Ison <<a href="mailto:si202@cam.ac.uk">si202@cam.ac.uk</a>
<mailto:<a href="mailto:si202@cam.ac.uk">si202@cam.ac.uk</a>>>:<br>>> ><br>>> > Hello,<br>>> ><br>>> > My RT installation (3.6.1, MySQL 5, Apache 1.3, mod_perl 1.9,<br>
>> > DBIx::SearchBuilder v1.45) has slowed considerably as the<br>>> number of<br>>> > tickets has grown. In the MySQL slow query log I see:<br>>> ><br>>> > # Time: 061205 11:52:19
<br>>> > # User@Host: rt_user[rt_user] @ localhost []<br>>> > # Query_time: 181 Lock_time: 0 Rows_sent: 1 Rows_examined: 0<br>>> > SELECT GET_LOCK('Apache-Session-b59f829ebcd37237783322425399eeb2',
<br>>> > 3600);<br>>> ><br>>> > While this is happening apache just spins using all the cpu.<br>>> ><br>>> > While trawling back the the mailing-list archives I noticed others
<br>>> have<br>>> > had this problem, but I can't find any mention of a solution. Am I<br>>> > missing<br>>> > it or is this an ongoing problem?<br>>><br>>> --<br>>> Eric Feldhusen
<br>>> Network Administrator <a href="http://www.remc1.org">http://www.remc1.org</a><br>>> <a href="mailto:eric@remc1.org">eric@remc1.org</a><br>>> PO Box 270 (906) 482-4520 x239<br>>> 809 Hecla St (906) 482-5031 fax
<br>>> Hancock, MI 49930 (906) 370 6202 mobile<br>>> _______________________________________________<br>>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
</a><br>>><br>>> Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>>> Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
>><br>>><br>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>>><br>
><br>><br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>><br>> Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>> Commercial support: <a href="mailto:sales@bestpractical.com">
sales@bestpractical.com</a><br>><br>><br>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>MFG<br><br>Torsten Brumm<br><br><a href="http://www.torsten-brumm.de">http://www.torsten-brumm.de</a>