Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 22 Jan 2007 09:51:18 -0500
From:      "Gordon Smith" <gordon_s_smith@hotmail.com>
To:        threads@freebsd.org
Subject:   Recommended MySQL 4.1 Installation 
Message-ID:  <BAY133-F257593EAE5CECCF04ED056C8AE0@phx.gbl>

next in thread | raw e-mail | index | archive | help
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





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BAY133-F257593EAE5CECCF04ED056C8AE0>