In practice autocommit works very well. In many workloads most transactions consist of just one query. Additional if you have autocommit it is harder to acciden

In practice autocommit works very well. In many workloads most transactions consist of just one query. Additional if you have autocommit it is harder to accidentally create a long running transaction which is a good thing since long running transactions can really tank your performance.