Database¶
The Database module presents infrastructure database data from the various database types supported by DataKit collection. Through a centralized Explorer and query analysis capabilities, you can monitor key metrics of databases such as MySQL, PostgreSQL, Oracle, SQL Server, and MongoDB in real time, including version, uptime, load trends, and blocking rates, and support cross-instance normalized SQL performance analysis and execution plan viewing.
Note
DataKit collectors have been updated. 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 | Purpose | Use Cases |
|---|---|---|
| Explorer | Per-instance | View the running status list of all database instances; click an instance to view its details and analyze the overview, queries, sessions, metrics, logs, table structures, and more. |
| Query Analysis | Cross-instance normalized aggregation | Aggregate performance data of the same business SQL across multiple instances, analyze the database execution method with collected execution plans, and locate slow query bottlenecks from a global perspective. |
Data Range¶
The currently supported database types include:
- MySQL
- PostgreSQL
- Oracle
- SQL Server
- MongoDB
- Redis (Explorer only)
Among them, execution plans currently support MySQL, PostgreSQL, Oracle, and SQL Server.