Date: Mon, 03 Oct 2005 13:44:14 +1000 From: Michael VInce <mv@roq.com> To: Olaf Greve <o.greve@axis.nl> Cc: amd64@FreeBSD.org Subject: Re: Which MySQL version best to use and with/without linux threads? Message-ID: <4340A90E.9070806@roq.com> In-Reply-To: <433D3C12.6020104@axis.nl> References: <ED4C536E-48C1-11D9-B2C4-000A2791B6EC@illusionart.com> <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> <433D3C12.6020104@axis.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
I did benchmarks with Linux threads and without on 5.x and found Linux threads didn't help at all. It probably does on 4.x though. And i did consistently benchmark 4.0.x faster then 4.1 but it wasn't a large amount of difference. If your db server isn't maxed out in anyway and there are features in 4.1 you want then I would see little harm in upgrading. Mike Olaf Greve wrote: > Hi, > > I've got a MySQL 4.0.16 DB running with several DB instances in it. So > far, so good, but I'm looking for a bit of advice. > > I've got a few small questions: > > Firstly: is it (for a webserver) better to compile MySQL with > linux-threads or without? I seem to recall having read that Linux uses > a better threading mechanism, and that MySQL really benefits from > this... What do you all think? > > Then, I'm currently configuring a second beast, eehhhh, server. :) > Being an AMD-64 19" server, running FreeBSD 5.4-Release AMD64. On it, > I instinctively installed the latest MySQL 4.0.x version (being > 4.0.26) and it works flawlessly with the data from my current > production machine. > > Still so far, so good. :) > > However... I was wondering what the advantages (and potential > disadvantages!) may be of using a newer line of the MySQL DB. > > Can anyone tell me what the advantages/pitfalls may be of using v4.1.x > or even v5, over using 4.0.x ? > > A year or two ago I installed a 4.1.x version and there were some > issues then with using the passwords, coming from a 3.23.x or 4.0.x > one. I don't remember the details, but it had something to do with > that... > > Any advice is more than welcome, as this is the moment for me to make > this sort of decicion, and I'd like to do so based on real user's > experiences...:) > > Thank you kindly in advance, and with kind regards, > Olaf Greve > _______________________________________________ > freebsd-amd64@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-amd64 > To unsubscribe, send any mail to "freebsd-amd64-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4340A90E.9070806>