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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Stewart Smith
Approved revision: no longer in the source branch.
Merged at revision: 217
Proposed branch: lp:~hrvojem/percona-server/bug930571-5.5
Merge into: lp:percona-server/5.5
Diff against target: 71 lines (+10/-4)
5 files modified
doc/source/index.rst (+1/-0)
doc/source/management/innodb_fake_changes.rst (+6/-1)
doc/source/performance/innodb_fast_checksum.rst (+1/-1)
doc/source/reliability/innodb_recovery_update_relay_log.rst (+1/-1)
doc/source/scalability/innodb_expand_undo_slots.rst (+1/-1)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug930571-5.5
Reviewer Review Type Date Requested Status
Stewart Smith (community) Approve
Review via email: mp+93373@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Stewart Smith (stewart) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst 2012-02-03 10:23:20 +0000
+++ doc/source/index.rst 2012-02-16 10:47:25 +0000
@@ -164,6 +164,7 @@
164 development164 development
165 trademark-policy165 trademark-policy
166 faq166 faq
167 compatibility
167 release-notes/release-notes_index168 release-notes/release-notes_index
168 glossary169 glossary
169170
170171
=== modified file 'doc/source/management/innodb_fake_changes.rst'
--- doc/source/management/innodb_fake_changes.rst 2011-10-14 02:54:42 +0000
+++ doc/source/management/innodb_fake_changes.rst 2012-02-16 10:47:25 +0000
@@ -4,7 +4,7 @@
4 Support for Fake Changes4 Support for Fake Changes
5==========================5==========================
66
7When restarting a slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay statements and then rollback at commit.7Restarting a slave server in a replication environment or setting up new slave server can cause a replication reads slower. This is happening because replication in |MySQL| is single-threaded and because it needs to read the data before it can execute the queries. The process can be speeded up by having prefetch threads to warm the server: replay statements and then rollback at commit.
88
9That makes prefetch simple but has high overhead from locking rows only to undo changes at rollback.9That makes prefetch simple but has high overhead from locking rows only to undo changes at rollback.
1010
@@ -63,3 +63,8 @@
63 * It will not prefetch allocate/free, split/merge, ``INODE``, ``XDES`` or other management pages. The same is for extern pages, i.e. large ``BLOB`` s).63 * It will not prefetch allocate/free, split/merge, ``INODE``, ``XDES`` or other management pages. The same is for extern pages, i.e. large ``BLOB`` s).
6464
65 * Foreign key constraints are checked (for causing IO), but passed always.65 * Foreign key constraints are checked (for causing IO), but passed always.
66
67Related Reading
68===============
69
70 * `on MySQL replication prefetching <http://dom.as/2011/12/03/replication-prefetching/>`_
6671
=== modified file 'doc/source/performance/innodb_fast_checksum.rst'
--- doc/source/performance/innodb_fast_checksum.rst 2011-10-07 23:38:41 +0000
+++ doc/source/performance/innodb_fast_checksum.rst 2012-02-16 10:47:25 +0000
@@ -10,7 +10,7 @@
1010
11The original algorithm is checked after the new one, so you can have data pages with old checksums and data pages with new checksums. However in this case, you may experience slow reads from pages having old checksums. If you want to have the entire benefit of this change, you will need to recreate all your |InnoDB| tables, for instance by dumping and reloading all |InnoDB| tables.11The original algorithm is checked after the new one, so you can have data pages with old checksums and data pages with new checksums. However in this case, you may experience slow reads from pages having old checksums. If you want to have the entire benefit of this change, you will need to recreate all your |InnoDB| tables, for instance by dumping and reloading all |InnoDB| tables.
1212
13Once enabled, turning it off will require table re-creation as well, since it will fail to start on data files created when ``innodb_fast_checksums`` was enabled.13Once enabled, turning it off will require table(s) to be dump/imported, since it will fail to start on data files created when ``innodb_fast_checksums`` was enabled. In this case ALTER TABLE won't work due to its implementation.
1414
1515
16System Variables16System Variables
1717
=== modified file 'doc/source/reliability/innodb_recovery_update_relay_log.rst'
--- doc/source/reliability/innodb_recovery_update_relay_log.rst 2011-10-07 23:38:41 +0000
+++ doc/source/reliability/innodb_recovery_update_relay_log.rst 2012-02-16 10:47:25 +0000
@@ -8,7 +8,7 @@
88
9|MySQL| replication normally stores its position in a file that is neither durable nor consistent. Thus, if the replica crashes, it can re-execute committed transactions. This usually causes replication to fail, potentially forcing the replica``s data to be re-initialized from the master or from a recent backup.9|MySQL| replication normally stores its position in a file that is neither durable nor consistent. Thus, if the replica crashes, it can re-execute committed transactions. This usually causes replication to fail, potentially forcing the replica``s data to be re-initialized from the master or from a recent backup.
1010
11The improvement in |Percona Server| makes |InnoDB| store the replication position transactionally, and overwrite the usual master.info file upon recovery, so replication restarts from the correct position and does not try to re-execute committed transactions. This change greatly improves the durability of |MySQL| replication. It can be set to activate automatically, so replication “just works” and no intervention is necessary after a crash.11The improvement in |Percona Server| makes |InnoDB| store the replication position transactionally, and overwrite the usual relay_log.info file upon recovery, so replication restarts from the correct position and does not try to re-execute committed transactions. This change greatly improves the durability of |MySQL| replication. It can be set to activate automatically, so replication “just works” and no intervention is necessary after a crash.
1212
1313
14Restrictions14Restrictions
1515
=== modified file 'doc/source/scalability/innodb_expand_undo_slots.rst'
--- doc/source/scalability/innodb_expand_undo_slots.rst 2011-10-07 23:38:41 +0000
+++ doc/source/scalability/innodb_expand_undo_slots.rst 2012-02-16 10:47:25 +0000
@@ -4,7 +4,7 @@
4More Concurrent Transactions Available4More Concurrent Transactions Available
5======================================5======================================
66
7|InnoDB| provides a fixed number of 1024 undo slots in its rollback segment, leaving room for 1024 transactions to run in parallel. If all the slots are used any new transaction will fail until a slot is freed, which can cause st:range: behaviors. This change provides a variable to expand the number of undo slots, up to 4072.7|InnoDB| provides a fixed number of 1024 undo slots in its rollback segment, leaving room for 1024 transactions to run in parallel. If all the slots are used any new transaction will fail until a slot is freed, which can cause strange behaviors. This change provides a variable to expand the number of undo slots, up to 4072.
88
9This option is provided for servers that run out of undo slots. Use it if you find the following warning in the error log: ``Warning: cannot find a free slot for an undo log``.9This option is provided for servers that run out of undo slots. Use it if you find the following warning in the error log: ``Warning: cannot find a free slot for an undo log``.
1010

Subscribers

People subscribed via source and target branches