Re: [Phplib-users] exessive cpu-load

[Frank B. <fb...@sy...>]

At 08:49 AM 6/17/03, so...@gm... wrote:

>My ISP keeps shutting down my site  due to exessive cpu-load.
>On request he sent me this:
>
># User@Host: netsh32[netsh32] @ localhost []
># Query_time: 23 Lock_time: 20 Rows_sent: 1 Rows_examined: 0
>use usr_netsh32_1;
>select val from active_sessions where sid = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxx'
>and name = 'lablue_session';
>query time 23 seconds (!!!)
>(my tests today gave me an average of 0,0012 s)
>
>The site itself is offline rigth now, but you can get an impression here
>http://stable.lablue.de
>Typical use: 20.000 PI/day, 6 GB transfer/month
>
>my version:
>## $Id: ct_sql.inc,v 1.4 2001/05/17 00:54:20 chrisj Exp $
>
>My table:
>Indizes:
>Name, Typ, Feld
>PRIMARY, PRIMARY, name sid
>changed, INDEX, changed
>
>Rows: 600
>field, typ
>sid, varchar(32)
>name, varchar(32)
>val, text
>changed, varchar(14)


How much traffic does your site get?  I wonder if your session table got 
rather large and garbage collection routines happened to get invoked make 
an otherwise quick query run a very long time.  Does anyone know if gc() 
kicks in on any query, or just updates?