What are Grafana and Dashboards used for?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: Grafana和Dashboard都用来做什么

| username: wangccsy

Grafana and Dashboard in TiDB are mainly used for what purposes?

| username: zhanggame1 | Original post link

Grafana and Dashboard are both monitoring tools.
Dashboard is a built-in monitoring tool of the PD component, with fewer monitoring metrics compared to Grafana, but it includes features like heatmaps, slow query, and log query.
Grafana is a monitoring tool built using open-source software Prometheus and Grafana, with more monitoring metrics.

| username: 春风十里 | Original post link

It should be said that the focus of the two types of monitoring is different. Grafana collects data for displaying monitoring content, and there is a lot of content being monitored here, such as the latency and usage of each functional component like TiKV, TiDB, and TiFlash. On the Dashboard, I pay attention to TOP SQL, slow queries, and SQL execution plan information.

| username: 小龙虾爱大龙虾 | Original post link

Used for analyzing problems :joy_cat:

| username: wangccsy | Original post link

Just getting started, there are too many tools. For example, for the client, you can use Tiup client or mysql.

| username: 小龙虾爱大龙虾 | Original post link

Well, using the MySQL client for the client is fine, the one in tiup is not good to use.

| username: andone | Original post link

They are all tools used for problem analysis.

| username: Kongdom | Original post link

Grafana is an open-source metric analysis and visualization system. TiDB uses Grafana to display monitoring information related to various components of the TiDB cluster.

TiDB Dashboard is a graphical interface provided by TiDB starting from version 4.0, which can be used to monitor and diagnose the TiDB cluster. TiDB Dashboard is built into TiDB’s PD component and does not require separate deployment.

| username: dba远航 | Original post link

Monitoring and Analysis

| username: 烂番薯0 | Original post link

Monitoring