anyone here having issues with high cpu loads with freebsd and mysql? any solutions?

Might need to be a bit more specific than that. FreeBSD and MySQL do not have any issues in and of themselves. I've run MySQL on FreeBSD machines quite a bit and i've yet to have any load problems just because of that. Now if a user has a poorly written PHP application leaving loops in MySQL requests, that would mess up loads regardless of the OS.

Originally posted by deras
anyone here having issues with high cpu loads with freebsd and mysql? any solutions?

try rebuilding it with linuxthreads, yahoo is using mysql and freebsd servers, http://jeremy.zawodny.com/blog/archives/000697.html

so the quick way to install it:

cd /usr/ports/databases/mysqld40-server
make install clean WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes

and add this to your /etc/make.conf file
CPUTYPE=i686
CFLAGS= -O2 -pipe

cputype might be different for your box