Is it good practice to leave MySQL's "auto commit" mode disabled across a web application?

Question

Regarding MySQL and InnoDB tables, is it considered good practice to globally keep the autocommit mode disabled, so that all SQL statements throughout your code have to be explicitly committed? Does this introduce any overhead or other adverse conditions?

Answer 1

My experience is better to enable it by default if your framework supports it. If you forget to commit, the uncommitted transaction may lock a lot of resources.