logs to the disk at each commit, which offers full ACID behavior. If you are willing to compromise this safety, and you are running small transactions, you may set this to 0 or 2 to reduce disk I/O to the logs. Value 0 means that the log is only written to the log file and the log file flushed to disk approximately once per second. Value 2 means the log is written to the log file at each commit, but the log file is only flushed to disk approximately once per second.InnodbData PagesInnodb_buffer_pool_pages_dataThe number of pages containing data (dirty or clean).Dirty PagesInnodb_buffer_pool_pages_dirtyThe number of pages currently dirty.Pages FlushedInnodb_buffer_pool_pages_flushedThe number of buffer pool pages that have been requested to be flushed.Pages FreeInnodb_buffer_pool_pages_freeThe number of free pages.Innodb_buffer_pool_pages_latchedThe number of latched pages in InnoDB buffer pool. These are pages currently being read or written or that cant be flushed or removed for some other reason.Innodb_buffer_pool_pages_miscThe number of pages busy because they have been allocated for administrative overhead such as row locks or the adaptive hash index. It can also be calculated as Innodb_buffer_pool_pages_total Innodb_buffer_pool_pages_free Innodb_buffer_pool_pages_data.Buffer Pool PagesInnodb_buffer_pool_pages_totalTotal size of buffer pool, in pages.Innodb_buffer_pool_read_ahead_rndThe 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_seqThe number of sequential read-aheads InnoDB initiated. This happens when InnoDB does a sequential full table scan.Innodb_buffer_pool_read_requestsThe number of logical read requests InnoDB has done.Innodb_buffer_pool_readsThe number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.Innodb_buffer_pool_wait_freeNormally, writes to the InnoDB buffer pool happen in the background. However, if its necessary to read or create a page and no clean pages are available, its 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_requestsThe number writes done to the InnoDB buffer pool.Innodb_data_fsyncsThe number of fsync() operations so far.Innodb_data_pending_fsyncsThe current number of pending fsync() operations.Innodb_data_pending_readsThe current number of pending reads.Innodb_data_pending_writesThe current number of pending writes.Innodb_data_readThe amount of data read so far, in bytes.Innodb_data_readsThe total number of data reads.Innodb_data_writesThe total number of data writes.Innodb_data_writtenThe amount of data written so far, in bytes.Innodb_log_waitsThe 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_requestsThe number of log writes requests.Innodb_log_writesThe number of physical writes to the log file.Innodb_os_log_fsyncsThe number of fsyncs writes done to the log file.Innodb_os_log_pending_fsyncsThe number of pending log file fsyncs.Innodb_os_log_pending_writesPending log file writes.Innodb_os_log_writtenThe number of bytes written to the log file.Innodb_page_sizeThe 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_createdThe number of pages created.Innodb_pages_readThe number of pages read.Innodb_pages_writtenThe number of pages written.Innodb_row_lock_current_waitsThe number of row locks currently being waited for.Innodb_row_lock_timeThe total time spent in acquiring row locks, in milliseconds.Innodb_row_lock_time_avgThe average time to acquire a row lock, in milliseconds.Innodb_row_lock_time_maxThe maximum time to acquire a row lock, in milliseconds.Innodb_row_lock_waitsThe number of times a row lock had to be waited for.Innodb_rows_deletedThe