Re: mysql50-server on FreeBSD 6.2 w/ LINUX_THREADS?

Is it still advisable to build the mysql50-server on FreeBSD 6.2 using
the LINUX_THREADS option? I'm using the SMP kernel on an older dual
1.0GHz Pentium III. This page <http://wiki.freebsd.org//MySQL>
suggests that the libthr library in FreeBSD 6.x is optimized for MySQL
and perhaps better than using linuxthreads.

Any thoughts?

Hi Patrick,

We're running several MySQL databases on FreeBSD 6.1 and 6.2 RELEASE
and we don't use LINUX_THREADS. So far so good as they say.

Concerning MySQL performance on FreeBSD, I recently saw this article
which could be of interest to you:

Linux vs FreeBSD using mysql and sysbench
http://jeffr-tech.livejournal.com/5705.html

Aside from a potential holy flame war from FreeBSD vs Linux, this
article does present you with an interesting my.cnf configuration
file. Maybe that could interest you?

Have fun,

David
--
David Robillard
UNIX systems administrator & Oracle DBA
CISSP, RHCE & Sun Certified Security Administrator
Montreal: +1 514 966 0122
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: FreeBSD MySQL still WAY slower than Linux
    ... >> The bad news is that I've not managed to get very far at all lately as ... is that the Mysql folks have agreed to setup ... >> tests to profile mysql on identical hardware running FreeBSD and Linux ...
    (freebsd-stable)
  • Re: Reduced java/tomcat performance 6-beta3 -> 6-stable ?
    ... example MySQL are well known in FreeBSD to be slower then Linux because its more expensive to call compared to Linux, maybe Tomcat is also another such app this can also be double the case depending on on your jsp and servlet code. ... I been doing some 'ab' testing libthr with Apache2 compiled for worker MPM and have some really interesting differences on server load, loads of about 40 for pthread and around 5 thr under certain tests with ab with the exact same test. ...
    (freebsd-stable)
  • Re: Reduced java/tomcat performance 6-beta3 -> 6-stable ?
    ... Some apps that use of frequent queries of the system time for example MySQL are well known in FreeBSD to be slower then Linux because its more expensive to call compared to Linux, maybe Tomcat is also another such app this can also be double the case depending on on your jsp and servlet code. ...
    (freebsd-stable)
  • RE: Re[2]: FreeBSD MySQL still WAY slower than Linux
    ... FreeBSD MySQL still WAY slower than Linux ... len nie a nie ho skoncit. ...
    (freebsd-performance)
  • MySQL query tool and Administrator
    ... favorite MySQL tools- mysql-query-tool. ... MS Windows and now that I am migrating over to my BSD workstation I'd ... I did with Netbeans 4.0...could I run this in Linux compatability mode? ... plain Linux binaries it says it cannot find libpopt (yet my FreeBSD ...
    (freebsd-questions)