Date: Fri, 30 Sep 2005 15:22:26 +0200 From: Olaf Greve <o.greve@axis.nl> To: amd64@FreeBSD.org, freebsd-questions@freebsd.org Subject: Which MySQL version best to use and with/without linux threads? Message-ID: <433D3C12.6020104@axis.nl> In-Reply-To: <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de> References: <ED4C536E-48C1-11D9-B2C4-000A2791B6EC@illusionart.com> <1102494183.41b6b9e726b2f@www.domainfactory-webmail.de>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?433D3C12.6020104>