MySQL Forums
Forum List  »  Performance

Analyzing sql query performance issues
Posted by: Bapi P
Date: October 12, 2024 02:58AM

Hello,
I have few questions in regards to query performance tuning. (Note- its version 8.0.32)

1) I understand we use "explain analyze" to see the execution plan and it shows the exact resource consumption by running the query behind the scene. But still its quite difficult to understand the exact part of the query which is taking time or relating the exact line of the plan to exact predicate of the query. So is there any other option available through which we can see these information?

2)And is there any option to mimic or force certain execution path of the query so that it always follows the same without deviating from that. As because we saw change in execution path for same query many times impact the query response time negatively.

3) We want to track the historical query response time for any query , if there any data dictionary of catalog tables which which can be queried to see when the application query was running fast vs slow in past, and then further dig into it to fix it if needed (for example if its changing execution path in between on some days) ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Analyzing sql query performance issues
180
October 12, 2024 02:58AM


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.