本文共 698 字，大约阅读时间需要 2 分钟。
show global status where Variable_name in ('com_delete','com_insert','com_insert_select','com_replace','com_replace_select','com_select&com_update');
>>>>>>>>>>>>>>> QPS_TPSQPS : questionsTPS : com_commit + com_rollback
>>>>>>>>>>>>>>> innobuf_requestibuf_request_r : Innodb_buffer_pool_write_requestsibuf_request_w : Innodb_buffer_pool_read_requests
>>>>>>>>>>>>>>> innobuf_ratio ibuf_read_hit :
innodb_buffer_pool_reads/innodb_buffer_pool_read_requestsi
buf_use_ratio : 1 - innodb_buffer_pool_pages_free / innodb_buffer_pool_pages_totali
buf_dirty_ratio : innodb_buffer_pool_pages_dirty / innodb_buffer_pool_pages_data
本文转自elbertchen 51CTO博客，原文链接：http://blog.51cto.com/linkyou/752024，如需转载请自行联系原作者