In this article, you will learn about viewing the database statistics of an application such as active database connections, currently running database queries, and also the information about the top slow database queries. It is a good practice to monitor your server and application performance to avoid any unforeseen situation.
Visiting the Application Monitoring Section
The following steps will demonstrate how you can view the statistics mentioned above, so firstly we need to access the application monitoring section of the platform.
Log in to Cloudways Platform. Once logged in, navigate to the Servers tab from the top menu bar and choose your target server on which your desired application/website is deployed.
Next, click on the www icon located on the right-hand side of the server tab.
Select a target application from the drop-down list.
Click on the Monitoring option from the left menu bar, then click on Analytics and choose Database from the given choices.
Database Monitoring Section
This section displays the information about active database connections, currently running database queries, and top slow database queries, so you are aware of the database performance of an application.
Active Database Connections & Currently Running Database Queries
Click on the Summary tab, and now you will see information about the Active Database Connections and currently running database queries along with the Host, Command Type, Running Time (in seconds), and Query.
Top Slow Database Queries
Click on the Slow Queries tab and select time duration (e.g., one hour) to view the top slow database queries of your web application along with the execution time (in seconds). Any database query running for more than five seconds will be recorded in this section after successful execution.