| 监控项类型 | 应用集 | 监控项说明 | 监控项 |
| 普通 | DB_MySQL Transaction | 每秒开始操作次数 | Begin operations/sec |
| 每秒提交操作次数 | Commit operations/sec |
| 每秒删除操作次数 | Delete operations/sec |
| 每秒插入操作次数 | Insert operations/sec |
| 每秒查询次数 | Questions/sec |
| 每秒回滚操作次数 | Rollback operations/sec |
| 每秒查看操作次数 | Select operations/sec |
| 每秒更新操作次数 | Update operations/sec |
| 每秒查询次数 | Queries/sec (QPS) |
| 每秒事务数 | Transactions/sec (TPS) |
| DB_MySQL Network | 每秒下载的流量 | Bytes received/sec |
| 每秒上传的流量 | Bytes sent/sec |
| DB_MySQL Slow Query | 慢查询数量 | Slow queries/sec |
| 创建超时的线程数 | Slow launch threads |
| DB_MySQL System | 状态 | MySQL status |
| 开启时间 | Uptime |
| 版本信息 | Version |
| DB_MySQL InnoDB | 数据在内存中的命中率 | InnoDB buffer read hits |
| 从磁盘读入数据至Innodb缓存池的次数 | InnoDB buffer pool reads/sec |
| 从缓冲池中读取页的次数 | InnoDB buffer pool read requests/sec |
| 当前行锁等待数 | InnoDB row lock current waits |
| 行锁最大时间(ms) | InnoDB row lock time max |
| 等待行锁的操作次数 | InnoDB row lock waits |
| Innodb缓存池中总的页数 | InnoDB buffer pool total pages |
| Innodb缓存池中包含数据的页数 | InnoDB buffer pool data pages |
| Innodb缓存池中脏页的数量 | InnoDB buffer pool dirty pages |
| 从Innodb缓存池写入磁盘的页数 | InnoDB buffer pool flushed pages/sec |
| Innodb缓存池中空闲页的数量 | InnoDB buffer pool free pages |
| Innodb缓存池中其它页的数量 | InnoDB buffer pool miscellaneous pages |
| Innodb缓存池写请求数 | InnoDB buffer pool write requests/sec |
| 被删除的行数 | InnoDB deleted rows/sec |
| 插入的行数 | InnoDB inserted rows/sec |
| 读取的行数 | InnoDB read rows/sec |
| 更新的行数 | InnoDB updated rows/sec |
| 日志缓存等待刷新的次数 | InnoDB times of log buffer waited to flush |
| 挂起的写操作数 | InnoDB pending writes to the redo log files |
| 读取索引第一个条目的次数 | InnoDB times of the first entry in an index was read /sec |
| 通过索引获取数据的次数 | InnoDB requests to read a row based on a key /sec |
| 读取索引最后一个条目的次数 | InnoDB requests to read the last key in an index /sec |
| 通过索引读取下一条数据的次数 | InnoDB requests to read the next row in key order /sec |
| 通过索引读取上一条数据的次数 | InnoDB requests to read the previous row in key order /sec |
| 从固定位置读取数据的次数 | InnoDB requests to read a row based on a fixed position /sec |
| 从数据节点读取读取下一条数据的次数 | InnoDB requests to read the next row in the data file /sec |
| DB_MySQL Key Buffer | MyISAM索引缓存中未使用的块数量 | Number of unused key blocks |
| MyISAM索引缓存中已改变还未写入磁盘的块数量 | Number of not flushed key blocks |
| MyISAM索引缓存中已使用的块数量 | Number of used key blocks |
| 从磁盘读取索引块至MyISAM索引池的次数 | Number of physical reads of a key block |
| 从MyISAM索引缓存读索引块的请求数 | Number of requests to read a key block |
| 将索引块从MyISAM索引池写入磁盘的次数 | Number of physical writes of a key block |
| 将索引块写入MyISAM索引池的请求数 | Number of requests to write a key block |
| 读缓存丢失率 | Read cache miss rate % |
| 写缓存丢失率 | Write cache miss rate % |
| DB_MySQL Thread | 已创建的线程数 | Created threads |
| 启用后一共产生的连接数 | Connections |
| 线程命中率 | Thread cache hits |
| 当前连接数 | Current Connections |
| 出现的最大连接数 | Max used connections |
| 最大连接数 | Max connections |
| 连接数百分比 | Connections usage % |
| 等待线程数 | Sleeping threads |
| 缓存线程数 | Cached threads |
| 活动线程数 | Running threads |
| DB_MySQL Table | 创建磁盘临时表的数量 | Created tmp disk tables/sec |
| 表锁等待的次数 | Table locks waited |
| 每秒创建临时表的数量 | Created tmp tables/sec |
| DB_MySQL Monitor | 获取监控数据 | Get global variables data |
| 获取监控数据 | Get mysql monitor data |
| 普通 | DB_MySQL Monitor | 获取监控数据 | Get mysql slave status info |
| DB_MySQL Slave | 从服务器读取进程 | Slave IO running status |
| 从服务器SQL进程 | Slave SQL running status |
| 从服务器同步延迟时间 | Slave delays |
| 普通 | DB_MySQL HACluster | 监控keepalived进程 | Number of keepalived process |
| 监控vip连接性 | VIP accessable status |
| 配置文件是否有修改 | Checksum of file /etc/keepalived/keepalived.conf |
| 检测脚本是否有修改 | Checksum of file /usr/local/mysql/check_mysql.sh |
| 普通 | DB_MySQL MHA | 监控MHA cluster复制状态 | Cluster replication status |
| 监控MHA cluster状态 | Cluster status |
