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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
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) Approve
Review via email: mp+226105@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) :
review: Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) :
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