knowledge-database (beta)

Current group: pgsql.advocacy

Re: MySQL 5 comparison

Re: MySQL 5 comparison  
Merlin Moncure
 Re: MySQL 5 comparison  
Robert Treat
 Re: MySQL 5 comparison  
Robert Bernier
 Re: MySQL 5 comparison  
Ned Lilly
 Re: MySQL 5 comparison  
Robert Treat
 Re: MySQL 5 comparison  
Robert Bernier
From:Merlin Moncure
Subject:Re: MySQL 5 comparison
Date:Thu, 6 Jan 2005 08:45:44 -0500
> Has anyone spent any time with the MySQL 5.0 alpha, set to go into
beta
> shortly
(http://www.infoworld.com/article/05/01/04/HNmysql5beta_1.html)?
>
> Would be interesting to have a rudimentary comparison checklist - not
so
> much benchmarks, as features, as they seem to have added a lot. And
any
> info on how they've implemented these features (e.g. multiple table
types
> in order to use different features, etc.) would be of interest.
>
> Cheers,
> Ned

Putting my advocacy hat on,
If you look at their description of the upcoming features, it's
saturated with words like 'basic', 'initial', and 'rudimentary'. I
don't think mysql 5.0 will be a watershed moment where it will become
the database of choice for industrial application development...

The new stuff on a point by point feature comparison may look
impressive, but they need to work on internal stuff like the locking
engine, get some real logging etc.

On a more even handed note, it's nice to see them get some real
features. Open source success stories are not zero-sum, so what's good
for them is not necessarily bad for us. Competition is good, but pg is
at least 3 years ahead of them in development!

Merlin

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
From:Robert Treat
Subject:Re: MySQL 5 comparison
Date:06 Jan 2005 09:40:05 -0500
Well, I think those of us in the pg community would be interested in
reading it, but IMHO it's a losing proposition for SRA to push articles
that highlight the negativities of other database systems. If you're
going to go down that road you had better tread carefully; personally I
would stick to articles that highlight customer successes.

Robert Treat

On Thu, 2005-01-06 at 09:11, Robert Bernier wrote:
> Guys,
>
> I sent an email to Hans-Jürgen Schönig and asked if he
> could give me particulars about the bench marking he did. Could I have some
> comments about the idea of making a more structured presentation in an
> article, in the next SRA newsletter, http://sraapowergres.com ?
>
>
> On January 6, 2005 08:45 am, you wrote:
> > > Has anyone spent any time with the MySQL 5.0 alpha, set to go into
> >
> > beta
> >
> > > shortly
> >
> > (http://www.infoworld.com/article/05/01/04/HNmysql5beta_1.html)?
> >
> > > Would be interesting to have a rudimentary comparison checklist - not
> >
> > so
> >
> > > much benchmarks, as features, as they seem to have added a lot. And
> >
> > any
> >
> > > info on how they've implemented these features (e.g. multiple table
> >
> > types
> >
> > > in order to use different features, etc.) would be of interest.
> > >
> > > Cheers,
> > > Ned
> >
> > Putting my advocacy hat on,
> > If you look at their description of the upcoming features, it's
> > saturated with words like 'basic', 'initial', and 'rudimentary'. I
> > don't think mysql 5.0 will be a watershed moment where it will become
> > the database of choice for industrial application development...
> >
> > The new stuff on a point by point feature comparison may look
> > impressive, but they need to work on internal stuff like the locking
> > engine, get some real logging etc.
> >
> > On a more even handed note, it's nice to see them get some real
> > features. Open source success stories are not zero-sum, so what's good
> > for them is not necessarily bad for us. Competition is good, but pg is
> > at least 3 years ahead of them in development!
> >
> > Merlin
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
From:Robert Bernier
Subject:Re: MySQL 5 comparison
Date:Thu, 6 Jan 2005 09:52:31 -0500
Good point, but hard, solid, dependable information that is well presented is
something you can't just ignore. I would like to go down this road a little
farther and then look at the final product before deciding to publish or not.


