What is MySQL Database?
MySQL is an Open Source relational database management system (RDBMS). It is distributed under a dual GPL and proprietary license by Oracle. MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. System MySQL/MariaDB is a central component of the LAMP stack (and other XAMP stacks). It is used in numerous Open Source projects and common web application frameworks such as Joomla, WordPress, or Drupal...
This package monitors a MySQL/MariaDB Database. It automatically configures the ServicePilot Agent in order to monitor a MySQL/MariaDB Database by using SQL requests.
Applying a ServicePilot package in the web interface automatically detects and monitors your MySQL/MariaDB databases to show you detailed usage metrics for operational performance improvement.
The statistics gathered in this way allow system and instances monitoring with more than 25 key indicators. ServicePilot will display built-in dashboards with your essential MySQL indicators, such as response times, failure rates, and database-activity breakdowns for MySQL/MariaDB databases.
This package ensures consistent performance metric collection and database connection sizing monitoring across different MySQL versions:
- MySQL 5.7 Qcache_xxx
- MySQL 8.0 Connection_errors_xxx
ServicePilot allows you to build a complete and unified MySQL/MariaDB database performance checklist. Using additional ServicePilot packages to monitor your application and database environment, you can:
- Ensure your system and OS works fine with server data
- Verify your virtualization health with virtual machine metrics
- Tune and monitor database access by searching application data
- Analyze the network impact of database communication by looking at network data
Having a full-stack visibility over MySQL/MariaDB metrics is vital to know how and what caused MySQL/MariaDB performance degradation.
MySQL/MariaDB processes rely heavily on host and server performance. MySQL/MariaDB will deliver better performance on faster CPUs. In a VMWare environment, CPU Ready time can affect server performance, thus MySQL/MariaDB database performances and consequently, the dependant applications. A very high number of page faults per second can indicate that your hosts are out of memory. Host disk space available metrics can also be critical in MySQL/MariaDB performance monitoring.