接口性能P99，P95计算

如何减少P99响应耗时?(收藏)

https://jishuin.proginn.com/p/763bfbd6a7d5

https://docs.aws.amazon.com/zh_cn/elasticbeanstalk/latest/dg/health-enhanced-metrics.html

S了张屠户就得吃带毛猪，TMD，自己算。

一个月内的P99个数

SELECT 
  FORMAT(cnt*0.01,0) P99_CNT,
  FORMAT(cnt*0.05,0) P95_CNT,
  FORMAT(cnt*0.10,0) P90_CNT
FROM
(
SELECT COUNT(id) cnt FROM sys_api_pt_log
WHERE TIMESTAMPDIFF(MONTH, create_date, CURRENT_TIMESTAMP) <1
) a

计算这些值的平均值

SELECT 
    FORMAT(AVG(sub.invoke_ms),0) ms 
FROM
(SELECT a.*
FROM sys_api_pt_log a 
WHERE
TIMESTAMPDIFF(MONTH, create_date, CURRENT_TIMESTAMP) <1
ORDER BY a.invoke_ms DESC 
LIMIT 10380
)sub