Tool to debug a stored Procedure on linux

Asked

Viewed 219 times

1

would like to know if anyone knows or even used any tool to realize a debug in stored procedures in linux.

I am currently using the Mysql Workbench and the Dbvisualizer, but as far as I know none of them provides the functionality of thresh one Procedure internally.

mysql database stored-procedures

  • I don’t understand why use the English terms in this case. A doubt, you want thresh exactly what? Performance?

  • I don’t understand exactly what the relevance of using or not using the English terms. I would like to "debug" the "body" of the "procedure"

  • Of course sorry I forgot that everyone speaks English :) (sorry for the sarcasm). I understand you want to "debug" the query structure and maybe the result too (I think).

  • 1

    @Joãomanolo Take a look at this project, should be of interest to you. This article should also be useful.

  • @Guilhermenascimento we agree that in our area of activity the minimum of knowledge in English is a fundamental factor for any developer. That’s right! Just the query structure, because it is very extensive and tiring.

  • @Qmechanic73, did not know this project I will take a look!

  • @Jonathan, I know that, but in my opinion you’ve given "boredom" what makes their use strange. I personally have knowledge of English (read only) only that in my view the term Feature in the context of the question had nothing to do with "programming", would fit there maybe something like functionality or tool.

  • Ok @Guilhermenascimento, taking into account that you have more experience here in the community I will edit the question. Thanks for the tip.

  • 1

    Thanks for the consideration for my tip :) Good luck and welcome!

Show 4 more comments

2 answers

2

I know it’s not quite what you’re looking for, but you can always make a:

SELECT CONCAT('O valor de x é', x);

In the middle of your stored file. This "prints" the value of a variable on the screen.

If you really need a Bugger, I found some tools like Mydebugger.

  • So Anthony Accioly I’ve adopted this practice, but it’s been a little laborious and massive. Unfortunately Mydebugger does not "wheel" correctly with Wine (I already did the test in the morning).

1


Well, I ended up taking the following approach:

installed the crossover (that implements the Wine as a basis) in Ubuntu 14.04 and soon after the mydebugger (suggested by Anthony Accioly) and worked perfectly.

Browser other questions tagged mysql database stored-procedures

You are not signed in. Login or sign up in order to post.