On Tue, Sep 30, 2003 at 08:30:08AM +0800, Eduardo A. dela Rosa wrote: > On Tue, 2003-09-30 at 03:03, Michael Chaney wrote: > > > MySQL doesn't have the base necessary to provide real transaction > > handling. They have to add real logging and real row-level locking > > before they can support the higher level concept of transactions. > > > Forgive me but I don't agree to your explanation that MySQL doesn't > provide "real" transaction. > Since the release version 3.23.54 of MySQL, there has been a very > consistent and stable implementation > of support for Transaction. > > If you really have used MySQL DB, you would of course implement the > Standard version of it and > configure with either InnoDB or Berkely DB to provide support for > transaction (PK and FK supports as well). > It's a not really a tedious for work for those who are accustomed to > intalling, configuring, and using it.
My bad, looks like they actually have fixed rollback since I last looked and it didn't work correctly. I'm still not convinced that their binary log is a real log; particularly given their history of claiming to do a certain thing (e.g. rollbacks) while doing something else. > > That doesn't mean that they don't claim they do. But the bottom line is > > that real transactions require a real log, and I don't see it happening. > > > Using InnoDB or Berkely with MySQL, you would allocate log file size, > path, and other pertinent settings > which are already included in some "my.cnf" files (but commented by > default) and will depend on the > scalability requirements to which it will be implemented (enterprise, > medium, small). Well, that makes me think all the more that they're not actually logging. A real log can't be of fixed size; it must grow as transactions are completed. Regardless, the question ultimately comes to this: do you want a system that has these features duct-taped to the side, or one that was correctly designed from the start? That I have to use InnoDB or BDB tables to get these features is, as far as I'm concerned, even more evidence that MySQL isn't up to snuff and likely never will be. Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
