List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:November 28 2003 1:32am
Subject:Re: Repeated 100% CPU problem in FreeBSD
View as plain text  
On Thu, Nov 27, 2003 at 06:25:38PM -0600, Dan Nelson wrote:
> In the last episode (Nov 27), Chris Elsworth said:
> > Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9
> > system. However, today, unexplicably, it's run into the same problem
> > 3 times now; a couple of the threads suddenly start eating 100% CPU
> > for no good reason while doing a SELECT. They'll sit there until I
> > kill them, which results in a lot of hair tearing as it comes back up
> > checking all the tables.
> > 
> > I haven't been able to produce a core despite sending it a SIGABRT,
> > but I'll try recompiling with -g (do the supplied binaries have this?)
> > soon.
> You can use the gcore command to create a coredump of a running program
> without killing it, and the pstack command (in ports) is handy for
> printing the stacks of all threads in a running process without even
> coring it.  Once you get a stack trace, send it to
> freebsd-threads@stripped and/or here.

Please do post a strack trace here.  I'd very curious to see what it
looks like.

Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |

MySQL 4.0.15-Yahoo-SMP: up 75 days, processed 2,959,075,536 queries (456/sec. avg)
Repeated 100% CPU problem in FreeBSDChris Elsworth27 Nov
  • Re: Repeated 100% CPU problem in FreeBSDDan Nelson28 Nov
    • Re: Repeated 100% CPU problem in FreeBSDJeremy Zawodny28 Nov
  • Re: Repeated 100% CPU problem in FreeBSDAndrey Kotrekhov28 Nov