Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Wait... what?

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



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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: