Templates: Database Servers – MySQL 5.1.X – 5.6.X Database Server

Monitors included into Database Servers – MySQL 5.[1-6].X Database Server template

The monitors from this application template check availability, traffic and performance data for a MySQL 5.1.12-5.6.X Database Server. MySQL is an open-source relational database management system (RDBMS). MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other “AMP” stacks). More about templates.

Monitors list

Monitors description

MySQL daemon process count (enabled by default) MySQL daemon process count. Disable this monitor on Windows host.

MySQL TCP port (enabled by default) Shows if the server answers on specified port. Default is 3306.

Test SQL query (enabled by default) DB sanity test: record count. You can replace this sample query with any suitable query that can indicate the database health.

MySQL Server version check Checks if this template is suitable for the host. Disabled by default. This is a match monitor and used only in network discovery. You don’t need to enable it, since is does not check any valuable characteristic. Uses SQL query to check MySQL server version.

Free memory in query cache, MB Free memory in query cache, MB. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’. The MySQL query cache is a vital part of query optimization and can cause significant performance improvements – or a slowdown – of your workload.

Kilobytes received Total kilobytes received. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’.

Kilobytes sent Total kilobytes sent. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’.

MySQL daemon process count over SNMP MySQL daemon process count, collects data over SNMP. Disable this monitor on Windows host.

MySQL service process count MySQL service process count. Enable this monitor on Windows host.

Opened connections Opened connections count.

Opened tables Opened tables count. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’. The number of tables that have been opened. If this counter is big, your table_open_cache value is probably too small.

Slow queries Slow queries count. Requires ‘SELECT’ privilege for ‘performance_schema.global_status’. The number of queries that have taken more than long_query_time seconds. This counter increments regardless of whether the slow query log is enabled.

Threads running The number of threads that are not sleeping. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’.

Total memory used, MB Total memory used, MB. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.SESSION_VARIABLES’.

Transactions that use disk Transactions that use disk. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’. The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction.

Uptime, days MySQL server uptime in days. Requires ‘SELECT’ privilege for ‘INFORMATION_SCHEMA.GLOBAL_STATUS’.

Templates overview

IPHost Network Monitor provides application templates (or just “templates” later in document), to create multiple relevant monitors in only a few clicks. Templates facilitate adding typical monitors sets; this can be particularly useful in case of big networks, when creating same-type monitors for many same-type devices is a common task. Application templates are sets of monitors that can be added, using specific predefined parameters, for a given host at once. The said set, added for given host, is displayed as a separate node in tree view pane, and is named application.

There are predefined templates; user can as well generate templates of their own – either out of existing monitors, or by cloning a predefined template. User-added template definitions are saved in XML files and can thus be conveniently augmented or applied to specific needs.