[DOC] InnoDB status vars are not conclusive
Bug #1413983 reported by
Muhammad Irfan
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Borys Belinsky | |||
5.6 |
Triaged
|
Medium
|
Borys Belinsky | |||
5.7 |
Triaged
|
Medium
|
Borys Belinsky |
Bug Description
Status variables from innodb status are not explained here http://
It only describes status variables information coming from different sections of "SHOW ENGINE INNODB STATUS". Short description for these status vars would be handy.
no longer affects: | percona-server-5.6 (Ubuntu) |
summary: |
- InnoDB status vars are not conclusive + [DOC] InnoDB status vars are not conclusive |
tags: | added: doc |
To post a comment you must log in.
Innodb_ master_ thread_ active_ loops master_ thread_ idle_loops
Innodb_
InnoDB has a so-called "master" thread which performs background tasks
depending on the server state, once per second. If the server is under
workload, the master thread runs the following: performs background
table drops; performs change buffer merge, adaptively; flushes the
redo log to disk; evicts tables from the dictionary cache if needed to
satisfy its size limit; makes a checkpoint. If the server is idle:
performs background table drops, flushes and/or checkpoints the redo
log if needed due to the checkpoint age; performs change buffer merge
at full I/O capacity; evicts tables from the dictionary cache if
needed; makes a checkpoint; (5.6 only) and purges archived logs if
needed.
These two variables represent the number of times the above one-second
loop was executed for active and idle server states.
Innodb_ backgroud_ log_sync
The number of times the InnoDB master thread has written and flushed
the redo log.
Innodb_lsn_current
The current log sequence number
Innodb_lsn_flushed
The current maximum LSN that has been written and flushed to disk
Innodb_ lsn_last_ checkpoint
The LSN of the latest completed checkpoint
Innodb_ checkpoint_ age
The current InnoDB checkpoint age, i.e. the difference bweteen the
current LSN and the LSN of the last completed checkpoint
Innodb_ checkpoint_ max_age
The maximum allowed checkppoint age above which the redo log is close
to full and a checkpoint must happen before any further redo log
writes
Innodb_ mem_adaptive_ hash
The current size, in bytes, of the adaptive hash index.
Innodb_ mem_dictionary
The current size, in bytes, of the InnoDB in-memory data dictionary
info
Innodb_mem_total
The total amount of memory, in bytes, InnoDB has allocated in the
process heap memory.
Innodb_ buffer_ pool_pages_ LRU_flushed
The total counter of buffer pool pages which have been fiushed from
the LRU list, i.e. too old pages which had to be flushed in order to
make buffer pool room to read in new data pages.
Innodb_ buffer_ pool_pages_ made_not_ young
The number of times a buffer pool page was not marked as accessed old_blocks_ time setting.
recently in the LRU list because of innodb_
Innodb_ buffer_ pool_pages_ made_young
The number of times a buffer pool page was moved to the young end of
the LRU list due to its access, to prevent its eviction from the
buffer pool.
Innodb_ buffer_ pool_pages_ old
The total number of buffer pool pages which are considered to be old /dev.mysql. com/doc/ refman/ 5.7/en/ innodb- performance- midpoint_ insertion. html
according to
https:/
Innodb_ descriptors_ memory (only in 5.5 / 5.6)
The current size, in bytes, taken by the descriptor array of the /www.percona. com/blog/ 2013/04/ 12/trx- descriptors- mysql-performan ce-improvements -in-percona- server- 5-5-30- 30-2/)
currently active transactions
(https:/
Innodb_ read_views_ memory (only in 5.5 / 5.6)
The current size, in bytes, taken by all the currently open read views
Innodb_max_trx_id
The next free transaction id number
Innodb_ oldest_ view_low_ limit_trx_ id
The highest transaction id, above which the current oldest open read
view does not see any transaction changes. Zero if there is n...