MySQL Database Monitoring

Login to Applicare controller and navigate to the Server Analyzer menu to view the details.

Dashboard

Database performance metrics assist in monitoring and optimizing your database for business needs. These metrics are calculated for the entire server and are not limited to the specific database indicated in the JDBC URL.

Screenshot 1 — MySQL Database Monitoring

SQL

SQL Statement Profiling shows the performance details of your database queries.It helps you identify which statement are slow, making it easier to diagnose and fix performance issues or SQL/s. You'll get detailed stats, including the database name, query count, average time and various percentile.

Screenshot 2 — MySQL Database Monitoring

OS

This view offers a quick and easy overview of your physical server's/VM's performance including metrics such as the number of processes, context switches, CPU Usage, memory, storage performance and etc.

Screenshot 3 — MySQL Database Monitoring

CPU CORE Analyzer

This view offers an overview of the overall CPU performance along with detailed information for each individual CPU core.

Screenshot 4 — MySQL Database Monitoring

Processes

This view presents organized performance stats for CPU, memory and running processes. It includes historical snapshots of processes at specific times, showing the resources they were consuming. By default, Applicare takes these snapshot in every 10 minutes, but you can adjust the interval as needed.

Screenshot 5 — MySQL Database Monitoring

Disk

This view shows the disk usage for each process, detailing how much disk space each one is accessing.

Screenshot 6 — MySQL Database Monitoring

Network Connections

This view provides details on TCP, UDP, RAW, and UNIX connections.

Screenshot 7 — MySQL Database Monitoring

SQL Report

To download a report of SQL statements, click the print icon on the SQL screen within the server Analyzer menu.

Screenshot 8 — MySQL Database Monitoring

Screenshot 9 — MySQL Database Monitoring

Screenshot 10 — MySQL Database Monitoring

Configuration

MySQL database monitoring configuration

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Opens Zendesk · needs internet and sign-in

Still stuck? Contact support