4 ms·
I'm with you on all of your points except auto-commit: having it off by default is much better, it forces you to explicitly commit when you change data and thus
by quicksilver03 10y ago
I'm with you on all of your points except auto-commit: having it off by default is much better, it forces you to explicitly commit when you change data and thus think if you really want to persist the changes.
- je42 10y agoyes. except that all other clients have auto commit on. thus if you transition from that to auto-commit off. You face two issues: 1. you don't know. and you thing you commited something but actually you didn't 2. you forgot and you committed something. but transaction keeps an row lock open and you bring down the server... :)