Status variables to be passed to MySQL. More...

#include <srv0srv.h>

Public Attributes
ulint	innodb_data_pending_reads
	Pending reads. More...

ulint	innodb_data_pending_writes
	Pending writes. More...

ulint	innodb_data_pending_fsyncs
	Pending fsyncs. More...

ulint	innodb_data_fsyncs
	Number of fsyncs so far. More...

ulint	innodb_data_read
	Data bytes read. More...

ulint	innodb_data_writes
	I/O write requests. More...

ulint	innodb_data_written
	Data bytes written. More...

ulint	innodb_data_reads
	I/O read requests. More...

char	innodb_buffer_pool_dump_status [OS_FILE_MAX_PATH+128]
	Buf pool dump status. More...

char	innodb_buffer_pool_load_status [OS_FILE_MAX_PATH+128]
	Buf pool load status. More...

char	innodb_buffer_pool_resize_status [512]
	Buf pool resize status. More...

uint32_t	innodb_buffer_pool_resize_status_code
	Buf pool resize status code. More...

uint32_t	innodb_buffer_pool_resize_status_progress
	Buf pool resize status progess. More...

ulint	innodb_buffer_pool_pages_total
	Buffer pool size. More...

ulint	innodb_buffer_pool_pages_data
	Data pages. More...

ulint	innodb_buffer_pool_bytes_data
	File bytes used. More...

ulint	innodb_buffer_pool_pages_dirty
	Dirty data pages. More...

ulint	innodb_buffer_pool_bytes_dirty
	File bytes modified. More...

ulint	innodb_buffer_pool_pages_misc
	Miscellaneous pages. More...

ulint	innodb_buffer_pool_pages_free
	Free pages. More...

ulint	innodb_buffer_pool_pages_latched
	Latched pages. More...

ulint	innodb_buffer_pool_read_requests
	buf_pool->stat.n_page_gets More...

ulint	innodb_buffer_pool_reads
	srv_buf_pool_reads More...

ulint	innodb_buffer_pool_wait_free
	srv_buf_pool_wait_free More...

ulint	innodb_buffer_pool_pages_flushed
	srv_buf_pool_flushed More...

ulint	innodb_buffer_pool_write_requests
	srv_buf_pool_write_requests More...

ulint	innodb_buffer_pool_read_ahead_rnd
	srv_read_ahead_rnd More...

ulint	innodb_buffer_pool_read_ahead
	srv_read_ahead More...

ulint	innodb_buffer_pool_read_ahead_evicted
	srv_read_ahead evicted More...

ulint	innodb_dblwr_pages_written
	srv_dblwr_pages_written More...

ulint	innodb_dblwr_writes
	srv_dblwr_writes More...

char	innodb_redo_log_resize_status [512]
	Redo log resize status. More...

bool	innodb_redo_log_read_only
	Is redo log read-only ? More...

ulonglong	innodb_redo_log_uuid
	Redo log UUID. More...

ulonglong	innodb_redo_log_checkpoint_lsn
	Redo log checkpoint LSN. More...

ulonglong	innodb_redo_log_current_lsn
	Redo log current LSN. More...

ulonglong	innodb_redo_log_flushed_to_disk_lsn
	Redo log flushed to disk LSN. More...

ulonglong	innodb_redo_log_logical_size
	Redo log logical size. More...

ulonglong	innodb_redo_log_physical_size
	Redo log physical size. More...

ulonglong	innodb_redo_log_capacity_resized
	Redo log capacity after the last finished redo resize. More...

ulint	innodb_log_waits
	srv_log_waits More...

ulint	innodb_log_write_requests
	srv_log_write_requests More...

ulint	innodb_log_writes
	srv_log_writes More...

lsn_t	innodb_os_log_written
	srv_os_log_written More...

ulint	innodb_os_log_fsyncs
	log_total_flushes() More...

ulint	innodb_os_log_pending_writes
	srv_os_log_pending_writes More...

ulint	innodb_os_log_pending_fsyncs
	log_pending_flushes() More...

ulint	innodb_page_size
	UNIV_PAGE_SIZE. More...

ulint	innodb_pages_created
	buf_pool->stat.n_pages_created More...

