RE: [Phplib-users] exessive cpu-load

[Robert H. <rm...@le...>]

If I read this correctly, the admin did a read from the database and came up
with a 23 second response, 20 seconds of which was a lock.  The database
itself is one table with 4 fields with 600 rows.  However, there are 2
indecies for this table one of which crosses two fields.  I notice that the
select is not even on an indexed field.

What is WRITING this database?  What is causing the 20 second lock time?  It
could be GC or it could be whatever is updating the indicies.  What if you
get rid of the indecies?  What are the other possibilities?  Other db
operations?  Can you create a "simple" table and see if the same thing
happens?  None of the fields looks like it's large enough to cause a
problem...

-----Original Message-----
From: php...@li...
[mailto:php...@li...]On Behalf Of
so...@gm...
Sent: Tuesday, June 17, 2003 8:49 AM
To: php...@li...
Subject: [Phplib-users] exessive cpu-load


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)



-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
Phplib-users mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phplib-users