FreeBSD and MySQL - mysqld eats CPU alive

[Peter Schuller]

> 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.

I've seen this on two machines (both 5.2). When I built mysql with 
linuxthreads the problem went away.

Alternatively I've seen talk of name resolution causing problems due to a 
non-thread-safe implementation of gethostbyname() - this too manifested 
itself as abnormal CPU usage. In my case --skip-name-resolve didn't help, but 
perhaps it might for you guys.

-- 
/ Peter Schuller, InfiDyne Technologies HB

PGP userID: 0xE9758B7D or 'Peter Schuller <peter.schuller at infidyne.com>'
Key retrieval: Send an E-Mail to getpgpkey at scode.org
E-Mail: peter.schuller at infidyne.com Web: http://www.scode.org