On Wed, Sep 05, 2001 at 11:10:49PM +0200, Henning Schroeder wrote:
> Looking in the process table reveals (when the page is fast) lots of
> sleeping processes, sometimes (when the page is slow -- 30sec to load a web
> page) lots (20+) processes that are locked. Usually they are some SELECTs
> and UPDATEswaiting for a single table that is the most update intensive
> (one update per web page served, changing one to three columns in one row
> that is indexed by a primary key). The complete DB size 380MB, the "problem
> table" is 4MB large.
Focus on this table. Specifically on the queries that access this table.
At least one query is much slower than it needs to be. Post the create
description of the table. Post some of the queries that block on this
table. If you can, find the query or queries that are slow on this table.
Optimise them.
It might be as simple as the table having a varchar column being compared
numerically (without quotes). It might be as simple as needing an index to
that table.
MySQL is fantastic under ridiculously high queries/second so long as
no query ever takes longer than 0.00 seconds (at the mysql> prompt) on
contentious tables.
Wesley.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
