search

Home  >  Q&A  >  body text

mysql - SQL语句性能测试

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

天蓬老师天蓬老师2836 days ago618

reply all(2)I'll reply

  • 黄舟

    黄舟2017-04-17 13:10:45

    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.

    reply
    0
  • 高洛峰

    高洛峰2017-04-17 13:10:45

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

    reply
    0
  • Cancelreply