Recommended MySQL 4.1 Installation

Gordon Smith gordon_s_smith at hotmail.com
Mon Jan 22 14:51:22 UTC 2007


Now that FreeBSD 6.2 is out, can anyone recommend specific configurations 
for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing 
stable) DB platform on 6.2?  In the absence of such, info about 6.1 would 
also be greatly appreciated.

Would I need to compile a specific threading library into FreeBSD to avoid 
panics or other problems that may occur under high load?

I'm happy to RTFM on this.  The last really good info I remember seeing 
about this (specifically about FBSD and MySQL) was from:
- Jeremy Zawodny's blog entry
    http://jeremy.zawodny.com/blog/archives/000697.html
- the mysql.com doc page
    http://dev.mysql.com/doc/refman/4.1/en/freebsd.html

I would be willing to sacrifice some reasonable degree of performance for 
stability (if needed), so I want to be careful here.  Running the Linux 
compatability layer is an option, if needed - I'm not sure if the Linux 
compatability layer is needed to support Linux threads (if Linux threads are 
the best choice of threading library to use with MySQL).

Has anyone done recent benchmarks to compare threading libraries?

Anyone have any contacts in MySQL AG that might be able provide suggestions?

If I've missed some obvious documentation, I apologize in advance.

Thank you.

Gordon Smith




More information about the freebsd-threads mailing list