On Wed, Oct 30, 2002 at 11:17:44AM +0100, Benjamin Pflugmann wrote: > Hi. > > 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.
Hm, good point. I glossed over those numbers pretty quickly. :-( > 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. Yeah. It's clearly more general than I first thought. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 85 days, processed 1,789,609,623 queries (242/sec. avg) --------------------------------------------------------------------- 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
