Oracle 5.0, Reference Manual

Page: 548 / 3232

Server Status Variables
528
•
Innodb_log_write_requests
[528]
The number of log write requests. Added in MySQL 5.0.2.
•
Innodb_log_writes
[528]
The number of physical writes to the log file. Added in MySQL 5.0.2.
•
Innodb_os_log_fsyncs
[528]
The number of
fsync()
writes done to the log file. Added in MySQL 5.0.2.
•
Innodb_os_log_pending_fsyncs
[528]
The number of pending log file
fsync()
operations. Added in MySQL 5.0.2.
•
Innodb_os_log_pending_writes
[528]
The number of pending log file writes. Added in MySQL 5.0.2.
•
Innodb_os_log_written
[528]
The number of bytes written to the log file. Added in MySQL 5.0.2.
•
Innodb_page_size
[528]
The compiled-in
InnoDB
page size (default 16KB). Many values are counted in pages; the page size
permits them to be easily converted to bytes. Added in MySQL 5.0.2.
•
Innodb_pages_created
[528]
The number of pages created. Added in MySQL 5.0.2.
•
Innodb_pages_read
[528]
The number of pages read. Added in MySQL 5.0.2.
•
Innodb_pages_written
[528]
The number of pages written. Added in MySQL 5.0.2.
•
Innodb_row_lock_current_waits
[528]
The number of row locks currently being waited for. Added in MySQL 5.0.3.
•
Innodb_row_lock_time
[528]
The total time spent in acquiring row locks, in milliseconds. Added in MySQL 5.0.3.
•
Innodb_row_lock_time_avg
[528]
The average time to acquire a row lock, in milliseconds. Added in MySQL 5.0.3.
•
Innodb_row_lock_time_max
[528]
The maximum time to acquire a row lock, in milliseconds. Added in MySQL 5.0.3.
•
Innodb_row_lock_waits
[528]
The number of times a row lock had to be waited for. Added in MySQL 5.0.3.
•
Innodb_rows_deleted
[528]
The number of rows deleted from
InnoDB
tables. Added in MySQL 5.0.2.
•
Innodb_rows_inserted
[528]