3 ms·
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 sm
by evanelias 2y ago
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 https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html. Hardly an "obstical course".
- stickfigure 2y ago"Aside from missing his head, the patient appears to be in fine shape."
- evanelias 2y agoThat 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.
- stickfigure 2y agoSorry - I was trying to make light of the discussion. DDL is so important that it's silly to talk about the other stuff.