A division of VMware
Spring Source - Hyperic | Build, Run, Manage
REQUEST A QUOTE  |  FORUMS  |  BLOG  |      CONTACT US

MySQL Monitoring & Management

MySQL is the most popular open source relational database system. Its performance and ease of use make it one of the central pillars of what is known as the LAMP stack.

Hyperic HQ's comprehensive support for open source technologies means you can easily manage MySQL as well as the rest of your LAMP stack through the HQ interface. This level of visibility is driven by the vast amount of metrics exposed by MySQL for both its database engine as well as each individual table.

Additionally, HQ's control capabilities for MySQL facilitate automated and on demand management tasks which will help maintain your MySQL database running at its highest levels of performance.

Hyperic HQ aims to provide MySQL users the management capabilities typically found in database centric tools coupled with management support for the other technologies which, along with databases, are used in today's enterprise environment.

Its powerful application concept allows you to visualize monitoring data from your database tier alongside your business logic and presentation tiers by giving you the ability to measure how client activity is reflected across the various layers of your application infrastructure.

For more information, please visit our MySQL monitoring plugin HyperFORGE page.

Auto-Discover your hardware and MySQL servers
Monitor every metric, log, and configuration for all MySQL resources in your inventory
Identify problem resources with automatic baselines for every metric
Control all your MySQL resources on-demand, on schedule, or in response to alerts
Alert on any measurement, log, or security event in your MySQL environment

System Supported Versions

  • MySQL Process 3.x
  • MySQL 3.x
  • MySQL Process 4.x
  • MySQL 4.x
  • MySQL Process 5.x
  • MySQL 5.x

System Monitoring Specification

General Server Metrics
  • Availability
  • Number Of Databases
  • Virtual Memory Size
  • Memory Size
  • Cpu System Time
  • Cpu System Time per Minute
  • Cpu User Time
  • Cpu User Time per Minute
  • Cpu Total Time
  • Cpu Total Time per Minute
  • Cpu Usage
  • Open File Descriptors
Reliability Metrics
  • Availability
  • Up Time
Tx Command Metrics
  • Number of begin commands
  • Number of begin commands per Minute
  • Number of commit commands
  • Number of commit commands per Minute
  • Number of lock tables commands
  • Number of lock tables commands per Minute
  • Number of rollback commands
  • Number of rollback commands per Minute
  • Number of unlock table commands
  • Number of unlock table commands per Minute
Connection Metrics
  • Aborted Clients
  • Aborted Clients per Minute
  • Aborted Connects
  • Aborted Connects per Minute
  • Bytes Received
  • Bytes Received per Minute
  • Bytes Sent
  • Bytes Sent per Minute
  • Connections
  • Connections per Minute
  • Max Used Connections
  • Max Used Connections per Minute
  • Questions
  • Questions per Minute
DDL Command Metrics
  • Number of alter table commands
  • Number of alter table commands per Minute
  • Number of create function commands
  • Number of create function commands per Minute
  • Number of create index commands
  • Number of create index commands per Minute
  • Number of create table commands
  • Number of create table commands per Minute
  • Number of drop function commands
  • Number of drop function commands per Minute
  • Number of drop index commands
  • Number of drop index commands per Minute
  • Number of drop table commands
  • Number of drop table commands per Minute
  • Number of rename table commands
  • Number of rename table commands per Minute
General Command Metrics
  • Number of select commands
  • Number of select commands per Minute
  • Number of set option commands
  • Number of set option commands per Minute
  • Number of slave start commands
  • Number of slave start commands per Minute
  • Number of slave stop commands
  • Number of slave stop commands per Minute
  • Number of delete multi commands
  • Number of delete multi commands per Minute
  • Number of ha close commands
  • Number of ha close commands per Minute
  • Number of ha open commands
  • Number of ha open commands per Minute
  • Number of ha read commands
  • Number of ha read commands per Minute
  • Number of load master data commands
  • Number of load master data commands per Minute
Resource Utilization Metrics
  • Data Length
  • Index Length
  • Total Rows
  • Delayed Insert Threads
  • Delayed Insert Threads per Minute
  • Open Tables
  • Open Files
  • Open Streams
  • Opened Tables
  • Opened Tables per Minute
  • Select Full Join
  • Select Full Join per Minute
  • Slow Launch Threads
  • Slow Launch Threads per Minute
  • Threads Cached
  • Threads Cached per Minute
  • Threads Created
  • Threads Created per Minute
  • Threads Connected
  • Threads Running
  • Threads Running per Minute
DML Command Metrics
  • Number of delete commands
  • Number of delete commands per Minute
  • Number of insert commands
  • Number of insert commands per Minute
  • Number of insert select commands
  • Number of insert select commands per Minute
  • Number of load commands
  • Number of load commands per Minute
  • Number of load master table commands
  • Number of load master table commands per Minute
  • Number of purge commands
  • Number of purge commands per Minute
  • Number of replace commands
  • Number of replace commands per Minute
  • Number of replace select commands
  • Number of replace select commands per Minute
  • Number of restore table commands
  • Number of restore table commands per Minute
  • Number of truncate commands
  • Number of truncate commands per Minute
  • Number of update commands
  • Number of update commands per Minute
