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

Proposed by Hrvoje Matijakovic on 2014-07-10
Status: Merged
Approved by: Laurynas Biveinis on 2014-07-11
Approved revision: 671
Merged at revision: 678
Proposed branch: lp:~hrvojem/percona-server/bug1337231-5.5
Merge into: lp:percona-server/5.5
Diff against target: 121 lines (+33/-23)
3 files modified
doc/source/diagnostics/misc_info_schema_tables.rst (+21/-21)
doc/source/management/changed_page_tracking.rst (+11/-1)
doc/source/release-notes/Percona-Server-5.5.30-30.2.rst (+1/-1)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1337231-5.5
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2014-07-10 Approve on 2014-07-11
Review via email: mp+226258@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 2013-05-27 13:46:13 +0000
3+++ doc/source/diagnostics/misc_info_schema_tables.rst 2014-07-10 13:10:33 +0000
4@@ -51,7 +51,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|, and 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@@ -61,26 +61,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-06 06:41:38 +0000
63+++ doc/source/management/changed_page_tracking.rst 2014-07-10 13:10:33 +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 by a new :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.5.27-29.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.5.28-29.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.
110
111=== modified file 'doc/source/release-notes/Percona-Server-5.5.30-30.2.rst'
112--- doc/source/release-notes/Percona-Server-5.5.30-30.2.rst 2013-09-30 16:39:12 +0000
113+++ doc/source/release-notes/Percona-Server-5.5.30-30.2.rst 2014-07-10 13:10:33 +0000
114@@ -13,7 +13,7 @@
115
116 |Percona Server| has implemented priority connection scheduling for the :ref:`threadpool`. (*Alexey Kopytov*)
117
118- |Percona Server| will now be shipped with the ``libjemalloc`` library. Benchmark showing the impact of memory allocators on |MySQL| performance can be found in this `blogpost <http://www.mysqlperformanceblog.com/2012/07/05/impact-of-memory-allocators-on-mysql-performance/>`_. (*Ignacio Nin*)
119+ |Percona Server| ``.tar.gz`` binaries will now be shipped with the ``libjemalloc`` library. ``jemalloc`` package is now available in our :ref:`apt <apt_repo>`/:ref:`yum <yum_repo>` repositories as well. In case newer version is available in the distribution repositories that version will be used. Benchmark showing the impact of memory allocators on |MySQL| performance can be found in this `blogpost <http://www.mysqlperformanceblog.com/2012/07/05/impact-of-memory-allocators-on-mysql-performance/>`_. (*Ignacio Nin*)
120
121 This release of |Percona Server| has fixed a number of performance bugs. (*Alexey Kopytov*)
122

Subscribers

People subscribed via source and target branches