MySQL monitoring and management plugin

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).

General information

Verax NMS: MySQL monitoring

The MySQL management plugin provides complete configuration and runtime about MySQL servers including:

  • Configuration: software version and host platform.
  • Server status view providing a detailed MySQL server status variables list (e.g. Aborted_clients, Bytes_sent, Uptime_since_flush_status and others) with their current values.
  • System variables view providing a detailed MySQL server system configuration variables list (e.g. auto_increment_increment,basedir, wait_timeout and others) with their current values.

Database instances view

The view lists all databases (schemas) on a MySQL server with the following details:

  • Table name
  • Engine (e.g. MEMORY, MyISAM)
  • Row count, index and data sizes for the table
  • Table creation time
  • Table update time

Finding and fixing corrupt tables

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.

Predefined MySQL monitoring templates

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 Questions
MySQL Queries
MySQL Threads running
MySQL Connections
MySQL Bytes sent
MySQL Bytes received
MySQL Select range check
MySQL Slow queries
MySQL Query cache free memory
MySQL Threads created

See also

Oracle RDBMS management plugin »

Microsoft SQL Server management plugin »

IBM DB2 management plugin »

PostgreSQL management plugin »