Hi Benjamin. Thank you for your fast reply. I have another two small detailed questions. 1st: Do you think, if I compile the mysql source on my own it should be better ? I readed, that RedHat 7 has pre-compiled the mysql with an errorous version of gcc. ... so I would compile it on my own. 2nd: You said that I have to look these slow queries are. Can you explain it a little bit ? I remember that joins can be very slow, and if there is an mistake in my query it can produce such a load ?
Regards - Daniel Backhausen Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin Pflugmann Gesendet: Montag, 10. Dezember 2001 11:28 An: Daniel Backhausen Cc: [EMAIL PROTECTED] Betreff: Re: HELP... lot of Load 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
