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
转载于:https://blog.51cto.com/linkyou/752024