MySQL数据库监控项

[复制链接]
lewei 发表于 2020-7-31 16:33:46 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题
监控项类型应用集监控项说明监控项
普通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 BufferMyISAM索引缓存中未使用的块数量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

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关注0

粉丝0

帖子110

发布主题

乐维社区

微信公众号

版权所有 © 2016-2021 九一乐维丨粤ICP备17007026号