监控项类型 | 应用集 | 监控项说明 | 监控项 |
普通 | 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 |