Hi.

On Sun 2003-01-26 at 21:58:06 -0700, [EMAIL PROTECTED] wrote:
[...]
> I've heard it's supposed to run faster, but never saw any benchmarks. 
> Faster is better... =)

How about

  http://www.eweek.com/article2/0,3959,293,00.asp

which tests MySQL 4.0.1 and MySQL AB's summary of the latter:

  http://www.mysql.com/eweek/index.html

Unfortuneatly, neither PostgreSQL nor a MySQL 3.23 was not part of the
test.

[...]
> Looking forward to seeing it.  So the MySQL team considers 4.x stable
> now?  Do they recommend using it over 3.x?

According to http://www.mysql.com/downloads/index.html still 3.23.x is
recommended, but from what I know, that probably changes with the next
release (see below).

On Mon 2003-01-27 at 11:55:56 -0700, [EMAIL PROTECTED] wrote:
> On Sun Jan 26, 2003 at 09:10:12PM -0800, Dave Laird wrote:
[...]
> > The last time I looked (last week or two) it was listed as
> > BETA-Stable,

That would be rather be at least 6 weeks, because since 2002-12-14
(v4.0.6) MySQL is declared gamma.

> > but other than having to regenerate the indexes for an existing
> > table which I moved over into my development directories, it was
> > pretty much a bolt-up application.

I am not sure why you *had* to rebuild indexes. AFAIK, MySQL 4.0.x
should work on tables created with 3.23.x (aveats below ;)

[...]
> Ok... I'll wait until it goes stable then, although I might throw it on
> my workstation just to play with some of the new features and such.

According to the 4.0.8 release note, the next version is expected to
be declared stable. Since 4.0.9 was released two days later to fix
some screw-up that slipped by, 4.0.10 is generally thought to be
released as stable, if nothing unexpected happens.

On Sun 2003-01-26 at 22:00:26 -0700, [EMAIL PROTECTED] wrote:
[...]
> Is there any big issues migrating data from a 3.x database to a 4.x
> database?  Is it pretty much a drop in upgrade or do you have to do
> some data conversion first?

The details are listed here:

  http://www.mysql.com/doc/en/Upgrading-from-3.23.html

which looks rather long, although it isn't that much to be aware of.
It's long because they cover every aspect.

The short story is that 4.0.x should work out-of-the-box on a 3.23.x
database and configuration, but you will have to do some tweaking in
order to be able to make full use of the new version.

HTH,

        Benjamin, playing MySQL-advocate, apparently ;-)

Attachment: msg65045/pgp00000.pgp
Description: PGP signature

Reply via email to