Add native autocommit supoprt to the MySQL backend

This is a first pass at that feature. Obviously missing docs, and probably some tests.