CREATE EVENT DeadlockNotification
TYPE Deadlock
HANDLER
BEGIN
INSERT INTO DeadlockDetails WITH AUTO NAME
SELECT snapshotId, snapshotAt, waiter, who, what, object_id, record_id,
owner, is_victim, rollback_operation_count
FROM sa_report_deadlocks ();
COMMIT;
CALL xp_startmail ( mail_user ='John Smith',
mail_password ='mypwd' );
CALL xp_sendmail( recipient='DBAdmin',
subject='Deadlock details added to the DeadlockDetails table.' );
CALL xp_stopmail ( );
END;