Hi.
On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote:
> Hello.
>
> When I start the mysql database my load is nearly zero. After some time
> e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s
> are going wild till 90% user 10% system. Normaly this system could handle
> a lot of database operations.
>
> Here are some system information:
> - Dual Intel Pentium III 733
> - 512 MB Ram
> - RedHat Linux (Kernel 2.2.16)
> - mySQL version 3.23.41.
>
> I have created an output of my 'mysqlbug' status, so it might gonna help
> solving the problem.
> ----------------------------------------------------------------------------
> ---
> Server version[10C3.23.41-log
> Protocol version[8C10
> Connection[14CLocalhost via UNIX socket
> UNIX socket[13C/var/lib/mysql/mysql.sock
> Uptime:[17C7 hours 33 min 15 sec
>
> Threads: 64 Questions: 186759 Slow queries: 2799 Opens: 362 Flush
> tables: 1
You should have a look what these slow queries are. With bad luck, one
bad query can queue up all others after it.
> Open tables: 39;1H139 Queries per second avg: 6.867
[...]
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> gcc version 2.96 20000731 (Red Hat Linux 7.0)
> Compilation info: CC='gcc'
> CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BI
> [49;1HTS=64 -D_LARGEFILE_SOURCE' CXX='c++'
> CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_F
> [50;1HILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS=''
[...]
If that is the RH delivered binary (and to me it looks so), you may
want consider to use a pre-compiled binary from MySQL's website. There
are known issues with RH compiler and MySQL (and pre-compiled)
binaries - although I am not sure whether thy apply to your
environment. Btw, I doubt that this would be the source of your load
problems - I mentioned it just for completeness.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
