xtools

xtools

----- 标准数据统计,主要是命令次数的统计,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)
posted @ 2018-10-10 11:48  wuchangsoft  阅读(222)  评论(0编辑  收藏  举报