InnoDB page fragmentation counters (5.7)

Registered by Yura Sorokin on 2017-10-12

Port' innodb_check_fragmentation.patch' patch from Percona Server 5.0 to 5.7
https://www.percona.com/blog/2009/11/05/innodb-look-after-fragmentation/

Reimplement the following InnoDB status variables as in the
https://gitweb.gentoo.org/proj/mysql-extras.git/tree/percona/5.0.91-b22-20100522/innodb_check_fragmentation.patch

* 'innodb_scan_pages_contiguous' - number of contiguous page reads.
* 'innodb_scan_pages_disjointed' - number of disjointed page reads.
* 'innodb_scan_data_in_pages' - amount of data read in all pages in bytes
(calculated as the sum of 'page_get_data_size(page)' for every page scanned)
* 'innodb_scan_garbage_in_pages' - amount of garbage (size of records deleted
in 'page_delete_rec_list_end()') read in all pages in bytes (calculated as
the sum of 'page_header_get_field(page, PAGE_GARBAGE)' for every page
scanned).

Introduce new
* 'innodb_scan_pages_total_seek_distance' - total seek distance when moving
between pages.

These variables are accumulated on per-session level and are updated after
each query.

Blueprint information

Status:
Started
Approver:
None
Priority:
High
Drafter:
Yura Sorokin
Direction:
Approved
Assignee:
Yura Sorokin
Definition:
Review
Series goal:
None
Implementation:
Started
Milestone target:
None
Started by
Yura Sorokin on 2017-10-12

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.