fix(mysql): handle commit for non transactional mysql engines

fix(mysql): handle commit for non transactional mysql engines #3973