Re: MySql uses 98% CPU
Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 4:07 PM Subject: Re: MySql uses 98% CPU On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - 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: MySql uses 98% CPU
I like FreeBSD so it pains me to say it but the penguin has it. As threads are so important to MySQL Linux it just better at this at the moment (we will see what happens with V5 FreeBSD). MySQL was developed on Suns Slowlaris so it is a bit more native to Linux... Simon PS the devil will be back :-) -Original Message- From: Toni [mailto:toni;clad4.com] Sent: 06 November 2002 09:18 To: [EMAIL PROTECTED] Subject: Re: MySql uses 98% CPU Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 4:07 PM Subject: Re: MySql uses 98% CPU On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - 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
Re: MySql uses 98% CPU
Pada Mon, 4 Nov 2002 11:55:59 +0100 Toni [EMAIL PROTECTED] menulis: Hello I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without problems, until now that consumes nearly all available CPU. Also, I am unable to stop the server using mysqladmin -u root shutdown (the process freezes) neither can restart it. If I kill -9 the process it restarts and keeps using all my resources. Aparently there isn't any other active process on the machine. I have checked at mysql.com but I couldn't find any related information. ¿Where could this problem come from? ¿Any solution? Check the running queries show processlist ... or mysqladmin -p processlist ... or even better use mytop / mtop for some condition (high cpu usage), optimize your tables, or mysqlcheck -or -A -p You should avoid kill -9 (safe_mysqld/mysql) ... it's only for desperate move ... :D -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.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: MySql uses 98% CPU
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote: Pada Mon, 4 Nov 2002 11:55:59 +0100 Toni [EMAIL PROTECTED] menulis: Hello I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without problems, until now that consumes nearly all available CPU. Also, I am unable to stop the server using mysqladmin -u root shutdown (the process freezes) neither can restart it. If I kill -9 the process it restarts and keeps using all my resources. Aparently there isn't any other active process on the machine. I have checked at mysql.com but I couldn't find any related information. ¿Where could this problem come from? ¿Any solution? Check the running queries show processlist ... or mysqladmin -p processlist ... or even better use mytop / mtop for some condition (high cpu usage), optimize your tables, or mysqlcheck -or -A -p You should avoid kill -9 (safe_mysqld/mysql) ... it's only for desperate move ... :D We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. Switching to Linux fixed it ;) The difference with what Dicky describes is that for us the MySQL servers still works; it just looks like there's a rogue thread running around doing nothing. - 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: MySql uses 98% CPU
On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - 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: MySql uses 98% CPU
At 07:07 AM 11/4/02 -0800, Jeremy Zawodny wrote: On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy, just wanted to thank you for the pointer to those details... we've actually had this similar problem where mysql will quite often keep itself up at near 100% cpu usage (running two mysql daemons on a dual cpu box)... it does drop into the 70's sometimes, but even at way off-peak times will never drop to the 5-10% usage we see when we restart mysql, until of course it builds back up again. We haven't bothered too much because frankly it just hasn't slowed down the box enough to make it worth investigating, just a minor annoyance when we are looking at top. Now we are off to take a look at your pointers and see if we can finally flush it out... Thanks again. You da man! - 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