[rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Torsten Brumm]

Roy,
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 :-(

Torsten

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


-- 
MFG

Torsten Brumm

http://www.torsten-brumm.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061205/8736ec11/attachment.htm>