List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:November 4 2002 3:07pm
Subject:Re: MySql uses 98% CPU
View as plain text  
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)
Thread
MySql uses 98% CPUToni4 Nov
  • Re: MySql uses 98% CPUDicky Wahyu Purnomo4 Nov
    • Re: MySql uses 98% CPUTech)4 Nov
      • Re: MySql uses 98% CPUJeremy Zawodny4 Nov
        • Re: MySql uses 98% CPUPR5 Nov
  • Re: MySql uses 98% CPUToni6 Nov
RE: MySql uses 98% CPUSimon Green6 Nov