I want to benchmark the performance of Switchable Optimizations in MySQL, i.e., comparing the query latency and the result of
EXPLAIN with/without using these optimization switches.
I have already tried to use sysbench and MySQL official test-suite. But I fond that they are too general and mainly for functional testing, i.e., runing these tests with/without the optimization switches, the performance are almost identical. What I want is sth like a performance test suite.
Could you please suggest me some good tools/suites to fulfill my demands? Thanks!