MySQL_性能监控项解读.docVIP

MySQL_性能监控项解读 ########### innodb_data ############ EXPRESSION:( $2 - $1 ) / $INTER PARAMETER: fsyncsINNODB_DATA_FSYNCS :The number of fsync() operations readsINNODB_DATA_READS :The total number of data reads writesINNODB_DATA_WRITES :The total number of data writes pending_fsyncs...INNODB_DATA_PENDING_FSYNCS :The current number of pending fsync() pending_readsINNODB_DATA_PENDING_READS :The current number of pending reads pending_writes...INNODB_DATA_PENDING_WRITES :The current number of pending writes TIPS： ########### innodb_rate ############ EXPRESSION:($2 - $1) * 100 / $2 PARAMETER: read_hitrateINNODB_BUFFER_POOL_READS :The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk INNODB_BUFFER_POOL_READ_REQUESTS :The number of logical read requests InnoDB has done log_write_hitrate...INNODB_LOG_WRITES :The number of physical writes to the log file INNODB_LOG_WRITE_REQUESTS :The number of log write requests (variables:write_log_buffer) pages_usageINNODB_BUFFER_POOL_PAGES_FREE :The number of free pages INNODB_BUFFER_POOL_PAGES_TOTAL :The total size of the buffer pool, in pages pages_data_rateINNODB_BUFFER_POOL_PAGES_DATA :The number of pages containing data (dirty or clean) INNODB_BUFFER_POOL_PAGES_TOTAL : pages_dirty_rateINNODB_BUFFER_POOL_PAGES_DIRTY :The number of pages currently dirty INNODB_BUFFER_POOL_PAGES_TOTAL : TIPS: ########### innodb_requests ############ EXPRESSION:( $2 - $1 ) / $INTER PARAMETER: read_ahead_rndINNODB_BUFFER_POOL_READ_AHEAD_RND :The number of “random” read-aheads initiated by InnoDB. This happens when a query scans a large portion of a table but in random order read_ahead_seqINNODB_BUFFER_POOL_READ_AHEAD_SEQ :The number of sequential read-aheads initiated by InnoDB. This happens when InnoDB does a sequential full table scan read_requestsINNODB_BUFFER_POOL_READ_REQUESTS :The nu