Hi.
On Tue 2002-10-29 at 16:01:00 -0800, [EMAIL PROTECTED] wrote:
> On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote:
[...]
> > 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.
Allow me to disagree. Although most often the symptoms you cite are a
sign that the operation is disk-bound, they are more a sign of
blocking per se, of which the most common cause is disk operation. In
the above case the bi, bo, free, si, so numbers IMHO do not back up
waiting for disks as possible cause.
Heath, I once had similar symptoms when my DNS resolving had problems
and all new connections "slept" for some seconds while they were
waiting for an response. My work-around was to use --skip-name-resolve
until the DNS problem was solved.
I do not mean to imply that the problem you observe is the same. Just
that they seem to follow the same pattern: For some reason the threads
seems to be blocking and waiting for some "external" response.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
