Possible to have a statement in stored procedure outside of current transaction? During a series of statements in my stored procedure I wish to log an entry by inserting a record. That record needs to survive even if the overall SP ends up rolling back.

Is this possible?
Declare the log table to be ENGINE=MyISAM.