We are planing to test the performance of the new DB server. For that we have the below the plan:
get production sql queries
replay those sql queries against the different DB
I was planing to use
pt-log-player to play the sql queries and use the
pt-query-digest to analyze the result files which gets generated from
pt-log-player after execution. So my questions are:
- how to get the production query in the first place. enabling slow log query is not an option due to performance reason (as our DB admin denied about that)
pt-log-playeris deprecated, was there any bug or whats the reason behind.
- Or someone can suggest me a complete different toolset to do the perf test. Thanks.