MySQL 5.0 on FreeBSD 7

[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 SCHED_ULE, rather then
> > SCHED_4BSD. Nothing should be configured if you run GENERIC later then
> > 7.0-RELEASE.
>
> Mel,
>
> So, from a standard FreeBSD 7.x install:
>
> - Recompile kernel to use SCHED_ULE

7.1 and 7-STABLE later then feb 2008 all have SCHED_ULE as default.
Only 7.0-RELEASE has SCHED_4BSD as default.

> - In the port, use:  BUILD_OPTIMIZED=yes
> - In the port, use:  WITH_PROC_SCOPE_PTH=yes
> - In the port, use:  BUILD_STATIC=yes

Yes. If you don't mind loosing the ability to kill off sleeping connections, 
you can add WITHOUT_THR_ALARM.

> And that should be it?  So the "libpthread" they discuss in the
> description for WITH_PROC_SCOPE_PTH is different than the linux pthreads?

Yes. Linux threads is a port of the linux threading library 
(devel/linuxthreads).
-- 
Mel