Results 1 to 3 of 3
Thread: freebsd and mysql issues
-
11-23-2004, 06:34 PM #1WHT Addict
- Join Date
- Oct 2001
- Posts
- 161
freebsd and mysql issues
anyone here having issues with high cpu loads with freebsd and mysql? any solutions?
-
11-23-2004, 06:52 PM #2Retired Moderator
- Join Date
- Sep 2004
- Location
- Flint, Michigan
- Posts
- 5,766
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.
-
11-23-2004, 07:11 PM #3Junior Guru Wannabe
- Join Date
- Oct 2004
- Posts
- 44
Re: freebsd and mysql issues
Originally posted by deras
anyone here having issues with high cpu loads with freebsd and mysql? any solutions?
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