On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote: > > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > Well, "load average" can be misleading. > > > > Can you maybe share the output of "vmstat 1" or "vmstat 5" for a > > minute's worth of time? It's be good to see what the CPUs states look > > like. It is a lot of system time? User time? Both? > > Load average of 1.5 seems high when we are only averaging 14 queries > per sec (nothing else going crazy running on the box) > > procs memory swap io system cpu > r b w swpd free buff cache si so bi bo in cs us sy id > 0 1 0 972 810004 569536 286708 0 0 9 1 4 9 0 5 11 > 1 1 0 972 809604 569536 286708 0 0 0 4 147 188 20 7 73 > 1 1 0 972 809008 569536 286708 0 0 0 11 158 165 20 7 73 > 0 1 0 972 809488 569536 286708 0 0 0 7 158 207 17 11 72 > 1 1 0 972 807248 569536 286708 0 0 0 8 149 132 14 5 80 > 0 1 0 972 809072 569536 286708 0 0 0 6 164 264 40 8 51 > 0 1 0 972 808984 569536 286712 0 0 0 11 172 267 23 7 71
You're disk-bound, not CPU bound. Notice all the idle CPU time? And the fact that the "b" column always has one process listed, while "r" only does once in a while. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ --------------------------------------------------------------------- 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