MySQL监控

webmaster 在 2010-02-10 13:49 提交

       MySQL是最流行的开放源代码关系数据库系统。其性能和易用性，使其成为LAMP架构的中心支柱之一。
       MySQL监控一直是关注MySQL数据库性能和MySQL数据库运维管理技术人员的非常感兴趣话题。如何让您的MySQL数据库安全快速的运行，Hyperic HQ就可以通过监控MySQL，通过报警方式及时发现MySQL数据库存在的问题！

        Hyperic HQ 对开源技术的全面支持意味着您可以轻松管理MySQL以及通过HQ接口管理其余的LAMP堆栈 。Hyperic HQ具有直观性和可见性，这种可见性由MySQL数据库引擎以及每个表的大量度量值驱动。

        此外，HQ通过自动化和需求管理任务控制MySQL，这将有助于保持MySQL数据库的高性能运行。其强大的应用概念，您可以直观地监测你的业务逻辑和数据库层表示层，通过测量数据可以衡量你的应用程序基础架构的各个层面如何在客户端的活动。

       Hyperic HQ 对MySQL监控主要体现在：
      自动发现您的硬件和MySQL服务器
      监控MySQL资源的每一个度量值，日志，配置
      用自动的度量值基线识别问题
      控制所有MySQL资源上的命令，调度，或警报回应
      警报MySQL环境的在任何测量，日志，或安全性事件

     Hyperic HQ--优秀的MySQL数据库监控软件 ,相信能给您带来更多价值，让您从繁重的工作中解脱出来，得到一份轻松和愉快！

    Hyperic HQ下载：http://knowhow.innovatedigital.com/node/326

    Hyperic HQ FAQ与解答 http://knowhow.innovatedigital.com/hyperic-hq

   Hyperic HQ 技术论坛：http://g.51cto.com/hyperichq

 

附：

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


 

Hyperic HQ