Database metrics
Insights into the size and health of an environment’s database can be reviewed the Insights & Metrics panel, located in the application view of the VIP Dashboard.
Select the tab labeled “Database” to access metrics that indicate the efficiency of the queries made by application code to an environment’s database.
Database metrics are only displayed for WordPress applications and for qualifying Node.js applications.
Database Queries by Type
The data in “Database Queries by Type” represents the rate of change in the number of database queries that are made by the PHP application. High query counts can indicate inefficient queries or a high number of requests being made to the application.
Database Slow Queries
The data in “Database Slow Queries” represents the rate of change in the number of database queries that require more than 750 ms to complete. Spikes (or high readings) can indicate inefficient queries or a high number of requests being made to the application.
Underlying causes for slow queries might not be immediately apparent, and more in-depth debugging may be needed. To investigate a slow query:
- Refer to the Slow Query Logs panel in the VIP Dashboard to review the most recent slow queries that have occurred on an environment.
- Stack traces for the provided Request URL value of a slow query can be reviewed by viewing the URL in a browser window with Query Monitor enabled. The Queries panel available in Query Monitor can provide detailed information about the Query, Caller, and Time elapsed for execution for each SQL query sent to the database by the current page.
Database Size
The value displayed in this tab represents the total size on disk of an environment’s database tables. This value does not include Elasticsearch indexes or binlogs (which are used for replication).
Larger database sizes can cause database sync and database backup processes to require a longer amount of time to complete.
Last updated: April 19, 2024