ProxySQL インテグレーションのメトリクス
ProxySQL の監視に使う Datadog の公式インテグレーションです。収集するメトリクスは 75 件あります。
公式の紹介文 (英語)
Collect your ProxySQL metrics and logs.
種別の内訳
- gauge (その時点の値): 62 件
- count (集計間隔内の発生回数): 13 件
メトリクスの一覧
説明は公式の定義の英文をそのまま載せています。
| メトリクス | 種別 | 単位 |
|---|---|---|
proxysql.The number of client connections currently processing a transaction. | gauge | transaction |
proxysql.The number of all MySQL servers, including whether they are online or not. | gauge | node |
proxysql.Time spent (as a percentage of total time) making network calls to communicate with the backends. | gauge | percent |
proxysql.Number of mysql servers connected. | gauge | node |
proxysql.Client failed or improperly closed connections per second. | gauge | connection/ |
proxysql.Client connections that are currently connected. | gauge | connection |
proxysql.The number of client connections created per second. | gauge | connection/ |
proxysql.The number of client connections that are currently handled by the main worker threads. | gauge | connection |
proxysql.The number of prepared statements that are in use by clients. | gauge | unit |
proxysql.The number of unique prepared statements currently in use by clients. | gauge | unit |
proxysql.Current number of frontend connections by user. | gauge | connection |
proxysql.Max number of frontend connections the user can create (as defined in mysql_users.max_connections). | gauge | connection |
proxysql.Memory used by the authentication module to store user credentials and attributes. | gauge | byte |
proxysql.Bytes in pages allocated by the application. | gauge | byte |
proxysql.Bytes allocated by the application. | gauge | byte |
proxysql.Bytes in extents mapped by the allocator. | gauge | byte |
proxysql.Bytes dedicated to metadata. | gauge | byte |
proxysql.Bytes in physically resident data pages mapped by the allocator. | gauge | byte |
proxysql.Bytes allocated by the application. | gauge | byte |
proxysql.Memory used to store data related to stats_mysql_query_digest. | gauge | byte |
proxysql.Memory used by the embedded SQLite. | gauge | byte |
proxysql.Memory used by the stack of the admin threads. | gauge | byte |
proxysql.Memory used by the stack of the cluster threads. | gauge | byte |
proxysql.Memory used by the stack of the MySQL threads. | gauge | byte |
proxysql.Memory use of buffers related to backend connections. | gauge | byte |
proxysql.Memory use of buffers related to frontend connections (read/write buffers and other queues). | gauge | byte |
proxysql.The number of monitor threads. | gauge | worker |
proxysql.Other memory used by ProxySQL to handle MySQL Sessions. | gauge | byte |
proxysql.The number of MySQL Thread workers i.e. 'mysql-threads'. | gauge | worker |
proxysql.The number of commands of a type which executed within 100 milliseconds., but more than 50 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 100 microseconds. | count | command |
proxysql.The number of commands of a type which executed within 10 milliseconds., but more than 5 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 10 seconds., but more than 5 seconds | count | command |
proxysql.The number of commands of a type which executed within 1 milliseconds., but more than 500 microseconds | count | command |
proxysql.The number of commands of a type which executed within 1 second., but more than 500 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 500 milliseconds., but more than 100 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 500 microseconds., but more than 100 microseconds | count | command |
proxysql.The number of commands of a type which executed within 50 milliseconds., but more than 10 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 5 milliseconds., but more than 1 milliseconds | count | command |
proxysql.The number of commands of a type which executed within 5 seconds., but more than 1 second | count | command |
proxysql.The number of commands whose execution exceeded 10 seconds. | count | command |
proxysql.The number of commands of a type executed. | count | command |
proxysql.Total time spent executing commands of a type as a percentage of total time. | gauge | percent |
proxysql.The amount of data received from the backend. | gauge | byte/ |
proxysql.The amount of data sent to the backend. | gauge | byte/ |
proxysql.The number of requests per second where a connection was not available in the connection pool and either: a new connection had to be created or no backend was available. | gauge | connection/ |
proxysql.The number of connections per second that a MySQL Thread obtained from its own local connection pool cache. | gauge | connection/ |
proxysql.The number of requests per second where a connection was already available in the connection pool. | gauge | connection/ |
proxysql.How many connections aren't established successfully. | gauge | connection/ |
proxysql.How many connections are currently free. They are kept open in order to minimize the time cost of sending a query to the backend server. | gauge | connection |
proxysql.How many connections are established successfully. | gauge | connection/ |
proxysql.How many connections are currently used by ProxySQL for sending queries to the backend server. | gauge | connection |
proxysql.The current ping time as reported from Monitor. | gauge | millisecond |
proxysql.The current ping time as reported from Monitor. | gauge | microsecond |
proxysql.Memory used by the connection pool to store connections metadata. | gauge | byte |
proxysql.The number of queries routed towards this particular backend server. | gauge | query/ |
proxysql.The number of bytes per second sent into the Query Cache. | gauge | byte/ |
proxysql.The number of bytes per second read from the Query Cache. | gauge | byte/ |
proxysql.The number of entries currently stored in the query cache. | gauge | entry |
proxysql.The number of read requests per second to the Query Cache. | gauge | query/ |
proxysql.The number of successful read requests per second to the Query Cache. | gauge | query/ |
proxysql.Memory usage of the query cache. | gauge | byte |
proxysql.The number of entries purged per second by the Query Cache due to TTL expiration. | gauge | entry/ |
proxysql.The number of write requests per second to the Query Cache. | gauge | query/ |
proxysql.The time (as a percentage of total time) spent inside the query processor determining the action to take with the query (internal module). | gauge | percent |
proxysql.The number of times query rules matched traffic. | gauge | hit/ |
proxysql.The number of client requests / statements executed per second. | gauge | question/ |
proxysql.Backend failed or improperly closed connections per second. | gauge | connection/ |
proxysql.Backend connections that are currently connected. | gauge | connection |
proxysql.The number of backend connections created per second. | gauge | connection/ |
proxysql.The number of prepared statements currently available across all backend connections. | gauge | unit |
proxysql.The number of unique prepared statements currently available across all backend connections. | gauge | unit |
proxysql.The number of queries per second with an execution time greater than 'mysql-long_query_time' milliseconds. | gauge | query/ |
proxysql.The number of global prepared statements for which proxysql has metadata. | gauge | unit |
proxysql.The total uptime of ProxySQL in seconds. | gauge | second |
公式ドキュメント
メトリクスの名前と説明は Datadog の公式インテグレーションの定義 (Copyright Datadog, Inc.・BSD-3-Clause) を英文のまま載せています。利用条件の全文は サイトについてにあります。