Debugging MySQL stored procedures — how do you handle it?
Archived a month ago
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.
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.