how do I get consistent benchmark times with innodb buffer pool?
The environment I work in is extremely frustrating in that I have little to no control over my testing and production environments, and they are not identical!!
I have at least one query that runs fine on staging (or at least appears to), but seems to take up to 16 times longer in production (18.375 seconds compared to 4 minutes 49 seconds). Something is NOT RIGHT!!
These times appear to be without buffering/cache in place because second runs of the query in each environment are less than 1 second.
How can I get accurate times? I attempted SQL_NO_CACHE, but that doesn't help because, as I understand it, the INNODB buffer pool is not affected by that.
I need to be able to present some solid data, and not being able to get consistent run times, and not being sure buffering is or is not in play on either server makes this impossible.
Subject
Views
Written By
Posted
how do I get consistent benchmark times with innodb buffer pool?
1430
April 29, 2015 08:35AM
833
April 30, 2015 05:09PM
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.