Database¶
The Database section displays various infrastructure database data that DataKit supports collecting. Through a centralized Explorer and new Query Analysis capabilities, you can monitor key metrics of databases such as MySQL, PostgreSQL, Oracle, and SQL Server in real time, including version, uptime, load trends, blocking rate, etc., and support cross-instance SQL performance normalization analysis.
Note
The DataKit collector has been updated. Please contact your administrator to upgrade the version to enable the new database monitoring experience.
Entry Points¶
The Database module provides two core analysis entry points for different troubleshooting scenarios:
| Entry Point | Purpose | Use Case |
|---|---|---|
| Explorer | Single-instance perspective | View the running status list of all database instances; click an instance to enter its details, analyze its overview, queries, sessions, metrics, logs, table structure, etc. |
| Query Analysis | Cross-instance normalized aggregation | Aggregate performance data of the same business SQL across multiple instances, identifying system-level slow query bottlenecks from a global perspective. |
Data Scope¶
Currently supported database types include:
- MySQL
- PostgreSQL
- Oracle
- SQL Server
- Redis (Explorer only)
Query Analysis Support Scope
Query Analysis currently supports four relational databases: MySQL, PostgreSQL, Oracle, and SQL Server. Other database types are not included in cross-instance query aggregation.