Skip to content

Usage

Jump to bottom
elbaro edited this page Apr 24, 2023 · 1 revision

  1. Run mysqld and mybee

  2. Connect to mysqld and make queries

> use performance_schema;
> select * from users;
  1. Latency metrics are available athttp://localhost:9000
# HELP latency query latency
# TYPE latency summary
latency{quantile="0"} 0
latency{quantile="0.5"} 0
latency{quantile="0.9"} 0
latency{quantile="0.95"} 0
latency{quantile="0.99"} 0
latency{quantile="0.999"} 0
latency{quantile="1"} 0
latency_sum 0
latency_count 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0.5"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0.9"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0.95"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0.99"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="0.999"} 0
latency{query="SHOW TABLES;",client_ip="172.17.0.1",quantile="1"} 0
latency_sum{query="SHOW TABLES;",client_ip="172.17.0.1"} 0.001482666
latency_count{query="SHOW TABLES;",client_ip="172.17.0.1"} 1
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0.5"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0.9"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0.95"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0.99"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="0.999"} 0
latency{query="SELECT DATABASE();",client_ip="172.17.0.1",quantile="1"} 0
latency_sum{query="SELECT DATABASE();",client_ip="172.17.0.1"} 0.000156075
latency_count{query="SELECT DATABASE();",client_ip="172.17.0.1"} 1
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0.5"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0.9"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0.95"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0.99"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="0.999"} 0
latency{query="SHOW databases;",client_ip="172.17.0.1",quantile="1"} 0
latency_sum{query="SHOW databases;",client_ip="172.17.0.1"} 0.000866705
latency_count{query="SHOW databases;",client_ip="172.17.0.1"} 1
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0.5"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0.9"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0.95"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0.99"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="0.999"} 0
latency{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1",quantile="1"} 0
latency_sum{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1"} 0.000189527
latency_count{query="SELECT @@version_comment LIMIT ?;",client_ip="172.17.0.1"} 1
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0"} 0.00022173
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0.5"} 0.00023113698075546773
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0.9"} 0.00023113698075546773
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0.95"} 0.00023113698075546773
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0.99"} 0.00023113698075546773
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="0.999"} 0.00023113698075546773
latency{query="SELECT * FROM users;",client_ip="172.17.0.1",quantile="1"} 0.000231499
latency_sum{query="SELECT * FROM users;",client_ip="172.17.0.1"} 0.002141375
latency_count{query="SELECT * FROM users;",client_ip="172.17.0.1"} 10
  1. Setup Prometheus & Grafana to visualize them image
Clone this wiki locally