InnoDB  Variable Value Description 
[Variables] [InnoDB Status] []  
Innodb_buffer_pool_pages_data 511  The number of pages containing data (dirty or clean).  
Innodb_buffer_pool_pages_dirty 0  The number of pages currently dirty.  
Innodb_buffer_pool_pages_flushed 4,143 k The number of buffer pool pages that have been requested to be flushed.  
Innodb_buffer_pool_pages_free 0  The number of free pages.  
Innodb_buffer_pool_pages_misc 1  The number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. This value can also be calculated as Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data.  
Innodb_buffer_pool_pages_total 512  Total size of buffer pool, in pages.  
Innodb_buffer_pool_read_ahead_rnd 897 k The number of "random" read-aheads InnoDB initiated. This happens when a query is to scan a large portion of a table but in random order.  
Innodb_buffer_pool_read_ahead_seq 4,171 k The number of sequential read-aheads InnoDB initiated. This happens when InnoDB does a sequential full table scan.  
Innodb_buffer_pool_read_requests 22 G The number of logical read requests InnoDB has done.  
Innodb_buffer_pool_reads 27 M The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.  
Innodb_buffer_pool_wait_free 0  Normally, writes to the InnoDB buffer pool happen in the background. However, if it's necessary to read or create a page and no clean pages are available, it's necessary to wait for pages to be flushed first. This counter counts instances of these waits. If the buffer pool size was set properly, this value should be small.  
Innodb_buffer_pool_write_requests 17 M The number writes done to the InnoDB buffer pool.  
Innodb_data_fsyncs 3,276 k The number of fsync() operations so far.  
Innodb_data_pending_fsyncs 0  The current number of pending fsync() operations.  
Innodb_data_pending_reads 0  The current number of pending reads.  
Innodb_data_pending_writes 0  The current number of pending writes.  
Innodb_data_read 1,562 G The amount of data read so far, in bytes.  
Innodb_data_reads 35 M The total number of data reads.  
Innodb_data_writes 6,358 k The total number of data writes.  
Innodb_data_written 139 G The amount of data written so far, in bytes.  
Innodb_dblwr_pages_written 4,143 k The number of pages that have been written for doublewrite operations.  
Innodb_dblwr_writes 527 k The number of doublewrite operations that have been performed.  
Innodb_log_waits 0  The number of waits we had because log buffer was too small and we had to wait for it to be flushed before continuing.  
Innodb_log_write_requests 5,024 k The number of log write requests.  
Innodb_log_writes 1,900 k The number of physical writes to the log file.  
Innodb_os_log_fsyncs 2,223 k The number of fsync() writes done to the log file.  
Innodb_os_log_pending_fsyncs 0  The number of pending log file fsyncs.  
Innodb_os_log_pending_writes 0  Pending log file writes.  
Innodb_os_log_written 3,144 M The number of bytes written to the log file.  
Innodb_page_size 16 k The compiled-in InnoDB page size (default 16KB). Many values are counted in pages; the page size allows them to be easily converted to bytes.  
Innodb_pages_created 88 k The number of pages created.  
Innodb_pages_read 95 M The number of pages read.  
Innodb_pages_written 4,143 k The number of pages written.  
Innodb_row_lock_current_waits 0  The number of row locks currently being waited for.  
Innodb_row_lock_time 614 k The total time spent in acquiring row locks, in milliseconds.  
Innodb_row_lock_time_avg 1,037  The average time to acquire a row lock, in milliseconds.  
Innodb_row_lock_time_max 33 k The maximum time to acquire a row lock, in milliseconds.  
Innodb_row_lock_waits 592  The number of times a row lock had to be waited for.  
Innodb_rows_deleted 227 k The number of rows deleted from InnoDB tables.  
Innodb_rows_inserted 890 k The number of rows inserted in InnoDB tables.  
Innodb_rows_read 10 G The number of rows read from InnoDB tables.  
Innodb_rows_updated 1,057 k The number of rows updated in InnoDB tables.