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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.