mysql - track work of stored procedure
1) add logging to console
CALL log(concat('my procedure name - start - ', some_variable));
2) store log into external file
select "some record" as log into outfile '/tmp/result.txt';
3) add records into temporary table
insert into tmptable select concat('my procedure name - start - ', some_variable);