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!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg)