Merge lp:~hrvojem/percona-server/bug1337231-5.1 into lp:percona-server/5.1

Proposed by Hrvoje Matijakovic on 2014-07-09
Status: Merged
Approved by: Laurynas Biveinis on 2014-07-10
Approved revision: 618
Merged at revision: 618
Proposed branch: lp:~hrvojem/percona-server/bug1337231-5.1
Merge into: lp:percona-server/5.1
Diff against target: 109 lines (+32/-22)
2 files modified
doc/source/diagnostics/misc_info_schema_tables.rst (+21/-21)
doc/source/management/changed_page_tracking.rst (+11/-1)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1337231-5.1
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2014-07-09 Approve on 2014-07-10
Review via email: mp+226105@code.launchpad.net
To post a comment you must log in.
review: Needs Fixing
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/diagnostics/misc_info_schema_tables.rst'
2--- doc/source/diagnostics/misc_info_schema_tables.rst 2012-12-10 14:01:11 +0000
3+++ doc/source/diagnostics/misc_info_schema_tables.rst 2014-07-10 07:50:57 +0000
4@@ -49,7 +49,7 @@
5 :column PAGE_TYPE: Type of the page. Possible values: index, undo_log, inode, ibuf_free_list, allocated, bitmap, sys, trx_sys, fsp_hdr, xdes, blob, zblob, zblob2, unknown
6 :column SPACE_ID: tablespace ID
7 :column PAGE_NO: page offset within its tablespace
8- :column LRU_POSITION: page position in the LRU list
9+ :column LRU_POSITION: this field is always ``0`` and will be removed in a future Percona Server release
10 :column FIX_COUNT: reference count of a page. It is incremented every time the page is accessed by InnoDB, it is 0 if and only if the page is not currently being accessed.
11 :column FLUSH_TYPE: type of the last flush of the page (0:LRU 2:flush_list)
12
13@@ -59,26 +59,26 @@
14 +-----------+----------+---------+--------------+-----------+------------+
15 | page_type | space_id | page_no | lru_position | fix_count | flush_type |
16 +-----------+----------+---------+--------------+-----------+------------+
17- | allocated | 0 | 7 | 3 | 0 | 2 |
18- | allocated | 0 | 1 | 4 | 0 | 0 |
19- | allocated | 0 | 3 | 5 | 0 | 0 |
20- | inode | 0 | 2 | 6 | 0 | 2 |
21- | index | 0 | 4 | 7 | 0 | 2 |
22- | index | 0 | 11 | 8 | 0 | 0 |
23- | index | 0 | 12956 | 9 | 0 | 0 |
24- | allocated | 0 | 5 | 10 | 0 | 2 |
25- | allocated | 0 | 6 | 11 | 0 | 2 |
26- | undo_log | 0 | 51 | 12 | 0 | 2 |
27- | undo_log | 0 | 52 | 13 | 0 | 2 |
28- | index | 0 | 8 | 14 | 0 | 0 |
29- | index | 0 | 288 | 15 | 0 | 0 |
30- | index | 0 | 290 | 16 | 0 | 2 |
31- | index | 0 | 304 | 17 | 0 | 0 |
32- | allocated | 0 | 0 | 18 | 0 | 2 |
33- | index | 0 | 10 | 19 | 0 | 0 |
34- | index | 0 | 12973 | 20 | 0 | 0 |
35- | index | 0 | 9 | 21 | 0 | 2 |
36- | index | 0 | 12 | 22 | 0 | 0 |
37+ | allocated | 0 | 7 | 0 | 0 | 2 |
38+ | allocated | 0 | 1 | 0 | 0 | 0 |
39+ | allocated | 0 | 3 | 0 | 0 | 0 |
40+ | inode | 0 | 2 | 0 | 0 | 2 |
41+ | index | 0 | 4 | 0 | 0 | 2 |
42+ | index | 0 | 11 | 0 | 0 | 0 |
43+ | index | 0 | 12956 | 0 | 0 | 0 |
44+ | allocated | 0 | 5 | 0 | 0 | 2 |
45+ | allocated | 0 | 6 | 0 | 0 | 2 |
46+ | undo_log | 0 | 51 | 0 | 0 | 2 |
47+ | undo_log | 0 | 52 | 0 | 0 | 2 |
48+ | index | 0 | 8 | 0 | 0 | 0 |
49+ | index | 0 | 288 | 0 | 0 | 0 |
50+ | index | 0 | 290 | 0 | 0 | 2 |
51+ | index | 0 | 304 | 0 | 0 | 0 |
52+ | allocated | 0 | 0 | 0 | 0 | 2 |
53+ | index | 0 | 10 | 0 | 0 | 0 |
54+ | index | 0 | 12973 | 0 | 0 | 0 |
55+ | index | 0 | 9 | 0 | 0 | 2 |
56+ | index | 0 | 12 | 0 | 0 | 0 |
57 +-----------+----------+---------+--------------+-----------+------------+
58 20 rows in set (0.81 sec)
59
60
61=== modified file 'doc/source/management/changed_page_tracking.rst'
62--- doc/source/management/changed_page_tracking.rst 2013-03-05 14:25:44 +0000
63+++ doc/source/management/changed_page_tracking.rst 2014-07-10 07:50:57 +0000
64@@ -13,8 +13,12 @@
65
66 Sequence number can be used to easily check if all the required bitmap files are present. Start LSN number will be used in |XtraBackup| and ``INFORMATION_SCHEMA`` queries to determine which files have to be opened and read for the required LSN interval data. The bitmap file is rotated on each server restart and whenever the current file size reaches the predefined maximum. This maximum is controlled with the :variable:`innodb_max_bitmap_file_size` variable.
67
68+Old bitmap files may be safely removed after a corresponding incremental backup is taken. For that there are server :ref:`changed_page_tracking_statements`. Removing the bitmap files from the filesystem directly is safe too, as long as care is taken not to delete data for not-yet-backuped LSN range.
69+
70 This feature will be used for implementing faster incremental backups that use this information to avoid full data scans in |Percona XtraBackup|.
71
72+.. _changed_page_tracking_statements:
73+
74 User statements for handling the XtraDB changed page bitmaps
75 ============================================================
76
77@@ -45,7 +49,7 @@
78
79 The ``start_lsn`` and the ``end_lsn`` columns denote between which two checkpoints this page was changed at least once. They are also equal to checkpoint LSNs.
80
81-Number of records in this table can be limited by using the variable :variable:`innodb_changed_pages_limit`.
82+Number of records in this table can be limited by using the variable :variable:`innodb_max_changed_pages`.
83
84 System Variables
85 ================
86@@ -62,6 +66,8 @@
87 :default: 1000000
88 :range: 1 - 0 (unlimited)
89
90+This variable is used to limit the result row count for the queries from :table:`INNODB_CHANGED_PAGES` table.
91+
92 .. variable:: innodb_track_changed_pages
93
94 :version 5.1.65-14.0: Variable introduced
95@@ -73,6 +79,8 @@
96 :default: 0 - False
97 :range: 0-1
98
99+This variable is used to enable/disable :ref:`changed_page_tracking` feature.
100+
101 .. variable:: innodb_max_bitmap_file_size
102
103 :version 5.1.66-14.2: Variable introduced
104@@ -83,3 +91,5 @@
105 :vartype: Numeric
106 :default: 104857600 (100 MB)
107 :range: 4096 (4KB) - 18446744073709551615 (16EB)
108+
109+This variable is used to control maximum bitmap size after which the file will be rotated.

Subscribers

People subscribed via source and target branches