Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Posts
    161

    freebsd and mysql issues

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

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

  3. #3
    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?
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •