mysql logical read,MySQL_性能监控项解读.doc

MySQL_性能监控项解读

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