----- 标准数据统计,主要是命令次数的统计,transaction
ins Com_insert (diff)
upd Com_update (diff)
del Com_delete (diff)
sel Com_select (diff)
tps Com_insert + Com_update + Com_delete (diff)
----- 线程处理,threads
run Threads_running
con Threads_connected
cre Threads_created (diff)
cac Threads_cached
----- 网络字节数,bytes
recv Bytes_received (diff)
sent Bytes_sent (diff)
----- buffer pool的缓存命中率
Innodb_buffer_pool_read_requests 逻辑读总次数
Innodb_buffer_pool_reads 物理读总次数
read Innodb_buffer_pool_read_requests 每秒读请求(diff)
hits (Innodb_buffer_pool_read_requests-Innodb_buffer_pool_reads)/Innodb_buffer_pool_read_requests
----- buffer pool页的状态,innodb bp pages status
data Innodb_buffer_pool_pages_data 已经使用缓存页数
free Innodb_buffer_pool_pages_free 空闲缓存页数
dirty Innodb_buffer_pool_pages_dirty 脏页数目
flush Innodb_buffer_pool_pages_flushed 每秒刷新页数(diff)
----- innoDB相关的操作,innodb rows status
ins Innodb_rows_inserted (diff)
upd Innodb_rows_updated (diff)
del Innodb_rows_deleted (diff)
read Innodb_rows_read (diff)
----- 数据读写请求数,innodb data status
reads Innodb_data_reads 数据读总次数(diff)
writes Innodb_data_writes 数据写的总次数(diff)
read Innodb_data_read 至此已经读的数据量(diff)
written Innodb_data_written 至此已经写的数据量(diff)
----- 日志写入磁盘请求,innodb log
fsyncs Innodb_os_log_fsyncs 向日志文件写的总次数(diff)
written Innodb_os_log_written 写入日志文件的字节数(diff)