TiDB Monitoring API

You can use the following types of interfaces to monitor the TiDB cluster status:

• The status interface: this interface uses the HTTP interface to get the component information. Using this interface, you can get therunning statusof the current TiDB server and thestorage informationof a table.
• The metrics interface: this interface uses Prometheus to record the detailed information of the various operations in components and views these metrics using Grafana.

使用状态接口

The status interface monitors the basic information of a specific component in the TiDB cluster. It can also act as the monitor interface for Keepalive messages. In addition, the status interface for the Placement Driver (PD) can get the details of the entire TiKV cluster.

TiDB server

• TiDB API address:http://${host}:${port}
• Default port:10080

Running status

The following example useshttp://${host}:${port}/statusto get the current status of the TiDB server and to determine whether the server is alive. The result is returned inJSONformat.

              

               curl http://127.0.0.1:10080/status { connections: 0,# The current number of clients connected to the TiDB server.version:"5.7.25-TiDB-v7.1.1",# The TiDB version number.git_hash:"778c3f4a5a716880bcd1d71b257c8165685f0d70"
               # The Git Hash of the current TiDB code.}

               
               

Storage information

The following example useshttp://${host}:${port}/schema_storage/${db}/${table}to get the storage information of the specific data table. The result is returned inJSONformat.

              

               curl http://127.0.0.1:10080/schema_storage/mysql/stats_histograms

               
               

              

               { "table_schema": "mysql", "table_name": "stats_histograms", "table_rows": 0, "avg_row_length": 0, "data_length": 0, "max_data_length": 0, "index_length": 0, "data_free": 0 }

               
               

              

               curl http://127.0.0.1:10080/schema_storage/test

               
               

              

               [ { "table_schema": "test", "table_name": "test", "table_rows": 0, "avg_row_length": 0, "data_length": 0, "max_data_length": 0, "index_length": 0, "data_free": 0 } ]

               
               

PD server

• PD API address:http://${host}:${port}/pd/api/v1/${api_name}
• Default port:2379
• Details about API names: seePD API doc

The PD interface provides the status of all the TiKV servers and the information about load balancing. See the following example for the information about a single-node TiKV cluster:

              

               curl http://127.0.0.1:2379/pd/api/v1/stores {"count": 1,# The number of TiKV nodes.
               "stores": [# The list of TiKV nodes.
               # The details about the single TiKV node.{"store": {"id": 1,"address":"127.0.0.1:20160","version":"3.0.0-beta","state_name":"Up"},"status": {"capacity":"20 GiB",# The total capacity.
               "available":"16 GiB",# The available capacity.
               "leader_count": 17,"leader_weight": 1,"leader_score": 17,"leader_size": 17,”地区_count": 17,”地区_weight": 1,”地区_score": 17,”地区_size": 17,"start_ts":"2019-03-21T14:09:32+08:00",# The starting timestamp.
               "last_heartbeat_ts":"2019-03-21T14:14:22.961171958+08:00",# The timestamp of the last heartbeat.
               "uptime":"4m50.961171958s"} } ]

               
               

Use the metrics interface

The metrics interface monitors the status and performance of the entire TiDB cluster.

• If you use other deployment ways,deploy Prometheus and Grafanabefore using this interface.

After Prometheus and Grafana are successfully deployed,configure Grafana.