Mysql on a non-transactional table can't rollback anything, so anytime it sees that issued on a non-rollback table, the transaction is lost and it always gives that warning. DBI was not designed explicitly for certain databases, so it's a feature I believe you have to live with (if you can't modify the mysql configuration which may have an option to turn the warning off... i don't thinks so though.)