QPS

sum(rate(infra_mysql_request_duration_seconds_count{env=~”$env”,resource=~”$project”,instance=~”$host”})) by (database)

实时状态（Gauge）

infra_commons_db_connection_pool_active_num{env=~”$env”,service=~”$project”,instance=~”$host”}

每分钟/每小时的总和

sum(increase(infra_mysql_request_errors_total{env=”$env”,service=”$project”,instance=~”$host”}[1m])) by (domain,database,physicalSchema)
image.png

平均耗时（sum / count）

sum(rate(infra_mysql_request_duration_seconds_sum{env=”$env”,service=”$project”,instance=~”$host”})[15s]) by (database)
/
sum(rate(infra_mysql_request_duration_seconds_count{env=”$env”,service=”$project”,instance=~”$host”})[15s]) by (database)

P95 P99 P999耗时

histogram_quantile(0.95, sum(rate(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”}[1m])) by (le, domain, database))

耗时大于某个阈值的计数和

sum(increase(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”, le=”+Inf”}[1m])) by (domain, database)
-
sum(increase(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”, le=”1.0”}[1m])) by (domain, database)

耗时大于某个阈值的次数比例

(
sum(increase(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”, le=”+Inf”}[1m])) by (domain, database)
-
sum(increase(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”, le=”1.0”}[1m])) by (domain, database)
)
/
sum(increase(infra_mysql_request_duration_seconds_bucket{env=”$env”,service=”$project”,instance=~”$host”}[1m])) by (domain, database)

top n

topk_max(7, xxx)

比例（如成功率）

1 -
(
sum
(
rate(infra_http_request_duration_seconds_count{service=”$service”, status=~”5.*”, region=~”$region”, venv=~”$venv”}),
rate(infra_rpc_server_request_errors_total{service=”$service”, region=~”$region”, venv=~”$venv”}))
)
/
(
sum
(
rate(infra_http_request_duration_seconds_count{service=”$service”, region=~”$region”, venv=~”$venv”}),
rate(infra_rpc_server_request_duration_seconds_count{service=”$service”, region=~”$region”, venv=~”$venv”}
)
)
)

or vector(1)

Grafana使用

https://blog.csdn.net/csywwx2008/article/details/109192855