Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a standard way to write log messages in MySQL stored procedures?

I can write log messages to a designated log table, but I prefer the standard log mechanism where each message is coupled with severity and sent to an external file.

share|improve this question
Do you mean something like RAISE NOTICE in PostgreSQL? –  dezso Oct 31 '12 at 8:56
If it's redirected to the log files, yes. –  Adam Matan Oct 31 '12 at 8:58
I believe the answer is 'not easily', but you should join the dark side and realize that storing date/time sensitive information (like logs) is a great use for databases. Sure beats parsing date strings with perl. –  Alain Collins Nov 4 '12 at 7:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.