in reply to DBI with MySQL InnoDB tables troubles

If there really are no errors, maybe you need to issue a commit, after the execute?

$dbh->commit

In Section Seekers of Perl Wisdom