News for hackers. Stuff that matters.

A comment on The State of MySQL: The Elephant in the Room. Parent comment

Re:The State of MySQL: The Elephant in the Room by ruby_roo on Tuesday February 10, 2009 @07:36PM (#476268)
Wait... what?

Looks like InnoDB supports transactions, no? http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-mo...

[ Parent | on HN ]
Re:The State of MySQL: The Elephant in the Room by davidw on Wednesday February 11, 2009 @01:22AM (#476642)
http://adam.blog.heroku.com/past/2008/9/3/ddl_transactions/

"MySQL doesn’t support DDL transactions;"

Meaning you can't change the schema transactionally. InnoDB handles data transactions ok, but I hadn't realized that it doesn't handle schema changes. It seems like I'm always discovering some little nasty about Mysql when I am forced to use it.

[ Parent | on HN ]