Debugging MySQL stored procedures — how do you handle it?
S
Sashа Panasiuk
Verified
Hi everyone )
I’d like to get some feedback from the community.
In my work, I’ve often found that debugging MySQL stored procedures is quite painful — lots of SELECTs statements, temporary tables, comments, and still limited visibility into what’s really happening.
I’m exploring the idea of a tool that would make stored procedure debugging easier (e.g. variable inspection, step-by-step execution, breakpoints and so on).
A few quick questions:
1. Is this a problem you also face? How painful is it for you?
2. How do you currently debug stored procedures?
3. Would a dedicated debugging tool be useful for you?
Any feedback, experiences, or links would be really appreciated 🙏
Just trying to validate whether this is a real problem or if I’m missing something obvious.