ulint	innodb_pages_read
	buf_pool->stat.n_pages_read More...

ulint	innodb_pages_written
	buf_pool->stat.n_pages_written More...

bool	innodb_redo_log_enabled
	srv_redo_log More...

ulint	innodb_row_lock_waits
	srv_n_lock_wait_count More...

ulint	innodb_row_lock_current_waits
	srv_n_lock_wait_current_count More...

int64_t	innodb_row_lock_time
	srv_n_lock_wait_time / 1000 More...

ulint	innodb_row_lock_time_avg
	srv_n_lock_wait_time / 1000 / srv_n_lock_wait_count More...

ulint	innodb_row_lock_time_max
	srv_n_lock_max_wait_time / 1000 More...

ulint	innodb_rows_read
	srv_n_rows_read More...

ulint	innodb_rows_inserted
	srv_n_rows_inserted More...

ulint	innodb_rows_updated
	srv_n_rows_updated More...

ulint	innodb_rows_deleted
	srv_n_rows_deleted More...

ulint	innodb_system_rows_read
	srv_n_system_rows_read More...

ulint	innodb_system_rows_inserted
	srv_n_system_rows_inserted More...

ulint	innodb_system_rows_updated
	srv_n_system_rows_updated More...

ulint	innodb_system_rows_deleted
	srv_n_system_rows_deleted More...

ulint	innodb_sampled_pages_read

ulint	innodb_sampled_pages_skipped

ulint	innodb_num_open_files
	fil_n_files_open More...

ulint	innodb_truncated_status_writes
	srv_truncated_status_writes More...

ulint	innodb_undo_tablespaces_total
	total number of undo tablespaces innoDB is tracking. More...

ulint	innodb_undo_tablespaces_implicit
	number of undo tablespaces innoDB created implicitly. More...

ulint	innodb_undo_tablespaces_explicit
	number of undo tablespaces the dba created explicitly. More...

ulint	innodb_undo_tablespaces_active
	number of active undo tablespaces More...

ulint	innodb_purge_trx_id_age
	rw_max_trx_no - purged trx_no More...

ulint	innodb_purge_view_trx_id_age
	rw_max_trx_no More...

ulint	innodb_ahi_drop_lookups
	number of adaptive hash index lookups when freeing file pages More...

Detailed Description

Status variables to be passed to MySQL.

Member Data Documentation

◆ innodb_ahi_drop_lookups

ulint export_var_t::innodb_ahi_drop_lookups

number of adaptive hash index lookups when freeing file pages

◆ innodb_buffer_pool_bytes_data

ulint export_var_t::innodb_buffer_pool_bytes_data

File bytes used.

◆ innodb_buffer_pool_bytes_dirty

ulint export_var_t::innodb_buffer_pool_bytes_dirty

File bytes modified.

◆ innodb_buffer_pool_dump_status

char export_var_t::innodb_buffer_pool_dump_status[OS_FILE_MAX_PATH+ 128]

Buf pool dump status.

◆ innodb_buffer_pool_load_status

char export_var_t::innodb_buffer_pool_load_status[OS_FILE_MAX_PATH+ 128]

Buf pool load status.

◆ innodb_buffer_pool_pages_data

ulint export_var_t::innodb_buffer_pool_pages_data

Data pages.

◆ innodb_buffer_pool_pages_dirty

ulint export_var_t::innodb_buffer_pool_pages_dirty

Dirty data pages.

◆ innodb_buffer_pool_pages_flushed

ulint export_var_t::innodb_buffer_pool_pages_flushed

srv_buf_pool_flushed

◆ innodb_buffer_pool_pages_free

ulint export_var_t::innodb_buffer_pool_pages_free

Free pages.

◆ innodb_buffer_pool_pages_latched

ulint export_var_t::innodb_buffer_pool_pages_latched

Latched pages.

◆ innodb_buffer_pool_pages_misc

ulint export_var_t::innodb_buffer_pool_pages_misc

Miscellaneous pages.

◆ innodb_buffer_pool_pages_total

ulint export_var_t::innodb_buffer_pool_pages_total

Buffer pool size.

◆ innodb_buffer_pool_read_ahead

