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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 229
Proposed branch: lp:~hrvojem/percona-server/bug955266-5.5
Merge into: lp:percona-server/5.5
Diff against target: 76 lines (+23/-4)
2 files modified
doc/source/management/innodb_lru_dump_restore.rst (+21/-2)
doc/source/release-notes/Percona-Server-5.5.16-22.0.rst (+2/-2)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug955266-5.5
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) Approve
Review via email: mp+99520@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/management/innodb_lru_dump_restore.rst'
--- doc/source/management/innodb_lru_dump_restore.rst 2012-03-16 10:41:48 +0000
+++ doc/source/management/innodb_lru_dump_restore.rst 2012-03-27 13:30:23 +0000
@@ -19,7 +19,6 @@
1919
20After finishing the restore operation, the thread switches into dump mode, to periodically dump the LRU. The period is specified by the configuration variable's value in seconds. For example, if you set the variable to 60, then the thread saves the LRU list once per minute.20After finishing the restore operation, the thread switches into dump mode, to periodically dump the LRU. The period is specified by the configuration variable's value in seconds. For example, if you set the variable to 60, then the thread saves the LRU list once per minute.
2121
22
23Manual Operation22Manual Operation
24================23================
2524
@@ -91,7 +90,6 @@
9190
92The requested number of pages is the number of pages that were in the LRU dump file. A page might not be read if it is already in the buffer pool, or for some other miscellaneous reasons, so the number of pages read can be less than the number requested.91The requested number of pages is the number of pages that were in the LRU dump file. A page might not be read if it is already in the buffer pool, or for some other miscellaneous reasons, so the number of pages read can be less than the number requested.
9392
94
95Implementation Details93Implementation Details
96======================94======================
9795
@@ -102,6 +100,12 @@
102The dump file is not deleted after loading, so you should delete it if you wish to disable the feature. For example, suppose you dump the LRU, and then some time later you decide to enable automatic dumping and reloading. You set the configuration variable and restart |MySQL|. Upon restart, the server will load the LRU to its state in the previously saved file, which might be very stale and not what you want to happen.100The dump file is not deleted after loading, so you should delete it if you wish to disable the feature. For example, suppose you dump the LRU, and then some time later you decide to enable automatic dumping and reloading. You set the configuration variable and restart |MySQL|. Upon restart, the server will load the LRU to its state in the previously saved file, which might be very stale and not what you want to happen.
103101
104102
103Block Startup until LRU dump is loaded
104=======================================
105
106|Percona Server| provides a boolean option to block the start of XtraDB until LRU is preloaded from dump. When the variable :variable:`innodb_blocking_buffer_pool_restore` is set to ON, XtraDB waits until the restore of the dump is completed before reporting successful startup to the server. This variable is OFF by default.
107
108
105Version Specific Information109Version Specific Information
106============================110============================
107111
@@ -129,6 +133,21 @@
129133
130 This variable was renamed to :variable:`innodb_buffer_pool_restore_at_startup`, beginning in release 5.5.10-20.1. It still exists as :variable:`innodb_auto_lru_dump` in versions prior to that.134 This variable was renamed to :variable:`innodb_buffer_pool_restore_at_startup`, beginning in release 5.5.10-20.1. It still exists as :variable:`innodb_auto_lru_dump` in versions prior to that.
131135
136
137.. variable:: innodb_blocking_buffer_pool_restore
138
139 :version 5.5.16-22.0: Added
140 :cli: Yes
141 :conf: Yes
142 :scope: Global
143 :dyn: No
144 :vartype: Boolean
145 :default: OFF
146 :range: ON/OFF
147
148When this variable is set to ON XtraDB waits until the restore of the dump is completed before reporting successful startup to the server.
149
150
132.. variable:: innodb_buffer_pool_restore_at_startup151.. variable:: innodb_buffer_pool_restore_at_startup
133152
134 :version 5.5.10-20.1: Added.153 :version 5.5.10-20.1: Added.
135154
=== modified file 'doc/source/release-notes/Percona-Server-5.5.16-22.0.rst'
--- doc/source/release-notes/Percona-Server-5.5.16-22.0.rst 2011-10-24 11:15:33 +0000
+++ doc/source/release-notes/Percona-Server-5.5.16-22.0.rst 2012-03-27 13:30:23 +0000
@@ -18,7 +18,7 @@
1818
19Using this approach, support for Fake Changes have been implemented in order to remove the overhead and make it faster.19Using this approach, support for Fake Changes have been implemented in order to remove the overhead and make it faster.
2020
21By reading the rows for “INSERT“, “UPDATE“ and “DELETE“ statements but not updating them (Fake Changes), the rollback is very fast as in most cases there is nothing to do.21By reading the rows for "INSERT", "UPDATE" and "DELETE" statements but not updating them (Fake Changes), the rollback is very fast as in most cases there is nothing to do.
2222
23Kill Idle Transactions23Kill Idle Transactions
24----------------------24----------------------
@@ -30,7 +30,7 @@
30Block Startup until LRU dump is loaded30Block Startup until LRU dump is loaded
31--------------------------------------31--------------------------------------
3232
33Added a new boolean option, :variable:`innodb-blocking-buffer-pool-restore`, which is ``OFF`` by default. When set to ``ON``, restoring from the LRU dump file is synchronous, i.e. |XtraDB| waits until it is complete before reporting successful startup to the server. Bug Fixed: :bug:`785489` (*Alexey Kopytov*).33Added a new boolean option, :variable:`innodb_blocking_buffer_pool_restore`, which is ``OFF`` by default. When set to ``ON``, restoring from the LRU dump file is synchronous, i.e. |XtraDB| waits until it is complete before reporting successful startup to the server. Bug Fixed: :bug:`785489` (*Alexey Kopytov*).
3434
35Behavior changes35Behavior changes
36----------------36----------------

Subscribers

People subscribed via source and target branches