MySQL Forums
Forum List  »  Optimizer & Parser

Disable caching in MYSQL for True performance testings?
Posted by: Sing Lau
Date: July 11, 2021 02:47PM

We are trying to optimize some of the slow sql queries. When we first run the query, it's about XX secs, but after the first run, it only takes less than 1 sec for running the same query. It's really hard to compare the results for performance testing or query tunning.

We have disabled the query cache in RDS parameter groups by setting the query cache type,size and limit to 0. And I have set the innodb buffer pool size to the minimum value and the innodb_old_page_pt to 5. But it's still acting the same -- after the first run, it will be much faster. Unless we have to restart the server or wait for couple of hours or days, then it will show the XX secs again.



Can anyone please suggest me how can I disable the caching in MySQL so that we can show the improvement on the query tunning? Thank you in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Disable caching in MYSQL for True performance testings?
194
July 11, 2021 02:47PM


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.