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

It's not just DDL that isn't transactional, there's a whole bunch of other things that aren't. And they break the transactionality silently. It's like an obstical course where bumping into something might be fatal.


What specific non-DDL things are you referring to here?

Aside from DDL, the only other major ones are manipulating users/grants, manipulating replication, a small number of other administrative commands, and LOCK TABLES.

This is all documented very clearly on https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html. Hardly an "obstical course".


"Aside from missing his head, the patient appears to be in fine shape."


That hardly seems equivalent. Why do you need to e.g. reconfigure replication inside of a transaction in the first place?

The lack of transactional DDL is a totally valid complaint, but the non-DDL stuff is just a total head-scratcher to me. Aside from DDL, implicit commits have literally never impacted me in my 21 years of using MySQL.


Sorry - I was trying to make light of the discussion. DDL is so important that it's silly to talk about the other stuff.




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

Search: