For those of your developing stored procedures, this might well be what you are looking for. This is the set of tools that I presented as OSSDB in Frankfurt a few weeks back, now a bit updated and bugfixed and packaged. For more information, read the documentation for this tool.
The project is available on Sourceforge as myProcDbg and the project homepage is at
http://myprocdbg.sourceforge.net (This is a redirect, which will eventually change).
In short, it allows you to do "printf"-style debugging by a UDF that sends messages to a monitor application. It does not require any "trace" tables or anything like that, just a simple UDF.
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson (anders@mysql.com)
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
Personal homepage: www.papablues.com
Personal email:
anders@papablues.com