Home >Database >Mysql Tutorial >Detailed explanation of Innodb status

Detailed explanation of Innodb status

PHP中文网
PHP中文网Original
2017-06-20 15:07:301930browse

Innodb_buffer_pool_pages_data

The number of pages containing data in the Innodb buffer pool cache pool, including dirty pages. The unit is page.

Innodb_buffer_pool_pages_dirty

The number of dirty pages in the innodb buffer pool cache pool. The unit is page.

Innodb_buffer_pool_pages_flushed

The number of flush page requests in the innodb buffer pool cache pool. The unit is page.

Innodb_buffer_pool_pages_free

The number of pages remaining in the innodb buffer pool. The unit is page.

Innodb_buffer_pool_pages_misc

The number of pages in the innodb buffer pool buffer pool that are currently used for management purposes or hash index and cannot be used as ordinary data pages . The unit is page.

Innodb_buffer_pool_pages_total

##The total number of pages in the innodb buffer pool. The unit is page.

Innodb_buffer_pool_read_ahead

The number of pages read by the backend read-ahead thread into the innodb buffer pool. The unit is page.

Innodb_buffer_pool_read_ahead_evicted

The number of pages read in advance, but the number of pages that are replaced from the buffer pool without being read, generally used To judge the efficiency of pre-reading.

Innodb_buffer_pool_read_requests

The number of logical reads performed by innodb. The unit is times.

Innodb_buffer_pool_reads

The number of times a single page read cannot be obtained from the buffer pool when performing logical reads. The unit is times.

Innodb_buffer_pool_wait_free

Writing to the InnoDB buffer pool usually occurs in the background, but it is necessary to read or create pages when there are no clean pages. It is necessary to wait for the page to be refreshed first. The number of times Innodb's IO thread needs to wait for free pages when it reads data from the data file and writes it to the buffer pool. The unit is times.

Innodb_buffer_pool_write_requests

The number of writes to the InnoDB buffer pool. The unit is times.

Innodb_data_fsyncs

The number of fsync() operations performed by innodb. The unit is times.

Innodb_data_pending_fsyncs

The number of fsync() operations currently pending in innodb. The unit is times.

Innodb_data_pending_reads

The number of read operations currently pending in innodb. The unit is times.

Innodb_data_pending_writes

inndoThe number of currently pending write operations. The unit is times.

Innodb_data_read

The total amount of data read by innodb. The unit is bytes.

Innodb_data_reads

The total number of innodb data reads. The unit is times.

Innodb_data_writes

The total number of innodb data writes. The unit is times.

Innodb_data_written

The total amount of data written by innodb. The unit is bytes.

Innodb_dblwr_pages_written

The total number of doublewrite pages that innodb has completed. The unit is page.

Innodb_dblwr_writes

The total number of doublewrites that innodb has completed. The unit is times.

Innodb_log_waits

The number of waits caused by having to wait for the log cache to be written because it is too small. The unit is times.

Innodb_log_write_requests

The number of innodb log write requests. The unit is times.

Innodb_log_writes

The total number of times innodb log buffer writes to log file. The unit is times.

Innodb_os_log_fsyncs

The total number of fsync() performed on the innodb log buffer. The unit is times.

Innodb_os_log_pending_fsyncs

The current number of pending fsync log files. The unit is times.

Innodb_os_log_pending_writes

The number of currently pending write log files. The unit is times.

Innodb_os_log_written

The number of bytes written to the log file. The unit is bytes.

Innodb_page_size

Compiled InnoDB page size (default 16KB).

Innodb_pages_created

The total number of pages in innodb. The unit is page.

Innodb_pages_read

The total number of pages read by innodb. The unit is page.

Innodb_pages_written

The total number of pages written by innodb. The unit is page.

Innodb_row_lock_current_waits

The number of row locks that innodb is currently waiting for. The unit is a.

Innodb_row_lock_time

The total time spent by innodb to acquire row locks. The unit is milliseconds.

Innodb_row_lock_time_avg

The average time innodb waits to obtain a row lock. The unit is milliseconds.

Innodb_row_lock_time_max

The maximum waiting time for innodb to acquire a row lock. The unit is milliseconds.

Innodb_row_lock_waits

The number of times innodb waits to acquire a row lock. The unit is times.

Innodb_rows_deleted

The number of rows deleted from the innodb table. The unit is row.

Innodb_rows_inserted

The number of rows inserted into the innodb table. The unit is row.

Innodb_rows_updated

The number of updated rows in the innodb table. The unit is row

The above is the detailed content of Detailed explanation of Innodb status. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn