MySQL Management Support
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 (Linux/Apache/MySQL/php/Perl) 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 ammount 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 details about our MySQL plugin, please visit our HyperFORGE http://support.hyperic.com/confluence/display/hypcomm/MySQL
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
MySQL Supported Versions
MySQL Process 3.x
MySQL 3.x
MySQL Process 4.x
MySQL 4.x
MySQL Process 5.x
MySQL 5.x
MySQL 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
)
COMMUNITY
