>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