points Highly dynamic, built-in service discovery No hierarchical model, n-dimensional label set PromQL: for processing, graphing, alerting, and export Simple operation Highly efficient Richard Hartmann Prometheus Deep Dive Introduction Intro 2.0 to 2.2.1 2.4 - 2.6 Beyond Outro PromQL Quick is not quick enough Brian Brazil optimized PromQL 5x faster for time vector functions 100x reduction in garbage to collect

points Highly dynamic, built-in service discovery No hierarchical model, n-dimensional label set PromQL: for processing, graphing, alerting, and export Simple operation Highly efficient Richard Hartmann @TwitchiH & @fredbrancz Intro to Prometheus Introduction Background Operations & observability Outro PromQL vs SQL avg by(city) (temperature_celsius{country=" germany" }) SELECT city, AVG(value) FROM temperature_celsius

Description METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . SEQUENCES The TiDB implemen- tation of sequences is cause many Coprocessor requests. 12.11.14.2.25 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the metrics_schema database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

Description METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . PLACEMENT_RULES Provides information on all objects cause many Coprocessor requests. 12.11.17.2.25 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the metrics_schema database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

Description METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . SEQUENCES The TiDB implemen- tation of sequences is cause many Coprocessor requests. 12.11.14.2.25 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the metrics_schema database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

• 分布式，高可用 • 高性能，低延迟 • 线性扩容 海尔工业互联网 –微服务之监控日志 Node PrometheusServer（Pod） Retrieval Storage PromQL Local Storage Web UI（Pod） Grafana（Pod） API Push Gateway Jobs / Exporters Prometheus Server

to TiDB Cloud. METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . This table is not applicable to TiDB Cloud. PLACEMENT_RULES cause many Coprocessor requests. 12.11.17.2.25 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the metrics_schema database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

Description METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . This table is not applicable to TiDB Cloud. PLACEMENT_POLICIES cause many Coprocessor requests. 14.11.17.2.25 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the metrics_schema database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

from Prometheus. METRICS_SUMMARY_BY_LABEL See METRICS_SUMMARY �→ table. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . PLACEMENT_POLICIES Provides information on all placement cause many Coprocessor requests. 14.11.17.2.27 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the METRICS_SCHEMA database. USE +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double

METRICS_SUMMARY �→ table. This table is not applicable to TiDB Cloud. METRICS_TABLES Provides the PromQL definitions for tables in METRICS_SCHEMA �→ . This table is not applicable to TiDB Cloud. PLACEMENT_POLICIES cause many Coprocessor requests. 14.11.18.2.27 METRICS_TABLES The METRICS_TABLES table provides the PromQL (Prometheus Query Language) defini- tion for each of the views in the METRICS_SCHEMA database. Note: +------------+--------------+------+------+---------+-------+ | TABLE_NAME | varchar(64) | YES | | NULL | | | PROMQL | varchar(64) | YES | | NULL | | | LABELS | varchar(64) | YES | | NULL | | | QUANTILE | double