Has anyone tried dropping back several versions to see if this still happens? I
tried running 3.23.38, and still had problems, but will be dropping back to
possibly even 3.22 to see what happens. I know that linux kernel 2.4 handles
memory sometimes in a strange way, but this problem that I am seeing doesn't seem
to be a memory problem, it appears to be something with processes spawning like
mad and using up all available cpu cycles. I have looked very closely at my logs
and cannot find any consistency in the tables hit or queries run before the load
level starts to climb.
In response to the people who've said to optimise queries...in a perfect world,
yes, but when you're a web development company systems administrator, it's 80
hours a week trying to stay on top of your systems, much less having time to beat
your programmers for inefficient code. All I can do there is tell you those same
queries have worked on the same tables of approximately the same size for nearly 2
years. At least in our case. :)
Thanks for all the response.
jenn
Ryan Shrout wrote:
> 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
---------------------------------------------------------------------
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