Query/Runtime Metrics
  • Temporary Disk Tables Created
  • Temporary Disk Tables Created per Minute
  • Temporary Memory Tables Created
  • Temporary Memory Tables Created per Minute
  • Temporary Files Created
  • Temporary Files Created per Minute
  • Select Full Range Join
  • Select Full Range Join per Minute
  • Select Range
  • Select Range per Minute
  • Select Range Check
  • Select Range Check per Minute
  • Select Scan
  • Select Scan per Minute
  • Slave Open Temp Tables
  • Slave Open Temp Tables per Minute
  • Slow Queries
  • Slow Queries per Minute
  • Sort Merge Passes
  • Sort Merge Passes per Minute
  • Sort Range
  • Sort Range per Minute
  • Sort Rows
  • Sort Rows per Minute
  • Table Locks Immediate
  • Table Locks Immediate per Minute
  • Table Locks Waited
  • Table Locks Waited per Minute
DBA Command Metrics
  • Number of admin commands
  • Number of admin commands per Minute
  • Number of analyze commands
  • Number of analyze commands per Minute
  • Number of backup table commands
  • Number of backup table commands per Minute
  • Number of change db commands
  • Number of change db commands per Minute
  • Number of change master commands
  • Number of change master commands per Minute
  • Number of check commands
  • Number of check commands per Minute
  • Number of create db commands
  • Number of create db commands per Minute
  • Number of drop db commands
  • Number of drop db commands per Minute
  • Number of flush commands
  • Number of flush commands per Minute
  • Number of grant commands
  • Number of grant commands per Minute
  • Number of kill commands
  • Number of kill commands per Minute
  • Number of optimize commands
  • Number of optimize commands per Minute
  • Number of repair commands
  • Number of repair commands per Minute
  • Number of reset commands
  • Number of reset commands per Minute
  • Number of revoke commands
  • Number of revoke commands per Minute
Show Command Metrics
  • Number of show binlogs commands
  • Number of show binlogs commands per Minute
  • Number of show databases commands
  • Number of show databases commands per Minute
  • Number of show fields commands
  • Number of show fields commands per Minute
  • Number of show grants commands
  • Number of show grants commands per Minute
  • Number of show keys commands
  • Number of show keys commands per Minute
  • Number of show logs commands
  • Number of show logs commands per Minute
  • Number of show master status commands
  • Number of show master status commands per Minute
  • Number of show open tables commands
  • Number of show open tables commands per Minute
  • Number of show processlist commands
  • Number of show processlist commands per Minute
  • Number of show slave status commands
  • Number of show slave status commands per Minute
  • Number of show status commands
  • Number of show status commands per Minute
  • Number of show innodb status commands
  • Number of show innodb status commands per Minute
  • Number of show tables commands
  • Number of show tables commands per Minute
  • Number of show variables commands
  • Number of show variables commands per Minute
  • Number of show binlog events commands
  • Number of show binlog events commands per Minute
  • Number of show new master commands
  • Number of show new master commands per Minute
  • Number of show slave hosts commands
  • Number of show slave hosts commands per Minute
I/O Metrics
  • Delayed Writes
  • Delayed Writes per Minute
  • Delayed Errors
  • Delayed Errors per Minute
  • Flush Commands
  • Flush Commands per Minute
  • Number of Rows Deleted
  • Number of Rows Deleted per Minute
  • Number of Rows Read from First Index
  • Number of Rows Read from First Index per Minute
  • Number of Rows Read from Key
  • Number of Rows Read from Key per Minute
  • Number of Next Rows Read in Key Order
  • Number of Next Rows Read in Key Order per Minute
  • Number of Prev Rows Read in Key Order
  • Number of Prev Rows Read in Key Order per Minute
  • Number of Rows Read from Fixed Position
  • Number of Rows Read from Fixed Position per Minute
  • Number of Next Rows Read from Datafile
  • Number of Next Rows Read from Datafile per Minute
  • Number of Rows Updated
  • Number of Rows Updated per Minute
  • Number of Rows Inserted
  • Number of Rows Inserted per Minute
  • Key Blocks Used
  • Key Blocks Used per Minute
  • Key Read Requests
  • Key Read Requests per Minute
  • Key Reads
  • Key Reads per Minute
  • Key Write Requests
  • Key Write Requests per Minute
  • Key Writes
  • Key Writes per Minute
  • Not Flushed Delayed Rows
  • Not Flushed Delayed Rows per Minute
MySQL 3.x, 4.x and 5.x Table Metrics
  • Availability
  • Number of Rows
  • Average Row Length
  • Data Length
  • Max Data Length
  • Index Length
  • Data Free
  • Number of Indicies
  • Average Index Cardinality

Mysql Control Specification

Control Actions
  • Analyze
  • Check
  • Optimize
  • Repair