ulint export_var_t::innodb_buffer_pool_read_ahead

srv_read_ahead

◆ innodb_buffer_pool_read_ahead_evicted

ulint export_var_t::innodb_buffer_pool_read_ahead_evicted

srv_read_ahead evicted

◆ innodb_buffer_pool_read_ahead_rnd

ulint export_var_t::innodb_buffer_pool_read_ahead_rnd

srv_read_ahead_rnd

◆ innodb_buffer_pool_read_requests

ulint export_var_t::innodb_buffer_pool_read_requests

buf_pool->stat.n_page_gets

◆ innodb_buffer_pool_reads

ulint export_var_t::innodb_buffer_pool_reads

srv_buf_pool_reads

◆ innodb_buffer_pool_resize_status

char export_var_t::innodb_buffer_pool_resize_status[512]

Buf pool resize status.

◆ innodb_buffer_pool_resize_status_code

uint32_t export_var_t::innodb_buffer_pool_resize_status_code

Buf pool resize status code.

◆ innodb_buffer_pool_resize_status_progress

uint32_t export_var_t::innodb_buffer_pool_resize_status_progress

Buf pool resize status progess.

◆ innodb_buffer_pool_wait_free

ulint export_var_t::innodb_buffer_pool_wait_free

srv_buf_pool_wait_free

◆ innodb_buffer_pool_write_requests

ulint export_var_t::innodb_buffer_pool_write_requests

srv_buf_pool_write_requests

◆ innodb_data_fsyncs

ulint export_var_t::innodb_data_fsyncs

Number of fsyncs so far.

◆ innodb_data_pending_fsyncs

ulint export_var_t::innodb_data_pending_fsyncs

Pending fsyncs.

◆ innodb_data_pending_reads

ulint export_var_t::innodb_data_pending_reads

Pending reads.

◆ innodb_data_pending_writes

ulint export_var_t::innodb_data_pending_writes

Pending writes.

◆ innodb_data_read

ulint export_var_t::innodb_data_read

Data bytes read.

◆ innodb_data_reads

ulint export_var_t::innodb_data_reads

I/O read requests.

◆ innodb_data_writes

ulint export_var_t::innodb_data_writes

I/O write requests.

◆ innodb_data_written

ulint export_var_t::innodb_data_written

Data bytes written.

◆ innodb_dblwr_pages_written

ulint export_var_t::innodb_dblwr_pages_written

srv_dblwr_pages_written

◆ innodb_dblwr_writes

ulint export_var_t::innodb_dblwr_writes

srv_dblwr_writes

◆ innodb_log_waits

ulint export_var_t::innodb_log_waits

srv_log_waits

◆ innodb_log_write_requests

ulint export_var_t::innodb_log_write_requests

srv_log_write_requests

◆ innodb_log_writes

ulint export_var_t::innodb_log_writes

srv_log_writes

◆ innodb_num_open_files

ulint export_var_t::innodb_num_open_files

fil_n_files_open

◆ innodb_os_log_fsyncs

ulint export_var_t::innodb_os_log_fsyncs

log_total_flushes()

◆ innodb_os_log_pending_fsyncs

ulint export_var_t::innodb_os_log_pending_fsyncs

log_pending_flushes()

◆ innodb_os_log_pending_writes

ulint export_var_t::innodb_os_log_pending_writes

srv_os_log_pending_writes

◆ innodb_os_log_written

lsn_t export_var_t::innodb_os_log_written

srv_os_log_written

◆ innodb_page_size

ulint export_var_t::innodb_page_size

UNIV_PAGE_SIZE.

◆ innodb_pages_created

ulint export_var_t::innodb_pages_created

buf_pool->stat.n_pages_created

◆ innodb_pages_read

ulint export_var_t::innodb_pages_read

buf_pool->stat.n_pages_read

◆ innodb_pages_written

ulint export_var_t::innodb_pages_written

buf_pool->stat.n_pages_written

◆ innodb_purge_trx_id_age

ulint export_var_t::innodb_purge_trx_id_age

rw_max_trx_no - purged trx_no

◆ innodb_purge_view_trx_id_age

ulint export_var_t::innodb_purge_view_trx_id_age