On January 6, 2005 09:40 am, Robert Treat wrote:
> Well, I think those of us in the pg community would be interested in
> reading it, but IMHO it's a losing proposition for SRA to push articles
> that highlight the negativities of other database systems. If you're
> going to go down that road you had better tread carefully; personally I
> would stick to articles that highlight customer successes.
>
> Robert Treat
>
> On Thu, 2005-01-06 at 09:11, Robert Bernier wrote:
> > Guys,
> >
> > I sent an email to Hans-Jürgen Schönig and asked
> > if he could give me particulars about the bench marking he did. Could I
> > have some comments about the idea of making a more structured
> > presentation in an article, in the next SRA newsletter,
> > http://sraapowergres.com ?
> >
> > On January 6, 2005 08:45 am, you wrote:
> > > > Has anyone spent any time with the MySQL 5.0 alpha, set to go into
> > >
> > > beta
> > >
> > > > shortly
> > >
> > > (http://www.infoworld.com/article/05/01/04/HNmysql5beta_1.html)?
> > >
> > > > Would be interesting to have a rudimentary comparison checklist - not
> > >
> > > so
> > >
> > > > much benchmarks, as features, as they seem to have added a lot. And
> > >
> > > any
> > >
> > > > info on how they've implemented these features (e.g. multiple table
> > >
> > > types
> > >
> > > > in order to use different features, etc.) would be of interest.
> > > >
> > > > Cheers,
> > > > Ned
> > >
> > > Putting my advocacy hat on,
> > > If you look at their description of the upcoming features, it's
> > > saturated with words like 'basic', 'initial', and 'rudimentary'. I
> > > don't think mysql 5.0 will be a watershed moment where it will become
> > > the database of choice for industrial application development...
> > >
> > > The new stuff on a point by point feature comparison may look
> > > impressive, but they need to work on internal stuff like the locking
> > > engine, get some real logging etc.
> > >
> > > On a more even handed note, it's nice to see them get some real
> > > features. Open source success stories are not zero-sum, so what's good
> > > for them is not necessarily bad for us. Competition is good, but pg is
> > > at least 3 years ahead of them in development!
> > >
> > > Merlin
> > >
> > > ---------------------------(end of
> > > broadcast)--------------------------- TIP 2: you can get off all lists
> > > at once with the unregister command (send "unregister
> > > YourEmailAddressHere" to majordomo@postgresql.org)
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
From:Ned Lilly
Subject:Re: MySQL 5 comparison
Date:Thu, 06 Jan 2005 09:17:41 -0500
Merlin Moncure wrote:

> Putting my advocacy hat on,
> If you look at their description of the upcoming features, it's
> saturated with words like 'basic', 'initial', and 'rudimentary'. I
> don't think mysql 5.0 will be a watershed moment where it will become
> the database of choice for industrial application development...

That reminds me of another, related question ... can anyone comment on the relationship between MySQL 5 and MaxDB (formerly SAP DB)? The talk at one point was that the end result of that alliance would be a total rewrite of MySQL to incorporate concepts from MaxDB, and that the new product would somehow be backward compatible with both predecessors.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
From:Robert Treat
Subject:Re: MySQL 5 comparison
Date:06 Jan 2005 15:55:57 -0500
On Thu, 2005-01-06 at 11:53, Josh Berkus wrote:
> Ned,
>
> > That reminds me of another, related question ... can anyone comment on the
> > relationship between MySQL 5 and MaxDB (formerly SAP DB)? The talk at one
> > point was that the end result of that alliance would be a total rewrite of
> > MySQL to incorporate concepts from MaxDB, and that the new product would
> > somehow be backward compatible with both predecessors.
>
> That was the idea, yes. Personally, I don't think it's possible; that's
> probably the reason why MySQL 5.0 is two years late. I think eventually
> MySQL AB will have to come to terms with the idea that they have two seperate
> products, MySQL and MaxDB, and the two can't be made compatible.
>

I think the last theory I had heard was that they were going to make a
maxdb table type for my$ql that would be compatible with maxdb. This
much could work on it's surface (like so many things with my$ql, think
using transactions with myisam which doesnt work but doesnt toss errors)

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
From:Robert Bernier
Subject:Re: MySQL 5 comparison
Date:Thu, 6 Jan 2005 09:11:06 -0500
Guys,

I sent an email to Hans-Jürgen Schönig and asked if he
could give me particulars about the bench marking he did. Could I have some
comments about the idea of making a more structured presentation in an
article, in the next SRA newsletter, http://sraapowergres.com ?


On January 6, 2005 08:45 am, you wrote:
> > Has anyone spent any time with the MySQL 5.0 alpha, set to go into
>
> beta
>
> > shortly
>
> (http://www.infoworld.com/article/05/01/04/HNmysql5beta_1.html)?
>
> > Would be interesting to have a rudimentary comparison checklist - not
>
> so
>
> > much benchmarks, as features, as they seem to have added a lot. And
>
> any
>
> > info on how they've implemented these features (e.g. multiple table
>
> types
>
> > in order to use different features, etc.) would be of interest.
> >
> > Cheers,
> > Ned
>
> Putting my advocacy hat on,
> If you look at their description of the upcoming features, it's
> saturated with words like 'basic', 'initial', and 'rudimentary'. I
> don't think mysql 5.0 will be a watershed moment where it will become
> the database of choice for industrial application development...
>
> The new stuff on a point by point feature comparison may look
> impressive, but they need to work on internal stuff like the locking
> engine, get some real logging etc.
>
> On a more even handed note, it's nice to see them get some real
> features. Open source success stories are not zero-sum, so what's good
> for them is not necessarily bad for us. Competition is good, but pg is
> at least 3 years ahead of them in development!
>
> Merlin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
   

Copyright © 2006 knowledge-database   -   All rights reserved