Re: Which MySQL version best to use and with/without linux threads?

2005-10-06 Thread Peter Giessel
On Thursday, October 06, 2005, at 07:22AM, Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: *** MySQL Log 4.1.14 *** 051002 17:41:47 1 Connect Access denied for user 'abbc'@'localhost' (using password: YES) This is the same authentication problem seen from the other side. 051002

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Andrew P.
On 10/5/05, Emanuel Strobl [EMAIL PROTECTED] wrote: Am Mittwoch, 5. Oktober 2005 02:17 CEST schrieb Peter Wemm: On Friday 30 September 2005 06:22 am, Olaf Greve wrote: Then, I'm currently configuring a second beast, ee, server. :) Being an AMD-64 19 server, running FreeBSD 5.4-Release

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Jerry McAllister
Am Mittwoch, 5. Oktober 2005 02:17 CEST schrieb Peter Wemm: On Friday 30 September 2005 06:22 am, Olaf Greve wrote: Then, I'm currently configuring a second beast, ee, server. :) Being an AMD-64 19 server, running FreeBSD 5.4-Release AMD64. On it, I instinctively installed the

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Peter Giessel
On Wednesday, October 05, 2005, at 07:31AM, Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: On Monday, 3 October 2005 at 10:37:21 -0800, Peter A. Giessel wrote: On 10/3/2005 09:41, Jared Kuolt seems to have typed: There really isn't any reason not to anymore since everything is backwards

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Greg 'groggy' Lehey
On Wednesday, 5 October 2005 at 7:51:33 -0800, Peter Giessel wrote: On Wednesday, October 05, 2005, at 07:31AM, Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: On Monday, 3 October 2005 at 10:37:21 -0800, Peter A. Giessel wrote: On 10/3/2005 09:41, Jared Kuolt seems to have typed: There

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Peter Wemm
On Friday 30 September 2005 06:22 am, Olaf Greve wrote: Then, I'm currently configuring a second beast, ee, 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

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Emanuel Strobl
Am Mittwoch, 5. Oktober 2005 02:17 CEST schrieb Peter Wemm: On Friday 30 September 2005 06:22 am, Olaf Greve wrote: Then, I'm currently configuring a second beast, ee, server. :) Being an AMD-64 19 server, running FreeBSD 5.4-Release AMD64. On it, I instinctively installed the latest

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Greg 'groggy' Lehey
On Monday, 3 October 2005 at 10:37:21 -0800, Peter A. Giessel wrote: On 10/3/2005 09:41, Jared Kuolt seems to have typed: There really isn't any reason not to anymore since everything is backwards compatible. I've found that Dovecot 1.0a3 has a problem with 4.1.x, Can you give more details?

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Olaf Greve
Hi all, Thanks a lot for your answers! I see that MySQL v5 is not mature enough for my likings to risk the gamble already, and presently I have no need for triggers and stored procedures (though they can be very handy, of course). Regarding version 4.0.x versus 4.1.x: the same applies as

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Dinesh Nair
On 10/01/05 00:08 Andrew P. said the following: linuxthreads were only important on FreeBSD 4.x. Starting with 5.x we have a more efficient threading model. Extensive testing did not reveal any significant is this definitive, i.e. that on 5.x linuxthreads are worse off than native freebsd

Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Jared Kuolt
Olafo, I've found that 4.1 works perfectly! It has been running on my web servers, the longest one being just over 200 days, which was just after MySQL 4.1 was pulled out of gamma and into release. 0 troubles at all. I definitely recommend upgrading. There really isn't any reason not to anymore

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Andrew P.
On 10/3/05, Dinesh Nair [EMAIL PROTECTED] wrote: On 10/01/05 00:08 Andrew P. said the following: linuxthreads were only important on FreeBSD 4.x. Starting with 5.x we have a more efficient threading model. Extensive testing did not reveal any significant is this definitive, i.e. that on

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Peter A. Giessel
On 10/3/2005 09:41, Jared Kuolt seems to have typed: There really isn't any reason not to anymore since everything is backwards compatible. I've found that Dovecot 1.0a3 has a problem with 4.1.x, 4.0.x works perfectly with Dovecot though. Anyway, not *everything* seems to be backward

Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread Olaf Greve
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

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread Andrew P.
On 9/30/05, Olaf Greve [EMAIL PROTECTED] 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

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread martin hudec
Hello, On Fri, Sep 30, 2005 at 08:08:32PM +0400 or thereabouts, Andrew P. wrote: As for the MySQL version (branch) - the only difference you should care about is feature set. If you feel comfortable without triggers and stored procedures (their absence makes many professional

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread martin hudec
Hello, On Fri, Sep 30, 2005 at 09:25:37AM -0700 or thereabouts, Freddie Cash wrote: Scott Long and Kris Kenneway ran various benchmarks back in the early 5.x days comparing MySQL 4 compiled with LinuxThreads, libc_r, libkse (the default threading library on 5.x and 6.x), and libthr. In