Re: MySQL 5.0 on FreeBSD 7

2009-03-22 Thread Matt Juszczak
Yes. Linux threads is a port of the linux threading library (devel/linuxthreads). OK... this setup still seems to underperform 64 bit RHEL 5.x for at least our setup. Unless I'm missing something. Our sites are higher traffic - 100-300 threads/connections at any given time. Perhaps that's

MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Matt Juszczak
Hi all, About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit). I read at the time that the use of pthreads with FreeBSD would significantly improve performance, but as I was running the 64 bit version of FreeBSD, I could not use them. Fast forward to today - a different

Re: MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Mel Flynn
On Friday 20 March 2009 09:38:27 Matt Juszczak wrote: I decided to install a 64 bit version of FreeBSD 7.x (to address the 8 GB RAM in the box) and attempt to build with pthreads enabled, as well as a static build and optimized compiler options. Once again, got the error/warning in ports that

Re: MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Adam Vandemore
Matt Juszczak wrote: Hi all, About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit). I read at the time that the use of pthreads with FreeBSD would significantly improve performance, but as I was running the 64 bit version of FreeBSD, I could not use them. Fast forward to

Re: MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Adam Vandemore
Matt Juszczak wrote: Hi all, About a year ago, I setup MySQL 5.0.45 on a FreeBSD 6.x box (64 bit). I read at the time that the use of pthreads with FreeBSD would significantly improve performance, but as I was running the 64 bit version of FreeBSD, I could not use them. Fast forward to

Re: MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Matt Juszczak
You're confusing linux-threads with pthreads. The performance boosts mentioned are done using the FreeBSD Posix threads (pthreads) library, in FreeBSD 7.x they are implemented using libthr(3). The benchmarks also assume you are using SCHED_ULE, rather then SCHED_4BSD. Nothing should be configured

Re: MySQL 5.0 on FreeBSD 7

2009-03-20 Thread Mel Flynn
On Friday 20 March 2009 10:46:20 Matt Juszczak wrote: You're confusing linux-threads with pthreads. The performance boosts mentioned are done using the FreeBSD Posix threads (pthreads) library, in FreeBSD 7.x they are implemented using libthr(3). The benchmarks also assume you are using