Re: Re: mysql uses 99% cpu under freebsd 4.3
So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - 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: Re: mysql uses 99% cpu under freebsd 4.3
SMP is System Multi Processor Like a server with 2 or more CPUs ... David - Original Message - From: webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 1:07 PM Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3 So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - 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 99% cpu under freebsd 4.3
Symmetric Multi Processing ;-) url: http://webopedia.lycos.com/TERM/S/SMP.html David BORDAS wrote: SMP is System Multi Processor Like a server with 2 or more CPUs ... David - Original Message - From: webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 1:07 PM Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3 So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - 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 -- Colin Faber (303) 736-5160 fpsn.net, 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
Re: mysql uses 99% cpu under freebsd 4.3
On Thu, May 09, 2002 at 11:18:35AM -0400, Ken Menzel wrote: Gunnar, This sounds very interesting! I will have to try this and see if I cannot aggravate the problem with large cache values. Thank you for sharing this information. Jeremy I hope you will share something if you can reproduce this issue. If we see it again here, I'll do some testing with this info. So far I've experienced it on one SMP box and one single CPU box. I don't believe either of them had very fancy my.cnf files, but I'll have to check. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 92 days, processed 2,398,590,779 queries (301/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 99% cpu under freebsd 4.3
On Wed, May 01, 2002 at 09:15:25PM +0200, Gunnar Helliesen wrote: List, Re: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:71261:200104:iidpojcdbmgdbajh aobn#b I have this exact problem on a single-CPU P-III 500 running FreeBSD 4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have tried both the mysql.com-supplied binary package and rolling my own from sources. What happens is that after anywhere from 1-2 days of uptime the mysqld process suddenly starts eating all available CPU: last pid: 25537; load averages: 1.20, 1.61, 1.43 up 32+17:01:50 20:35:06 51 processes: 2 running, 49 sleeping CPU states: 21.0% user, 0.0% nice, 77.4% system, 1.6% interrupt, 0.0% idle Mem: 208M Active, 154M Inact, 96M Wired, 27M Cache, 60M Buf, 13M Free Swap: 1024M Total, 64K Used, 1024M Free PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 93402 mysql 54 0 299M 43988K RUN368:57 98.00% 98.00% mysqld 93461 www 2 0 14400K 9356K sbwait 0:31 0.10% 0.10% httpd MySQL still answers queries so everything works, at least for as long as I allow the server to run in this state. I've seen it too. No on my primary servers, but on some that I occasionally work on. 'iostat' shows nothing much happening: # iostat tty da0 acd0 sa0 cpu tin tout KB/t tps MB/s KB/t tps MB/s KB/t tps MB/s us ni sy in id 0 14 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 5 0 14 1 80 # Same. and 'mysqladmin processlist' shows about 45-50 processes all in Sleep command. The only process in Query command is my own 'processlist'. Same. After a quick restart of the mysqld server load drops to almost 0 and mysqld settles down to its usual modest CPU utilization: Same. To make things interesting I have another FreeBSD server, this one an SMP 2-CPU P-III 1 GHz running FreeBSD 4.4-RELEASE and MySQL 4.0.0-alpha compiled from sources. This one is under heavier load but does not display this problem! Any ideas? I'm no MySQL expert so I could use a little hand-holding in running diagnostics. Odd. The only boxes I've seen it on so far were dual-CPU FreeBSD 4.5 machines. I've heard that it also hit one single-cpu FreeBSD 4.5 machine too, but I never got all the details on that one. The trick is to figure out how to reliably reproduce the problem. Once that happens, fixing it will be rather easy I think. So if anyone comes up with a way of doing it, please speak up. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 83 days, processed 2,169,755,750 queries (300/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 99% cpu under freebsd 4.3
List, Re: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:71261:200104:iidpojcdbmgdbajh aobn#b I have this exact problem on a single-CPU P-III 500 running FreeBSD 4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have tried both the mysql.com-supplied binary package and rolling my own from sources. What happens is that after anywhere from 1-2 days of uptime the mysqld process suddenly starts eating all available CPU: last pid: 25537; load averages: 1.20, 1.61, 1.43 up 32+17:01:50 20:35:06 51 processes: 2 running, 49 sleeping CPU states: 21.0% user, 0.0% nice, 77.4% system, 1.6% interrupt, 0.0% idle Mem: 208M Active, 154M Inact, 96M Wired, 27M Cache, 60M Buf, 13M Free Swap: 1024M Total, 64K Used, 1024M Free PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 93402 mysql 54 0 299M 43988K RUN368:57 98.00% 98.00% mysqld 93461 www 2 0 14400K 9356K sbwait 0:31 0.10% 0.10% httpd MySQL still answers queries so everything works, at least for as long as I allow the server to run in this state. 'iostat' shows nothing much happening: # iostat tty da0 acd0 sa0 cpu tin tout KB/t tps MB/s KB/t tps MB/s KB/t tps MB/s us ni sy in id 0 14 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 5 0 14 1 80 # and 'mysqladmin processlist' shows about 45-50 processes all in Sleep command. The only process in Query command is my own 'processlist'. After a quick restart of the mysqld server load drops to almost 0 and mysqld settles down to its usual modest CPU utilization: last pid: 25649; load averages: 0.09, 0.74, 1.07 up 32+17:09:51 20:43:07 51 processes: 1 running, 50 sleeping CPU states: 0.8% user, 0.0% nice, 1.2% system, 1.9% interrupt, 96.1% idle Mem: 188M Active, 159M Inact, 97M Wired, 27M Cache, 60M Buf, 29M Free Swap: 1024M Total, 64K Used, 1024M Free PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 25620 mysql 2 0 293M 23480K poll 0:01 0.05% 0.05% mysqld 37095 bind2 0 5300K 4780K select 18:37 0.00% 0.00% named To make things interesting I have another FreeBSD server, this one an SMP 2-CPU P-III 1 GHz running FreeBSD 4.4-RELEASE and MySQL 4.0.0-alpha compiled from sources. This one is under heavier load but does not display this problem! Any ideas? I'm no MySQL expert so I could use a little hand-holding in running diagnostics. Please Cc: me on replies. Thanks! Gunnar -- Gunnar Helliesen | Bergen IT Consult AS | Open Source activist Systems Consultant | Bergen, Norway| Jaguar enthusiast [EMAIL PROTECTED] | www.bitcon.no/~gunnar | Märklin collector - 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 99% cpu under freebsd 4.3
Jeremy Zawodny writes: On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote: This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. The bug that I had we reproducible with only two client threads. It just required a fair amount of data to reproduce the problem in a short amount of time. Also, if you end up at a dead end and need the help of a FreeBSD internals guru, let me know. We happen to have a few of them on staff. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 Thanks for your offer !! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 99% cpu under freebsd 4.3
Hi, I have had some various similar things happen with other apps since upgrading to Fbsd4.2stable What I have learnt to do first before anything else is, reboot and load a SINGLE CPU compiled kernel to determine at what/where the bug may be. I had a/still occasionally get a constant waiting in KDE explorers but never get this during a single CPU test. Have had lots of mysql threads gobbling resources, too lazy to test, plus it was an early mysql (have not updated it from ports) since it has only done this twice since February (when we updated from 3.4 to 4.2). Probably doesn't help you all but I am watching this news thread eagerly. M. -- He came from Econet - Oh no, I've run out of underpants :( Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk - 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 99% cpu under freebsd 4.3
Jeremy Zawodny writes: On Tue, Apr 10, 2001 at 02:25:44PM +0300, Sinisa Milivojevic wrote: Can anyone of you guys come with a repeatable test case that will always lead to the situation as described. Then we could try to fix it. I produced one about 9 months ago and gave it to Tim Smith. Had to send him a CD-ROM, since it was rather large. But I can still reliably kill a MySQL server running on FreeBSD 3.x and 4.x. If there is renewed interest in fixing it, I can try to put one together again. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 HI! Some of our developers managed to repeat something that is close to what is described, so for the moment, no test case is required. It will be required if we do not get as serious problem as described in this list. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 99% cpu under freebsd 4.3
Hi Sinisa! Good to hear from you. Not having this problem yet, I am however interested in the details of what you did find and what may be the potential cure. I am asking as I would like a little more detail than what would normally go in a log entry. IE how did the problem get reproduced. Is it thought to be a bug in FreeBSD threads or a difference in the thread lib or something else? And what the attempted fix might be. (Maybe even a patch to try). I would be happy to help test, resolve, duplicate any problems related to FreeBSD. (This is important to us and anyone who runs production FreeBSD servers!). Ken HI! Some of our developers managed to repeat something that is close to what is described, so for the moment, no test case is required. It will be required if we do not get as serious problem as described in this list. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 99% cpu under freebsd 4.3
Ken Menzel writes: Hi Sinisa! Good to hear from you. Not having this problem yet, I am however interested in the details of what you did find and what may be the potential cure. I am asking as I would like a little more detail than what would normally go in a log entry. IE how did the problem get reproduced. Is it thought to be a bug in FreeBSD threads or a difference in the thread lib or something else? And what the attempted fix might be. (Maybe even a patch to try). I would be happy to help test, resolve, duplicate any problems related to FreeBSD. (This is important to us and anyone who runs production FreeBSD servers!). Ken Hi Ken, This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. I am not involved with this as I am poor BSD expert. Two of our developers are working on the problem and will report their findings to the general list as soon as they have something important to say. As I am not involved with this, I truly am not able to shed more light. One of our developers managed to pinpoint that most of CPU went to some runaway thread. Causes of this are not known. I would also like to say that this kind of problems are hardest to crack and will require lots of effort. SIGSEGV's, on the other hand, are very easy to fix in comparison. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 99% cpu under freebsd 4.3
On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: Hi! Hi Ken, This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. My mysql server is not under heavy load. We have less then 20 connection at ones. But we have the same problem under FreeBSD-4.2 STABLE The mysqld can catch all CPU ones a day, sometimes ones a week. IMHO it is not depend from number of threads or number of queries at ones. ___ Andrey Kotrekhov [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
Re: mysql uses 99% cpu under freebsd 4.3
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries per second avg: 0.700) the last time it acted up. By the way, it is a dual CPU machine. On another machine with only one CPU running exactly the same code and relese of FreeBSD I havent seen this problem. /Lars Andersson _ Lars Andersson, Tekniker Cable Wireless - pi.se http://www.pi.se On Wed, 11 Apr 2001, Andrey Kotrekhov wrote: On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: Hi! Hi Ken, This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. My mysql server is not under heavy load. We have less then 20 connection at ones. But we have the same problem under FreeBSD-4.2 STABLE The mysqld can catch all CPU ones a day, sometimes ones a week. IMHO it is not depend from number of threads or number of queries at ones. ___ Andrey Kotrekhov [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
Re: mysql uses 99% cpu under freebsd 4.3
On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote: This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. The bug that I had we reproducible with only two client threads. It just required a fair amount of data to reproduce the problem in a short amount of time. Also, if you end up at a dead end and need the help of a FreeBSD internals guru, let me know. We happen to have a few of them on staff. (Filter bait: db, query, mysql) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 99% cpu under freebsd 4.3
FYI, people experiencing this problem should try to make the mysqld as idle as possible (ie disconnect or idle the connections) and then run truss -p NNN (where NNN is the pid of the mysqld process) and post a typical chunk of the output. That would give valuable info to the mysql developers. Tim. On Tue, Apr 10, 2001 at 03:48:26PM +0300, Heikki Tuuri wrote: Hi! People are reporting performance problems also from the FreeBSD port of Innobase. There seems to be a runaway thread which gets free sometimes and eats up 100 % of the CPU. It was not fixed with the latest patches to Innobase. I will try setting thread priorities in 3.23.37. That might help, but I guess the real reason is different. I will probably finish my work on 37 today and tomorrow I will try to repeat the problems on our FreeBSD computer. Regards, Heikki Johan Andersson writes: I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD 4.1-RELEASE with both the distribution from the ports tree and the source dist. from mysql.com. I tried to solve the problem with analysing all the database traffic, but mysql were taking all free CPU that were availble on the same database traffic (same database) that were running fine on a debian linux machine (Pentium 166, 192M RAM) ... So something weird is happening on some FreeBSD machines. But I also have two machines that are _dedicated_ mysql servers of the same configuration, but other hardware brand (motherboard, scsi controllers, disks) that runs perfect on the same FreeBSD release! The machine with the problem were also running Apache/PHP .. (How )is MySQL using sharedmemory segments ? I know that Oracle takes up loads of them and may bring problem for apache that also needs some seg's.. ? Regards, Johan Andersson Consultant QbranchHi! Can anyone of you guys come with a repeatable test case that will always lead to the situation as described. Then we could try to fixit.Regards, Sinisa - 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 99% cpu under freebsd 4.3
I suspect the point is that many more threads simply makes the problem appear more often and thus be reproducible and thus more easily fixed. Tim. On Wed, Apr 11, 2001 at 04:49:19PM +0200, Lars Andersson wrote: My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries per second avg: 0.700) the last time it acted up. By the way, it is a dual CPU machine. On another machine with only one CPU running exactly the same code and relese of FreeBSD I havent seen this problem. /Lars Andersson _ Lars Andersson, Tekniker Cable Wireless - pi.se http://www.pi.se On Wed, 11 Apr 2001, Andrey Kotrekhov wrote: On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: Hi! Hi Ken, This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. My mysql server is not under heavy load. We have less then 20 connection at ones. But we have the same problem under FreeBSD-4.2 STABLE The mysqld can catch all CPU ones a day, sometimes ones a week. IMHO it is not depend from number of threads or number of queries at ones. ___ Andrey Kotrekhov [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 - 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 99% cpu under freebsd 4.3
On Wed, Apr 11, 2001 at 12:33:44PM -0400, Ken Menzel wrote: The list reject my trace (it was too large), so here is a smaller one! Stops after info from first top starts showing CPU usage of 99% Ken Hi Tim, I just had it happen. Overall average 14 queries per second on this machine. Single CPU Kernel Dell 2400 600MHZ FreeBSD-stable from January. Almost generic kernel. I have attahced some output from truss, followed by 'top' followed by the stop and start of mysql, followed by the output from 'top' again. Hope this helps someone! Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] pread(0x186,0x18563010,0x2a9,0x0,0x4bb094,0x0) = 681 (0x2a9) lseek(173,0x1b20,0) = 6944 (0x1b20) read(0xad,0xbf515028,0x14) = 20 (0x14) pread(0xad,0x187e5018,0x33,0x0,0x1b2d,0x0) = 51 (0x33) lseek(173,0x1b74,0) = 7028 (0x1b74) read(0xad,0xbf515028,0x14) = 20 (0x14) pread(0xad,0x187e504b,0x17,0x0,0x1b78,0x0) = 23 (0x17) SIGNAL 27 SIGNAL 27 pread(0x186,0x18563010,0x2a9,0x0,0x2cac03,0x0) = 681 (0x2a9) gettimeofday(0x2828a568,0x0) = 0 (0x0) sigprocmask(0x3,0x2828a5d8,0x0) = 0 (0x0) sigaltstack(0x282a5c20,0x0) = 0 (0x0) poll(0x8212000,0x54,0x0) = 0 (0x0) sigreturn(0x182a1864)= 20 (0x14) pread(0xe5,0x1843a09f,0x9,0x0,0x4f777,0x0) = 9 (0x9) lseek(229,0x4f758,0) = 325464 (0x4f758) read(0xe5,0xbf39ef98,0x14) = 20 (0x14) pread(0xe5,0x1843a0a8,0x9,0x0,0x4f763,0x0) = 9 (0x9) lseek(229,0x5ae64,0) = 372324 (0x5ae64) read(0xe5,0xbf39ef98,0x14) = 20 (0x14) pread(0xe5,0x1843a0b1,0xd,0x0,0x5ae68,0x0) = 13 (0xd) lseek(229,0x4963c,0) = 300604 (0x4963c) That's different to what I was seeing. I saw a tight loop of poll(...) = 1 gettimeofday(...) = ... poll(...) = 1 gettimeofday(...) = ... poll(...) = 1 gettimeofday(...) = ... poll(...) = 1 gettimeofday(...) = ... Tim. - 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 99% cpu under freebsd 4.3
In the last episode (Apr 11), Ken Menzel said: The list reject my trace (it was too large), so here is a smaller one! Stops after info from first top starts showing CPU usage of 99% Ken Hi Tim, I just had it happen. Overall average 14 queries per second on this machine. Single CPU Kernel Dell 2400 600MHZ FreeBSD-stable from January. Almost generic kernel. I have attahced some output from truss, followed by 'top' followed by the stop and start of mysql, followed by the output from 'top' again. Hope this helps someone! lseek(229,0x3c378,0) = 246648 (0x3c378) read(0xe5,0xbf39ef98,0x14) = 20 (0x14) pread(0xe5,0x1843a018,0x9f,0x0,0x3c385,0x0) = 159 (0x9f) lseek(229,0x41d84,0) = 269700 (0x41d84) read(0xe5,0xbf39ef98,0x14) = 20 (0x14) pread(0xe5,0x1843a0b7,0x10,0x0,0x41d88,0x0) = 16 (0x10) This looks like a perfectly normal mysql truss. Lots of disk I/O, and it looks like you're got a pretty small record length (20-byte reads? although the combo of lseek+read and pread on the same datafile is puzzling. Maybe it's a table with a couple of INT/CHAR columns and a BLOB column?). Does a "show processlist" say there's a query running? An interesting thing to see might be the output of a couple seconds of "iostat 1" and "vmstat 1", to see how much disk and syscall activity there is. -- Dan Nelson [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
Re: mysql uses 99% cpu under freebsd 4.3
I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD 4.1-RELEASE with both the distribution from the ports tree and the source dist. from mysql.com. I tried to solve the problem with analysing all the database traffic, but mysql were taking all free CPU that were availble on the same database traffic (same database) that were running fine on a debian linux machine (Pentium 166, 192M RAM) ... So something weird is happening on some FreeBSD machines. But I also have two machines that are _dedicated_ mysql servers of the same configuration, but other hardware brand (motherboard, scsi controllers, disks) that runs perfect on the same FreeBSD release! The machine with the problem were also running Apache/PHP .. (How )is MySQL using sharedmemory segments ? I know that Oracle takes up loads of them and may bring problem for apache that also needs some seg's.. ? Regards, Johan Andersson Consultant Qbranch - Original Message - From: "Lars Andersson" [EMAIL PROTECTED] To: "Andrew Schmidt" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 09, 2001 11:26 PM Subject: Re: mysql uses 99% cpu under freebsd 4.3 I have experienced the same problems on a dual processor machine running 4.2-STABLE and mysql 3.23.36 from the ports tree. regards, Lars Andersson At 16:03 2001-04-09 -0400, Andrew Schmidt wrote: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-m
Re: mysql uses 99% cpu under freebsd 4.3
Johan Andersson writes: I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD 4.1-RELEASE with both the distribution from the ports tree and the source dist. from mysql.com. I tried to solve the problem with analysing all the database traffic, but mysql were taking all free CPU that were availble on the same database traffic (same database) that were running fine on a debian linux machine (Pentium 166, 192M RAM) ... So something weird is happening on some FreeBSD machines. But I also have two machines that are _dedicated_ mysql servers of the same configuration, but other hardware brand (motherboard, scsi controllers, disks) that runs perfect on the same FreeBSD release! The machine with the problem were also running Apache/PHP .. (How )is MySQL using sharedmemory segments ? I know that Oracle takes up loads of them and may bring problem for apache that also needs some seg's.. ? Regards, Johan Andersson Consultant Qbranch Hi! Can anyone of you guys come with a repeatable test case that will always lead to the situation as described. Then we could try to fix it. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 99% cpu under freebsd 4.3
Hi! People are reporting performance problems also from the FreeBSD port of Innobase. There seems to be a runaway thread which gets free sometimes and eats up 100 % of the CPU. It was not fixed with the latest patches to Innobase. I will try setting thread priorities in 3.23.37. That might help, but I guess the real reason is different. I will probably finish my work on 37 today and tomorrow I will try to repeat the problems on our FreeBSD computer. Regards, Heikki Johan Andersson writes: I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD 4.1-RELEASE with both the distribution from the ports tree and the source dist. from mysql.com. I tried to solve the problem with analysing all the database traffic, but mysql were taking all free CPU that were availble on the same database traffic (same database) that were running fine on a debian linux machine (Pentium 166, 192M RAM) ... So something weird is happening on some FreeBSD machines. But I also have two machines that are _dedicated_ mysql servers of the same configuration, but other hardware brand (motherboard, scsi controllers, disks) that runs perfect on the same FreeBSD release! The machine with the problem were also running Apache/PHP .. (How )is MySQL using sharedmemory segments ? I know that Oracle takes up loads of them and may bring problem for apache that also needs some seg's.. ? Regards, Johan Andersson Consultant QbranchHi! Can anyone of you guys come with a repeatable test case that will always lead to the situation as described. Then we could try to fixit.Regards, Sinisa - 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 99% cpu under freebsd 4.3
On Tue, Apr 10, 2001 at 02:25:44PM +0300, Sinisa Milivojevic wrote: Can anyone of you guys come with a repeatable test case that will always lead to the situation as described. Then we could try to fix it. I produced one about 9 months ago and gave it to Tim Smith. Had to send him a CD-ROM, since it was rather large. But I can still reliably kill a MySQL server running on FreeBSD 3.x and 4.x. If there is renewed interest in fixing it, I can try to put one together again. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 99% cpu under freebsd 4.3
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote: I have the same problem under FreeBSD-4.2 STABLE sometimes it work fin 1week, but sometimes 1 day. Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id:submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis:mysql uses 99% cpu and becomes unresponsive Severity:serious Priority:high Category:mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 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 ___ Andrey Kotrekhov [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
Re: mysql uses 99% cpu under freebsd 4.3
Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 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
Re: mysql uses 99% cpu under freebsd 4.3
I have experienced the same problems on a dual processor machine running 4.2-STABLE and mysql 3.23.36 from the ports tree. regards, Lars Andersson At 16:03 2001-04-09 -0400, Andrew Schmidt wrote: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 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
Re: mysql uses 99% cpu under freebsd 4.3
Similar problems on FreeBSD 4.2-RELEASE. Dedicated Mysql server is pinning the CPU, under a load of 500+ queries per second. Memory is not exausted, and Disk usage is 0. Just the CPU is pinned. [EMAIL PROTECTED] wrote: Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator:Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 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
Re: mysql uses 99% cpu under freebsd 4.3
I've seen what's probably the same thing under 4.2-STABLE. The poll() system call returns 1 but there's no corresponding file handle marked in the data structures that were passed to poll(). (It could be a mysqld bug if they're asking to poll() for certain kinds of events but then not checking for those events, but that seems unlikely. I've no time to check the code.) Tim. On Mon, Apr 09, 2001 at 04:03:05PM -0400, Andrew Schmidt wrote: Have you tried this under a 'stable' version of freebsd? In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault. now, I understand RC's are generally stable; but I would still make sure that this bug doesn't show up in a stable os. regards, -- Andrew - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 3:34 PM Subject: mysql uses 99% cpu under freebsd 4.3 Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id: submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis: mysql uses 99% cpu and becomes unresponsive Severity: serious Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-except ions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --witho ut-readline --without-bench --with-mit-threads=no --with-libwrap --with-low- memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix= /usr/local i386--freebsd4.3 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