List:General Discussion« Previous MessageNext Message »
From:Michael T. Babcock Date:December 5 2002 4:47pm
Subject:Re: Slow performance using 3.23 on RH 8.0
View as plain text  
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/
Thread
Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
  • Re: Slow performance using 3.23 on RH 8.0Nikolas Samios4 Dec
  • RE: Slow performance using 3.23 on RH 8.0Adam Nelson4 Dec
  • RE: Slow performance using 3.23 on RH 8.0Adam Nelson4 Dec
  • Re: Slow performance using 3.23 on RH 8.0Mirek Novak5 Dec
RE: Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
  • Re: Slow performance using 3.23 on RH 8.0Michael T. Babcock5 Dec
RE: Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
RE: Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
  • RE: Slow performance using 3.23 on RH 8.0Adam Nelson4 Dec
    • Re: Slow performance using 3.23 on RH 8.0Jeremy Zawodny5 Dec
RE: Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
  • RE: Slow performance using 3.23 on RH 8.0Adam Nelson4 Dec
RE: Slow performance using 3.23 on RH 8.0Mike Ledet4 Dec
RE: Slow performance using 3.23 on RH 8.0Jan Steinman5 Dec