• 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)
  • 相关阅读:
    base64模块的使用
    14-类的结构之一:属性
    13-类和对象
    12-数组的常见异常
    11-Arrays工具类的使用
    10-二维数组
    09-一维数组
    08-数组的概述
    07-流程控制
    06-运算符
  • 原文地址:https://www.cnblogs.com/wuchangsoft/p/9765543.html
Copyright © 2020-2023  润新知