Percona Server moved to https://jira.percona.com/projects/PS

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

  1. bug1337231-5.5
  2. Merge into 5.5
Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
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) Approve
Review via email: mp+226258@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
=== modified file 'doc/source/diagnostics/misc_info_schema_tables.rst'
--- doc/source/diagnostics/misc_info_schema_tables.rst 2013-05-27 13:46:13 +0000
+++ doc/source/diagnostics/misc_info_schema_tables.rst 2014-07-10 13:10:33 +0000
@@ -51,7 +51,7 @@
51 :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, unknown51 :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
52 :column SPACE_ID: Tablespace ID52 :column SPACE_ID: Tablespace ID
53 :column PAGE_NO: Page offset within its tablespace53 :column PAGE_NO: Page offset within its tablespace
54 :column LRU_POSITION: Page position in the LRU list54 :column LRU_POSITION: this field is always ``0`` and will be removed in a future Percona Server release
55 :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 accessed55 :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
56 :column FLUSH_TYPE: type of the last flush of the page (0:LRU 2:flush_list)56 :column FLUSH_TYPE: type of the last flush of the page (0:LRU 2:flush_list)
5757
@@ -61,26 +61,26 @@
61 +-----------+----------+---------+--------------+-----------+------------+61 +-----------+----------+---------+--------------+-----------+------------+
62 | page_type | space_id | page_no | lru_position | fix_count | flush_type |62 | page_type | space_id | page_no | lru_position | fix_count | flush_type |
63 +-----------+----------+---------+--------------+-----------+------------+63 +-----------+----------+---------+--------------+-----------+------------+
64 | allocated | 0 | 7 | 3 | 0 | 2 | 64 | allocated | 0 | 7 | 0 | 0 | 2 |
65 | allocated | 0 | 1 | 4 | 0 | 0 | 65 | allocated | 0 | 1 | 0 | 0 | 0 |
66 | allocated | 0 | 3 | 5 | 0 | 0 | 66 | allocated | 0 | 3 | 0 | 0 | 0 |
67 | inode | 0 | 2 | 6 | 0 | 2 | 67 | inode | 0 | 2 | 0 | 0 | 2 |
68 | index | 0 | 4 | 7 | 0 | 2 | 68 | index | 0 | 4 | 0 | 0 | 2 |
69 | index | 0 | 11 | 8 | 0 | 0 | 69 | index | 0 | 11 | 0 | 0 | 0 |
70 | index | 0 | 12956 | 9 | 0 | 0 | 70 | index | 0 | 12956 | 0 | 0 | 0 |
71 | allocated | 0 | 5 | 10 | 0 | 2 | 71 | allocated | 0 | 5 | 0 | 0 | 2 |
72 | allocated | 0 | 6 | 11 | 0 | 2 | 72 | allocated | 0 | 6 | 0 | 0 | 2 |
73 | undo_log | 0 | 51 | 12 | 0 | 2 | 73 | undo_log | 0 | 51 | 0 | 0 | 2 |
74 | undo_log | 0 | 52 | 13 | 0 | 2 | 74 | undo_log | 0 | 52 | 0 | 0 | 2 |
75 | index | 0 | 8 | 14 | 0 | 0 | 75 | index | 0 | 8 | 0 | 0 | 0 |
76 | index | 0 | 288 | 15 | 0 | 0 | 76 | index | 0 | 288 | 0 | 0 | 0 |
77 | index | 0 | 290 | 16 | 0 | 2 | 77 | index | 0 | 290 | 0 | 0 | 2 |
78 | index | 0 | 304 | 17 | 0 | 0 | 78 | index | 0 | 304 | 0 | 0 | 0 |
79 | allocated | 0 | 0 | 18 | 0 | 2 | 79 | allocated | 0 | 0 | 0 | 0 | 2 |
80 | index | 0 | 10 | 19 | 0 | 0 | 80 | index | 0 | 10 | 0 | 0 | 0 |
81 | index | 0 | 12973 | 20 | 0 | 0 | 81 | index | 0 | 12973 | 0 | 0 | 0 |
82 | index | 0 | 9 | 21 | 0 | 2 | 82 | index | 0 | 9 | 0 | 0 | 2 |
83 | index | 0 | 12 | 22 | 0 | 0 | 83 | index | 0 | 12 | 0 | 0 | 0 |
84 +-----------+----------+---------+--------------+-----------+------------+84 +-----------+----------+---------+--------------+-----------+------------+
85 20 rows in set (0.81 sec)85 20 rows in set (0.81 sec)
8686
8787
=== modified file 'doc/source/management/changed_page_tracking.rst'
--- doc/source/management/changed_page_tracking.rst 2013-03-06 06:41:38 +0000
+++ doc/source/management/changed_page_tracking.rst 2014-07-10 13:10:33 +0000
@@ -13,8 +13,12 @@
1313
14Sequence 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.14Sequence 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.
1515
16Old 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.
17
16This feature will be used for implementing faster incremental backups that use this information to avoid full data scans in |Percona XtraBackup|.18This feature will be used for implementing faster incremental backups that use this information to avoid full data scans in |Percona XtraBackup|.
1719
20.. _changed_page_tracking_statements:
21
18User statements for handling the XtraDB changed page bitmaps22User statements for handling the XtraDB changed page bitmaps
19============================================================23============================================================
2024
@@ -45,7 +49,7 @@
4549
46The ``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.50The ``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.
4751
48Number of records in this table can be limited by using the variable :variable:`innodb_changed_pages_limit`.52Number of records in this table can be limited by using the variable :variable:`innodb_max_changed_pages`.
4953
50System Variables54System Variables
51================55================
@@ -62,6 +66,8 @@
62 :default: 100000066 :default: 1000000
63 :range: 1 - 0 (unlimited)67 :range: 1 - 0 (unlimited)
6468
69This variable is used to limit the result row count for the queries from :table:`INNODB_CHANGED_PAGES` table.
70
65.. variable:: innodb_track_changed_pages71.. variable:: innodb_track_changed_pages
6672
67 :version 5.5.27-29.0: Variable introduced73 :version 5.5.27-29.0: Variable introduced
@@ -73,6 +79,8 @@
73 :default: 0 - False79 :default: 0 - False
74 :range: 0-180 :range: 0-1
7581
82This variable is used to enable/disable :ref:`changed_page_tracking` feature.
83
76.. variable:: innodb_max_bitmap_file_size84.. variable:: innodb_max_bitmap_file_size
7785
78 :version 5.5.28-29.2: Variable introduced86 :version 5.5.28-29.2: Variable introduced
@@ -83,3 +91,5 @@
83 :vartype: Numeric 91 :vartype: Numeric
84 :default: 104857600 (100 MB)92 :default: 104857600 (100 MB)
85 :range: 4096 (4KB) - 18446744073709551615 (16EB)93 :range: 4096 (4KB) - 18446744073709551615 (16EB)
94
95This variable is used to control maximum bitmap size after which the file will be rotated.
8696
=== modified file 'doc/source/release-notes/Percona-Server-5.5.30-30.2.rst'
--- doc/source/release-notes/Percona-Server-5.5.30-30.2.rst 2013-09-30 16:39:12 +0000
+++ doc/source/release-notes/Percona-Server-5.5.30-30.2.rst 2014-07-10 13:10:33 +0000
@@ -13,7 +13,7 @@
1313
14 |Percona Server| has implemented priority connection scheduling for the :ref:`threadpool`. (*Alexey Kopytov*) 14 |Percona Server| has implemented priority connection scheduling for the :ref:`threadpool`. (*Alexey Kopytov*)
1515
16 |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*)16 |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*)
1717
18 This release of |Percona Server| has fixed a number of performance bugs. (*Alexey Kopytov*)18 This release of |Percona Server| has fixed a number of performance bugs. (*Alexey Kopytov*)
1919

Subscribers

People subscribed via source and target branches