How to benchmark Switchable Optimizations in MySQL

by haochen he   Last Updated August 01, 2020 09:06 AM - source

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!

Related Questions

Am I using MySQL BENCHMARK correctly?

Updated August 08, 2019 00:06 AM

How to benchmark two schema designs in Mysql?

Updated September 24, 2018 21:06 PM

SQL Server 2012 Performance Test

Updated January 15, 2018 16:06 PM