FreeBSD and MySQL - mysqld eats CPU alive

[Peter Kieser]

Hello,

I've experienced this exact problem, all the way from 4.4-STABLE as well.
The time period where the issue starts happening is very erradic, but I'm
having the exact issue on one of my servers at this very moment. I thought
it was just an issue with my box, and not anyone elses.

mysql    237 93.9  3.4 59336 17460 con- R    21Jul04 2797:08.26
/usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --use
r=mysql --pid-file=

The box isn't exactly heavily loaded, with may 10 QPS; so I don't think it
has to do anything with load.

Currently I'm running mysql-server-4.0.17 on FreeBSD 4.10-STABLE.

FreeBSD x.x 4.10-STABLE FreeBSD 4.10-STABLE #2: Wed Jul 21 18:31:49 PDT 2004
peter at x.x:/usr/src/sys/compile/PSYCHO  i386

--Peter

----- Original Message ----- 
From: "adp" <dap99 at i-55.com>
To: <questions at freebsd.org>
Cc: <freebsd-database at freebsd.org>; <freebsd-hackers at freebsd.org>
Sent: Saturday, July 31, 2004 8:08 PM
Subject: FreeBSD and MySQL - mysqld eats CPU alive

>
> Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint
> the exact issue.
>