On Tue, Sep 11, 2001 at 11:13:48AM +0800, Andrew I. Baznikin wrote:
I'm not so sure that this is MySQL's fault as it is the FreeBSD
thread library.
IIRC, under the FreeBSD thread implementation, the process will
spin away doing essentially sched_yield() if it's simply waiting for blocked
I/O to complete (ie, perhaps a lagged client connection).
-MB
> >Description:
> Sometimes MySQL capture 80-90% of processor time.
>
> # top
> PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
> 45215 mysql 53 0 31960K 5480K RUN 941:42 94.68% 94.68% mysqld
>
> #truss -p `cat /var/db/mysql/poster.pid `
> gettimeofday(0x282f1028,0x0) = 0 (0x0)
> poll(0x81ec000,0x8,0x252e) = 1 (0x1)
> gettimeofday(0x282f1028,0x0) = 0 (0x0)
> poll(0x81ec000,0x8,0x252d) = 1 (0x1)
> .... and so on.
>
> >How-To-Repeat:
> I don't know... This situation repeats every 3-5 days.
> >Fix:
> #mysql.sh stop
> #mysql.sh start
> ;-(
>
> >Submitter-Id: <submitter ID>
> >Originator: Andrew I. Baznikin
> >Organization:
> SibChallenge Telecom (ISP)
> >MySQL support: none
> >Synopsis: Sometimes MySQL capture 80-90% of processor time.
> >Severity: serious
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.23.41 (Source distribution)
>
> >Environment:
>
> System: FreeBSD poster.scn.ru 4.4-RC FreeBSD 4.4-RC #3: Tue Aug 28 16:35:24 KRAST
>2001 [EMAIL PROTECTED]:/usr/src/sys/compile/POSTER i386
> P-II 266/128Mb RAM, FreeBSD 4.4-RC
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
>/usr/bin/cc
> GCC: Using builtin specs.
> gcc version 2.95.3 20010315 (release) [FreeBSD]
> Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='c++' CXXFLAGS='-O -pipe
>-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
> LIBC:
> -r--r--r-- 1 root wheel 1205280 Aug 28 14:24 /usr/lib/libc.a
> lrwxr-xr-x 1 root wheel 9 Aug 28 14:24 /usr/lib/libc.so -> libc.so.4
> -r--r--r-- 1 root wheel 572524 Aug 28 14:24 /usr/lib/libc.so.4
> Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
>--without-debug --without-readline --without-bench --with-mit-threads=no
>--with-libwrap --with-low-memory --enable-assembler --with-berkeley-db
>--with-charset=koi8_ru --prefix=/usr/local i386--freebsd4.4
> Perl: This is perl, version 5.005_03 built for i386-freebsd
>
> ---------------------------------------------------------------------
> 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
>
---
Michael Bacarella <[EMAIL PROTECTED]>
Technical Staff / System Development,
New York Connect.Net, Ltd.
---------------------------------------------------------------------
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
