MySQL Forums :: Stored Procedures :: MySQL with Profile - Stored Procedures


Advanced Search

Re: MySQL with Profile - Stored Procedures
Posted by: Peter Brawley ()
Date: February 28, 2017 02:41PM

> You're not wrong.

Then why aren't you doing it?

Quote

A problem has just been identified and if I am monitoring it through free software or through the command of the database itself, I do this identification of the stored procedure and see the parameters that were passed to it and so I can do to the similar to what You would need to know which stored procedure was executed, but mostly identifying the parameters that were passed to it, which can come from several locations.

I'm unaware of any free tool that automates that for MySQL. If you seriously want such functionality, you'll have to write it into your stored procedures, eg as debugging code activated by a mysql user variable. Doable but a lot of work, and awkward.

MySQL sprocs have many limitations. Usually, if there's a choice between doing a task in straight SQL vs implementing it in an sproc, straight SQL is preferable for several reasons. So what's the circumstance requiring this particular sproc?

Options: ReplyQuote


Subject Views Written By Posted
MySQL with Profile - Stored Procedures 448 Claudinei Silva 02/16/2017 08:41PM
Re: MySQL with Profile - Stored Procedures 60 Peter Brawley 02/17/2017 08:51PM
Re: MySQL with Profile - Stored Procedures 47 Claudinei Silva 02/18/2017 09:44PM
Re: MySQL with Profile - Stored Procedures 49 Peter Brawley 02/19/2017 03:40AM
Re: MySQL with Profile - Stored Procedures 47 Claudinei Silva 02/19/2017 05:06AM
Re: MySQL with Profile - Stored Procedures 44 Peter Brawley 02/19/2017 10:55AM
Re: MySQL with Profile - Stored Procedures 74 Claudinei Silva 02/19/2017 04:31PM
Re: MySQL with Profile - Stored Procedures 56 Peter Brawley 02/25/2017 07:56AM
Re: MySQL with Profile - Stored Procedures 30 Claudinei Silva 02/25/2017 09:57PM
Re: MySQL with Profile - Stored Procedures 34 Peter Brawley 02/26/2017 12:28PM
Re: MySQL with Profile - Stored Procedures 55 Claudinei Silva 02/26/2017 06:50PM
Re: MySQL with Profile - Stored Procedures 51 Peter Brawley 02/26/2017 07:25PM
Re: MySQL with Profile - Stored Procedures 58 Claudinei Silva 02/28/2017 12:57AM
Re: MySQL with Profile - Stored Procedures 27 Peter Brawley 02/28/2017 10:57AM
Re: MySQL with Profile - Stored Procedures 32 Claudinei Silva 02/28/2017 01:37PM
Re: MySQL with Profile - Stored Procedures 54 Peter Brawley 02/28/2017 02:41PM
Re: MySQL with Profile - Stored Procedures 34 Claudinei Silva 02/28/2017 03:36PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.