system.metrics
包含关于 度量事件 的信息。
SELECT * FROM system.metrics;
+--------------------------------------+---------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| metric | kind | labels | value |
+--------------------------------------+---------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| session_connect_numbers | counter | {"tenant":"","cluster_name":""} | 1.0 |
| interpreter_usedtime_sum | untyped | {} | 0.8492673029999999 |
| interpreter_usedtime_count | untyped | {} | 20.0 |
| mysql_process_request_duration_sum | untyped | {} | 0.968661883 |
| mysql_process_request_duration_count | untyped | {} | 18.0 |
| optimizer_optimize_usedtime_sum | untyped | {} | 0.018182794999999998 |
| optimizer_optimize_usedtime_count | untyped | {} | 18.0 |
| parser_parse_usedtime_sum | untyped | {} | 0.012580696000000002 |
| parser_parse_usedtime_count | untyped | {} | 28.0 |
| interpreter_usedtime | summary | {} | [{"quantile":0.0,"count":0.00084899},{"quantile":0.5,"count":0.0034856524910821664},{"quantile":0.9,"count":0.007957025569656927},{"quantile":0.95,"count":0.012534129195898459},{"quantile":0.99,"count":0.012534129195898459},{"quantile":0.999,"count":0.012534129195898459},{"quantile":1.0,"count":0.2071939412186652}] |
| parser_parse_usedtime | summary | {} | [{"quantile":0.0,"count":0.000084647},{"quantile":0.5,"count":0.00035389863363880604},{"quantile":0.9,"count":0.0007507033214071675},{"quantile":0.95,"count":0.0007754244284730125},{"quantile":0.99,"count":0.0008191035653466911},{"quantile":0.999,"count":0.0008191035653466911},{"quantile":1.0,"count":0.0011012603000499356}] |
| mysql_process_request_duration | summary | {} | [{"quantile":0.0,"count":0.007505268},{"quantile":0.5,"count":0.0120836736849045},{"quantile":0.9,"count":0.015794397051616272},{"quantile":0.95,"count":0.01716470533994825},{"quantile":0.99,"count":0.01716470533994825},{"quantile":0.999,"count":0.01716470533994825},{"quantile":1.0,"count":0.21222674793285548}] |
| optimizer_optimize_usedtime | summary | {} | [{"quantile":0.0,"count":0.000398654},{"quantile":0.5,"count":0.0008709726097674335},{"quantile":0.9,"count":0.0013493935265982112},{"quantile":0.95,"count":0.0014431890055320044},{"quantile":0.99,"count":0.0014431890055320044},{"quantile":0.999,"count":0.0014431890055320044},{"quantile":1.0,"count":0.0015506206225213148}] |
+--------------------------------------+---------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+