set auto commit to false after compacting