MySQL Forums
Forum List  »  Newbie

Re: real time performance issues
Posted by: Phillip Ward
Date: March 30, 2020 07:53AM

All stored procedures do is to run SQL on your behalf.

Working out why [the SQL executed by] a procedure is running slowly is exactly the same as doing so for any other piece of SQL.

Find out which queries are slow, get the Execution Plan for each slow query, use that to understand why it's slow and then make changes to resolve the problem.

And yes; that third step is the "tricky" one.

You'll need to get to grips with some of the database's internal workings, because they inform what many of the bits of the Plan mean and, more than likely, pop back here with some really "sticky" Plans (and accompanying Table structures) when you get stuck. That's what I do. :-)

There is no "Magic Bullet" to Database [Workload] Tuning.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
March 28, 2020 02:26AM
Re: real time performance issues
March 30, 2020 07:53AM


Sorry, you can't reply to this topic. It has been closed.

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.