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/ --------------------------------------------------------------------- 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