Verax NMS MySQL management plugin enables easy monitoring, alerting, health check, management and performance reporting for MySQL servers and databases. The plugin uses SQL queries in order to communicate with server instances and supports MySQL version 5.1.12 and higher (a limited functionality is available for versions 4.x as they do not support INFORMATION_SCHEMA).
The MySQL management plugin provides complete configuration and runtime about MySQL servers including:
The view lists all databases (schemas) on a MySQL server with the following details:
The MySQL management plugin enables administrators to automatically scan for and fix corrupt MySQL tables using the NMS "List corrupt tables" and "Repair corrupt table" actions.
The plugin provides predefined templates for most commonly monitored MySQL items (listed in the table below). Other, user-defined sensors and performance counters can be added.
|MySQL monitoring templates|
|MySQL Select full range join|
|MySQL Select full join|
|MySQL Threads running|
|MySQL Bytes sent|
|MySQL Bytes received|
|MySQL Select range check|
|MySQL Slow queries|
|MySQL Query cache free memory|
|MySQL Threads created|