rw_max_trx_no

purged view's min trx_no

◆ innodb_redo_log_capacity_resized

ulonglong export_var_t::innodb_redo_log_capacity_resized

Redo log capacity after the last finished redo resize.

◆ innodb_redo_log_checkpoint_lsn

ulonglong export_var_t::innodb_redo_log_checkpoint_lsn

Redo log checkpoint LSN.

◆ innodb_redo_log_current_lsn

ulonglong export_var_t::innodb_redo_log_current_lsn

Redo log current LSN.

◆ innodb_redo_log_enabled

bool export_var_t::innodb_redo_log_enabled

srv_redo_log

◆ innodb_redo_log_flushed_to_disk_lsn

ulonglong export_var_t::innodb_redo_log_flushed_to_disk_lsn

Redo log flushed to disk LSN.

◆ innodb_redo_log_logical_size

ulonglong export_var_t::innodb_redo_log_logical_size

Redo log logical size.

◆ innodb_redo_log_physical_size

ulonglong export_var_t::innodb_redo_log_physical_size

Redo log physical size.

◆ innodb_redo_log_read_only

bool export_var_t::innodb_redo_log_read_only

Is redo log read-only ?

◆ innodb_redo_log_resize_status

char export_var_t::innodb_redo_log_resize_status[512]

Redo log resize status.

◆ innodb_redo_log_uuid

ulonglong export_var_t::innodb_redo_log_uuid

Redo log UUID.

◆ innodb_row_lock_current_waits

ulint export_var_t::innodb_row_lock_current_waits

srv_n_lock_wait_current_count

◆ innodb_row_lock_time

int64_t export_var_t::innodb_row_lock_time

srv_n_lock_wait_time / 1000

◆ innodb_row_lock_time_avg

ulint export_var_t::innodb_row_lock_time_avg

srv_n_lock_wait_time / 1000 / srv_n_lock_wait_count

◆ innodb_row_lock_time_max

ulint export_var_t::innodb_row_lock_time_max

srv_n_lock_max_wait_time / 1000

◆ innodb_row_lock_waits

ulint export_var_t::innodb_row_lock_waits

srv_n_lock_wait_count

◆ innodb_rows_deleted

ulint export_var_t::innodb_rows_deleted

srv_n_rows_deleted

◆ innodb_rows_inserted

ulint export_var_t::innodb_rows_inserted

srv_n_rows_inserted

◆ innodb_rows_read

ulint export_var_t::innodb_rows_read

srv_n_rows_read

◆ innodb_rows_updated

ulint export_var_t::innodb_rows_updated

srv_n_rows_updated

◆ innodb_sampled_pages_read

ulint export_var_t::innodb_sampled_pages_read

◆ innodb_sampled_pages_skipped

ulint export_var_t::innodb_sampled_pages_skipped

◆ innodb_system_rows_deleted

ulint export_var_t::innodb_system_rows_deleted

srv_n_system_rows_deleted

◆ innodb_system_rows_inserted

ulint export_var_t::innodb_system_rows_inserted

srv_n_system_rows_inserted

◆ innodb_system_rows_read

ulint export_var_t::innodb_system_rows_read

srv_n_system_rows_read

◆ innodb_system_rows_updated

ulint export_var_t::innodb_system_rows_updated

srv_n_system_rows_updated

◆ innodb_truncated_status_writes

ulint export_var_t::innodb_truncated_status_writes

srv_truncated_status_writes

◆ innodb_undo_tablespaces_active

ulint export_var_t::innodb_undo_tablespaces_active

number of active undo tablespaces

◆ innodb_undo_tablespaces_explicit

ulint export_var_t::innodb_undo_tablespaces_explicit

number of undo tablespaces the dba created explicitly.

◆ innodb_undo_tablespaces_implicit

ulint export_var_t::innodb_undo_tablespaces_implicit

number of undo tablespaces innoDB created implicitly.

◆ innodb_undo_tablespaces_total

ulint export_var_t::innodb_undo_tablespaces_total

total number of undo tablespaces innoDB is tracking.

The documentation for this struct was generated from the following file:

storage/innobase/include/srv0srv.h

Public Attributes