> I have several MySQL and FreeBSD installs across a few different sites, and > I consistently have problems with mysqld. It will begin to eat up all of the > CPU and eventually become unresponsive (or the machine will just burn). I > can't seem to manually reproduce this, but given enough time a FreeBSD box > with mysqld will go down.
For what it's worth, we had the exact OPPOSITE happen: We were using OpenBSD for a long time, and when we switched to FreeBSD, MySQL CPU usage dropped from like 75% to 5%. It's been running amazingly fast ever since, for a database-driven website that gets 10,000 unique visitors a day. (100,000 page views a day, all MySQL-generated.) Just using a stock install from FreeBSD ports -- although we did choose the OPTIMIZED settings in ports install that it shows you when you first go to install MySQL server. Choose linux threads, too. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
