Hi, It sounds like you are using the default thread library. I would install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see options in Makefile) or barring that try Jeremey's excellent build recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We used to have the same problem and everything runs great now.
Ken ----- Original Message ----- From: "adp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 30, 2004 2:58 PM Subject: FreeBSD and MySQL - mysqld eats CPU alive > 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. > > Our servers are generally heavily loaded. > > I would say that I'm doing something wrong (although what I could be doing > wrong I'm not sure), but I recently began working with another company that > has the EXACT SAME PROBLEM. They are even thinking of moving to PostgreSQL, > but we are trying to fix mysqld instead for now. > > This behavior has been seen on: > > FreeBSD 4.4, 4.7, 4.9, 4.10 > MySQL 3.x and 4.x > Typical load: 50 qps > With and without replication enabled. > Some sites are SELECT heavy, some are INSERT heavy. > > For one site I think we will be moving from FreeBSD to Linux for the MySQL > servers since MySQL seems to run like a champ on Linux. We will continue to > use FreeBSD for everything else. > > Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint > the exact issue. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]