On one MariaDB base (I think for my question, it is common with MySQL), I created an event :
CREATE DEFINER=`sa`@`10.0.2.2` EVENT `activities_cleaning_monthly`
EVERY 1 MONTH STARTS '2014-09-29 14:05:34'
ON COMPLETION NOT PRESERVE
DO delete from activities where modif_dt <= date_sub(now(), interval 1 month)
My question is simple : How to log actions of this event ?
I have to create a procedure to put informations on an user table ?
I hope another solution.