Thread: Devx Database Comparison [Updated]
Hello, This matrix should be more accurate. Let me know if there are any problems you see. http://www.devx.com/dbzone/Article/29480 Sincerely, Joshua D. Drake
Shouldn't RI be listed as external for MySQL? On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote: > Hello, > > This matrix should be more accurate. Let me know if there are any > problems you see. > > http://www.devx.com/dbzone/Article/29480 > > Sincerely, > > Joshua D. Drake > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
MVCC in mysql 5.0??? MVCC in One$DB 4.0??? On 11/15/05, Joshua D. Drake <jd@commandprompt.com> wrote: > Hello, > > This matrix should be more accurate. Let me know if there are any > problems you see. > > http://www.devx.com/dbzone/Article/29480 > > Sincerely, > > Joshua D. Drake > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
Pascual De Ruvo wrote: > MVCC in mysql 5.0??? > Innodb supports MVCC AFAIC. > MVCC in One$DB 4.0??? > Uday is who put forth the One$Db stuff so it is the president of that company saying they have MVCC. > On 11/15/05, Joshua D. Drake <jd@commandprompt.com> wrote: > >> Hello, >> >> This matrix should be more accurate. Let me know if there are any >> problems you see. >> >> http://www.devx.com/dbzone/Article/29480 >> >> Sincerely, >> >> Joshua D. Drake >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
Jim C. Nasby wrote: > Shouldn't RI be listed as external for MySQL? > If you mean Referential Integrity, Innodb supports Foreign Keys as far as I know. Sincerely, Joshua D. Drake > On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote: > >> Hello, >> >> This matrix should be more accurate. Let me know if there are any >> problems you see. >> >> http://www.devx.com/dbzone/Article/29480 >> >> Sincerely, >> >> Joshua D. Drake >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> >> > >
Well, I guess the question is: is InnoDB considered external? I would argue it is, since afaik you have to get it yourself unless you buy the pro version. BTW, this also applies to MVCC too. Probably some other stuff. On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote: > Jim C. Nasby wrote: > >Shouldn't RI be listed as external for MySQL? > > > > If you mean Referential Integrity, Innodb supports Foreign Keys as far > as I know. > > Sincerely, > > Joshua D. Drake > > >On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote: > > > >>Hello, > >> > >>This matrix should be more accurate. Let me know if there are any > >>problems you see. > >> > >>http://www.devx.com/dbzone/Article/29480 > >> > >>Sincerely, > >> > >>Joshua D. Drake > >> > >> > >>---------------------------(end of broadcast)--------------------------- > >>TIP 5: don't forget to increase your free space map settings > >> > >> > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
On Tuesday 15 November 2005 16:11, Joshua D. Drake wrote: > Pascual De Ruvo wrote: > > MVCC in mysql 5.0??? > > Innodb supports MVCC AFAIC. > I think what people are chaffing at is the whole "it works in innodb but not in myisam" that seems to apply to so many of my$ql's features. Of course given their design, there are so many if's and but's (and candies and nuts) that putting all of that into a comparison chart is going to be painful. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
jnasby@pervasive.com ("Jim C. Nasby") writes: > Shouldn't RI be listed as external for MySQL? If "replication support" is listed as included, that may be a reasonable tradeoff ;-). -- select 'cbbrowne' || '@' || 'acm.org'; http://cbbrowne.com/info/multiplexor.html "Only witch doctors and quacks use secret techniques validated by how much people will pay for them." -- <brlewis@my-dejanews.com>
Jim C. Nasby wrote: > Well, I guess the question is: is InnoDB considered external? I would > argue it is, since afaik you have to get it yourself unless you buy the > pro version. No, InnoDB is included in all default (Open Source) downloads since version 4.0, I believe. You don't have to pay for GPL InnoDB. AFAIK, only the hot backup tool from InnoDB is not available with GPL. Hot backup should have an * in the comparision. Best Regards, Michael Paesold
Jim C. Nasby wrote: > Well, I guess the question is: is InnoDB considered external? I would > argue it is, since afaik you have to get it yourself unless you buy the > pro version. > As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL. > BTW, this also applies to MVCC too. Probably some other stuff. > > On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote: > >> Jim C. Nasby wrote: >> >>> Shouldn't RI be listed as external for MySQL? >>> >>> >> If you mean Referential Integrity, Innodb supports Foreign Keys as far >> as I know. >> >> Sincerely, >> >> Joshua D. Drake >> >> >>> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote: >>> >>> >>>> Hello, >>>> >>>> This matrix should be more accurate. Let me know if there are any >>>> problems you see. >>>> >>>> http://www.devx.com/dbzone/Article/29480 >>>> >>>> Sincerely, >>>> >>>> Joshua D. Drake >>>> >>>> >>>> ---------------------------(end of broadcast)--------------------------- >>>> TIP 5: don't forget to increase your free space map settings >>>> >>>> >>>> >>> >>> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match >> >> > >
Michael Paesold wrote: > Jim C. Nasby wrote: >> Well, I guess the question is: is InnoDB considered external? I would >> argue it is, since afaik you have to get it yourself unless you buy the >> pro version. > > No, InnoDB is included in all default (Open Source) downloads since > version 4.0, I believe. > You don't have to pay for GPL InnoDB. > > AFAIK, only the hot backup tool from InnoDB is not available with GPL. > Hot backup should have an * in the comparision. I did not include the * for hot backup because it is commercial. > > Best Regards, > Michael Paesold > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
Joshua D. Drake wrote: > Michael Paesold wrote: >> AFAIK, only the hot backup tool from InnoDB is not available with GPL. >> Hot backup should have an * in the comparision. > > I did not include the * for hot backup because it is commercial. Ah, ok. I forgot this was all about non-commercial DBMS software. Thanks for for the reminder. Best Regards, Michael Paesold
MySQL's had MVCC since 4.0. Pascual De Ruvo wrote: > MVCC in mysql 5.0??? > MVCC in One$DB 4.0??? > > On 11/15/05, Joshua D. Drake <jd@commandprompt.com> wrote: > >>Hello, >> >>This matrix should be more accurate. Let me know if there are any >>problems you see. >> >>http://www.devx.com/dbzone/Article/29480 >> >>Sincerely, >> >>Joshua D. Drake >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 5: don't forget to increase your free space map settings >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Not sure exactly what the "Triggers: statement / row level" item means, but mysql's trigger are definitely row only. Some funny stuff I found while seeing if I had remembered that correctly below. From the official mysql dev docs on triggers: http://dev.mysql.com/tech-resources/articles/mysql-triggers.html === But remember that functions are subject to severe limitations: you cannot access tables from within a function. So these statements are illegal inside a function: ALTER 'CACHE INDEX' CALL COMMIT CREATE DELETE DROP 'FLUSH PRIVILEGES' GRANT INSERT KILL LOCK OPTIMIZE REPAIR REPLACE REVOKE ROLLBACK SAVEPOINT 'SELECT FROM table' 'SET system variable' 'SET TRANSACTION' SHOW 'START TRANSACTION' TRUNCATE UPDATE Precisely the same limitation applies for triggers. Triggers are very new. There are bugs. Therefore I give the same warning that I gave for stored procedures. Do not try triggers with a database that has important data in it. Instead, create a new database for testing purposes, and make sure this test database is the default, whenever you are creating or using tables with triggers. ... Lastly, the [older mysql] manual used to say that if you have triggers, then queries will be slower. Forget that too, triggers have no effect on queries. === - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200511152239 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFDeqqGvJuQZxSWSsgRAikHAJ9KMrKxFd65nUCAZUTkZsVuHF+iawCgr3uv eYhHO5qnt7K5W89SB/a6+SY= =vTrk -----END PGP SIGNATURE-----
On 11/15/2005 5:13 PM, Joshua D. Drake wrote: > Jim C. Nasby wrote: >> Well, I guess the question is: is InnoDB considered external? I would >> argue it is, since afaik you have to get it yourself unless you buy the >> pro version. >> > As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL. It ships with it, but it is still an add-on, implementation wise. And AFAIK this is the reason why they don't have deferrable foreign keys. Jan > > >> BTW, this also applies to MVCC too. Probably some other stuff. >> >> On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote: >> >>> Jim C. Nasby wrote: >>> >>>> Shouldn't RI be listed as external for MySQL? >>>> >>>> >>> If you mean Referential Integrity, Innodb supports Foreign Keys as far >>> as I know. >>> >>> Sincerely, >>> >>> Joshua D. Drake >>> >>> >>>> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote: >>>> >>>> >>>>> Hello, >>>>> >>>>> This matrix should be more accurate. Let me know if there are any >>>>> problems you see. >>>>> >>>>> http://www.devx.com/dbzone/Article/29480 >>>>> >>>>> Sincerely, >>>>> >>>>> Joshua D. Drake >>>>> >>>>> >>>>> ---------------------------(end of broadcast)--------------------------- >>>>> TIP 5: don't forget to increase your free space map settings >>>>> >>>>> >>>>> >>>> >>>> >>> ---------------------------(end of broadcast)--------------------------- >>> TIP 9: In versions below 8.0, the planner will ignore your desire to >>> choose an index scan if your joining column's datatypes do not >>> match >>> >>> >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
>> >> As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL. > > > It ships with it, but it is still an add-on, implementation wise. I think that is getting a little long in the tooth in terms of the general public. To the general public and to MySQL people, InnoDb is a part of their database and it is Open Source. -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/