Re: Recommended MySQL 4.1 Installation

["Gordon Smith" <gordon_s_smith_(_at_)_hotmail_(_dot_)_com>]

Abdullah,

Thanks for the feedback.  The reason (at the moment) is that some of the 
application code to be implemented in FBSD uses outer join queries, which 
are executed differently under 4.1 and 5.0.

It looks like MySQL changed their outer join implementation for 5.0 to make 
it comply with an ANSI standard, so until the app code is changed and 
thoroughly tested the DB needs to stay at 4.1... unless someone is aware of 
a MySQL switch that will let us toggle between the old and new outer join 
behavior (sorry, that question is probably outside the scope of this 
list...).

Gordon

----Original Message Follows----
From: "Abdullah Al-Marrie" <almarrie_(_at_)_gmail_(_dot_)_com>
To: "Gordon Smith" <gordon_s_smith_(_at_)_hotmail_(_dot_)_com>
CC: threads_(_at_)_freebsd_(_dot_)_org
Subject: Re: Recommended MySQL 4.1 Installation
Date: Mon, 22 Jan 2007 11:15:05 +0300

On 1/19/07, Gordon Smith <gordon_s_smith_(_at_)_hotmail_(_dot_)_com> wrote:
> 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?

I'm just wondering why don't you go for MySQL 5.0.27 with libthr
instead of using linuxthreads?

MySQL 5.0.x with libthr runs faster than 4.1.x.

http://wikitest.freebsd.org/MySQL

--
Regards,

-Abdullah Ibn Hamad Al-Marri
Arab Portal
http://www.WeArab.Net/


_______________________________________________
freebsd-threads_(_at_)_freebsd_(_dot_)_org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-threads
To unsubscribe, send any mail to "freebsd-threads-unsubscribe_(_at_)_freebsd_(_dot_)_org"