MySQLd process alert
Job details
| Name: | MySQLd process alert |
| Platform: | Mysql |
| Category: | Availability |
| Description: | Collects uptime statistics for the MySQL instance. |
| Long description: | |
| Version: | 1 |
| Default schedule: | 15m |
| Requires engine install: | No |
| Compatibility tag: | .[type=‘instance’ & is_mysql_branch=‘1′] |
Parameters
| Name | Default value | Description |
|---|---|---|
| processname | mysqld | Short name for the process name we are looking for. Usually the name of the executable, such as mysqld, crond or sshd |
Job Summary
- Purpose: This monitoring job is designed specifically for MySQL to ensure the mysqld (MySQL daemon) process is running.
- Why: When the mysqld process isn’t running, the MySQL server won’t be able to provide service. Hence, periodically checking its status is important to spot and solve potential problems early, and thus ensuring the availability of services.
- Manual checking: In MySQL, you can manually check if the MySQL service is running by using the SHOW PROCESSLIST command.
- Additional Information: The function uses a 15-minute default schedule between checks to monitor the status of the mysqld process.
Company Information
This job monitoring function was made by dbwatch.com. It is a version 1 artifact corresponding to the group com.dbwatch.job and has the artifact ID mysql_noschema_mysqld_process.
Job Details
This function is coded primarily in javascript and dbsql. It extracts information including the process list of the operational MySQL instance, and any related data such as process ID, usage in processor and memory, and the complete operational command.
It counts the number of operational instances and sets the status to 0 if mysqld process is found, and provides detailed information including the ID numbers, owner, and original command. In contrast, when the mysqld process is not found, it sets the status to 2 and sends out an alert that the process is not running, appending this with the number of processed checks conducted.
Compatibility
This monitoring function is compatible with MySQL branch instances. The compatability is defined by MySQL instances present on the server hostname.