Re: Stability problems on 4-way server
Sinisa Milivojevic wrote: Jörgen Winqvist writes: I run RH supported kernel 2.4.7-10enterprise on such a server with similar problems. All four CPU's runs off with a lot off system. I can provoke this behaviour by generating disk i/o. A 'cp' might be it. I often get it when the full backup is running. I've also tested 2.4.9-13 with even worse result. I previously used the 2.4.8 vanilla kernel whith good results. I was planning to test 2.4.17 next week but now i don't know... I use MySql 4.01 If you use our binary, 2.4.17 should be just fine ... I've used the 2.4.17 kernel for a week now and it works very well. No problems with kswapd and high loadavg any more. - 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
Re: Stability problems on 4-way server
Trond Eivind Glomsrød wrote: Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 2.4.17 has problems with heavy database usage. Does this happen on the supported kernels as well? (I'm guessing yes, this doesn't seem to have anything to do with the kernel... you might want to check if anything suspicious show up in dmesg, though) I run RH supported kernel 2.4.7-10enterprise on such a server with similar problems. All four CPU's runs off with a lot off system. I can provoke this behaviour by generating disk i/o. A 'cp' might be it. I often get it when the full backup is running. I've also tested 2.4.9-13 with even worse result. I previously used the 2.4.8 vanilla kernel whith good results. I was planning to test 2.4.17 next week but now i don't know... I use MySql 4.01 - 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
Re: Stability problems on 4-way server
Jörgen Winqvist writes: I run RH supported kernel 2.4.7-10enterprise on such a server with similar problems. All four CPU's runs off with a lot off system. I can provoke this behaviour by generating disk i/o. A 'cp' might be it. I often get it when the full backup is running. I've also tested 2.4.9-13 with even worse result. I previously used the 2.4.8 vanilla kernel whith good results. I was planning to test 2.4.17 next week but now i don't know... I use MySql 4.01 If you use our binary, 2.4.17 should be just fine ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: Stability problems on 4-way server
Hi, What about a 2.4.17 with 'aa' patch, as it seems to have much less VM problem than vanilla kernel or rmap-10c patched kernel... (I have personnaly installed 2.4.17rc2 + patch rc2aa2 with no problem : http://www.kernel.org/pub/linux/kernel/people/andrea/kernels/v2.4/2.4.17rc2a a2.bz2 ) Best Regards, Jocelyn Fournier Presence-PC www.presence-pc.com - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 3:05 PM Subject: Re: Stability problems on 4-way server Jörgen Winqvist writes: I run RH supported kernel 2.4.7-10enterprise on such a server with similar problems. All four CPU's runs off with a lot off system. I can provoke this behaviour by generating disk i/o. A 'cp' might be it. I often get it when the full backup is running. I've also tested 2.4.9-13 with even worse result. I previously used the 2.4.8 vanilla kernel whith good results. I was planning to test 2.4.17 next week but now i don't know... I use MySql 4.01 If you use our binary, 2.4.17 should be just fine ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: Stability problems on 4-way server
Dennis Jacobfeuerborn writes: Hi, We are running MySQL version 3.23.43 on one of our servers and have some stability problems the occur about every 1-2 days. When it happens everythings keeps working but the load goes up to about 80. After stopping and restarting MySQL everything goes back to normal (load average about 0.5). There are usually only a few connection open at the same time (about 20) and we have no slow or heavy duty queries. Is there anyone who had a similar problem? We're not sure what could possibly cause this. Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 The database-files are placed on a dedicated raid-5 disk. Note: Displaying the processlist does not reveal any unusual or special queries when the problem occurs. They just run slower because of the high load. Regards, Dennis Please install and use latest 3.23 binary RPM from our site. If you are not using our binary, then it is probably a cause of instability. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: Stability problems on 4-way server
Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet connection Software: Base RedHat 7.2 installation Unpatched kernel 2.4.17 2.4.17 has problems with heavy database usage. Does this happen on the supported kernels as well? (I'm guessing yes, this doesn't seem to have anything to do with the kernel... you might want to check if anything suspicious show up in dmesg, though) -- Trond Eivind Glomsrød Red Hat, Inc. - 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