mysql - SQL语句性能测试

Question

现在有一句sql1及其变换sql2，两句sql同环境下单独执行不好分辨其优劣，所以我想通过QPS这个指标来衡量它们。求助各位大神有没这类工具或者方案能够获取sql语句的QPS值。拜谢~

Answer 1

I don’t know that there is such a mechanism in

sql. Are you looking for a monitoring tool corresponding to the database? For example sqlserver的profiler and the like.

In addition, you can test it in the program. The execution time difference of the monitoring program is roughly comparable, although there is a deviation.

Answer 2

Mysql I don’t know, SQL Server has execution plans to compare