TiDB Dashboard is a Web UI for monitoring, diagnosing, and managing the TiDB cluster, which is available since v4.0. It is built into the PD component and does not require an independent deployment.
TiDB Dashboard is open-sourced on GitHub.
This document introduces the main features of TiDB Dashboard. You can click links in the following sections to learn more details.
You can use TiDB Dashboard to learn the TiDB cluster's queries per second (QPS), execution time, the types of SQL statements that consume the most resources, and other overview information.
See TiDB Dashboard Overview for details.
You can use TiDB Dashboard to view the running status of TiDB, TiKV, PD, TiFlash components in the entire cluster and the running status of the host on which these components are located.
See TiDB Dashboard Cluster Information Page for details.
The Key Visualizer feature of TiDB Dashboard visually shows the change of read and write traffic over time in the entire cluster in the form of heatmap. You can use this feature to timely discover changes of application modes or locate hotspot issues with uneven performance.
See Key Visualizer Page for details.
The execution information of all SQL statements is listed on the SQL Statements page. You can use this page to learn the execution time and total executions at all stages, which helps you analyze and locate the SQL queries that consume the most resources and improve the overall cluster performance.
See SQL Statements Page of TiDB Dashboard for details.
The Slow Queries page of TiDB Dashboard shows a list of all SQL statements that take a long time to execute, including the SQL texts and execution information. This page helps you locate the cause of slow queries or performance jitter.
See Slow Queries Page for details.
The diagnostic feature of TiDB Dashboard automatically determines whether some common risks (such as inconsistent configurations) or problems exist in the cluster, generates reports, and gives operation suggestions, or compares the status of each cluster metric in different time ranges for you to analyze possible problems.
See TiDB Dashboard Cluster Diagnostics Page for details.
On the Search Logs page of TiDB Dashboard, you can quickly search logs of all running instances in the cluster by keywords, time range, and other conditions, package these logs, and download them to your local machine.
See Search Logs Page for details.
This is an advanced debugging feature that lets you profile each instance online and analyze various internal operations an instance performed during the profiling data collection period and the proportion of the operation execution time in this period without third-party tools.
See Profile Instances Page for details.
By default, TiDB Dashboard shares usage details with PingCAP to help understand how to improve the product. For details about what is shared and how to disable the sharing, see Telemetry.
- TiDB Dashboard Introduction
- Show the overall running status of the TiDB cluster
- Show the running status of components and hosts
- Show distribution and trends of read and write traffic
- Show a list of execution information of all SQL statements
- Learn the detailed execution information of slow queries
- Diagnose common cluster problems and generate reports
- Query logs of all components
- Collect profiling data for each instance