Re: Slow performance using 3.23 on RH 8.0

[Michael T. Babcock]

On Wed, Dec 04, 2002 at 05:06:54PM -0500, Ledet, Mike wrote:
> I tried your TOP suggestion but didn't see anything out of the ordinary.
> Swap size was constant (6400 or so) and didn't increase or decrease under
> load.

Familiarize yourself with vmstat if you aren't already and then run
`vmstat 1` and run your queries.  See how the blocked/running processes
look, how much CPU time is in use by the system/user processes and how
many blocks per second the disk is reading/writing.

SQL
-- 
Michael T. Babcock
CTO, FibreSpeed Ltd.     (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/