This problem is almost exactly like the "load level on linux" one seen
earlier, and like about 5 others I've seen on this list including my own.
Why is we can not get a straight answer from anyone on this???
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Andrew I. Baznikin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 10, 2001 11:13 PM
Subject: MySQL processor overload
> >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 --p
refix=/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
>
---------------------------------------------------------------------
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
