MySQL Forums :: Stored Procedures :: Very different behaviour executing stored procedures between 5.5 and 5.7


Advanced Search

Very different behaviour executing stored procedures between 5.5 and 5.7
Posted by: Daniel Bradley ()
Date: February 15, 2017 10:43PM

Hi,

We recently upgraded from Ubuntu 14 LTS to 16 LTS, and in so doing, from MySQL 5.5 to MySQL 5.7.

We are getting very different behaviour regarding the execution of stored procedures between the two different systems.
Firstly, MySQL 5.7 seems to return a result set from a stored procedure as soon as a select statement is encountered and doesn't wait until the stored procedure completes.
Secondly, performance is much much slower. Stored procedures that used to execute almost instantaneously are now taking many seconds to execute. Tests were performed in isolated VMs so the only real difference was MySQL (and Apache/PHP).

Is there any documentation that describes any differences in how stored procedures are implemented in MySQL 5.7 compared to 5.5?

Does anybody have any experience with this that might help me deal with the situation?

At the moment, I'm considering downgrading back to MySQL 5.5.

Regards,
Daniel Bradley

Options: ReplyQuote


Subject Views Written By Posted
Very different behaviour executing stored procedures between 5.5 and 5.7 379 Daniel Bradley 02/15/2017 10:43PM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7 52 Peter Brawley 02/16/2017 01:31AM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7 62 Daniel Bradley 02/17/2017 06:34PM
Re: Very different behaviour executing stored procedures between 5.5 and 5.7 43 Peter Brawley 02/17/2017 08:13PM


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.