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

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
Merged at revision: 286
Proposed branch: lp:~hrvojem/percona-server/bug1031410-5.5
Merge into: lp:percona-server/5.5
Diff against target: 65 lines (+10/-10)
3 files modified
doc/source/diagnostics/slow_extended_55.rst (+4/-4)
doc/source/reliability/innodb_corrupt_table_action.rst (+1/-1)
doc/source/scalability/innodb_insert_buffer.rst (+5/-5)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1031410-5.5
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+118053@code.launchpad.net
To post a comment you must log in.
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/slow_extended_55.rst'
2--- doc/source/diagnostics/slow_extended_55.rst 2012-06-19 13:40:59 +0000
3+++ doc/source/diagnostics/slow_extended_55.rst 2012-08-03 09:12:26 +0000
4@@ -93,9 +93,9 @@
5 Logging all queries might consume I/O bandwidth and cause the log file to grow large.
6 * When :variable:`log_slow_rate_type` is ``session``, this option lets you log full sessions, so you have complete records of sessions for later analysis; but you can rate-limit the number of sessions that are logged. Note that this feature will not work well if your application uses any type of connection pooling or persistent connections. Note that you change :variable:`log_slow_rate_limit` in ``session`` mode, you should reconnect for get effect.
7
8- * When :variable:`log_slow_rate_type` is ``query``, this option lets you log just some queries for later analysis. For example, if you set the value to 100, then one percona of queryies will logged.
9+ * When :variable:`log_slow_rate_type` is ``query``, this option lets you log just some queries for later analysis. For example, if you set the value to 100, then one percent of queries will be logged.
10
11-Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:``log_slow_rate_limit``.
12+Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`.
13 Decision "log or no" calculated in following manner:
14
15 * if ``log_slow_rate_limit`` is 0 - log every query
16@@ -113,7 +113,7 @@
17 :scope: Global, session
18 :dyn: Yes (in 5.1 releases only)
19
20-Specifies that queries replayed by the slave SQL thread on a |MySQL| slave will be logged. The standard |MySQL| server will not log any queries executed by the slave``s SQL thread.
21+Specifies that queries replayed by the slave SQL thread on a |MySQL| slave will be logged. The standard |MySQL| server will not log any queries executed by the slave's SQL thread.
22
23 To start the logging from the slave thread, you should change the global value: set global :variable:`log_slow_slave_statements` ``=ON``; and then execute: ``STOP SLAVE; START SLAVE;``. This will destroy and recreate the slave SQL thread, so it will see the newly set global value.
24
25@@ -223,7 +223,7 @@
26 :default: None
27 :version 5.5.10-20.1: Introduced (renamed from :variable:`log_slow_timestamp_every`)
28
29-Specifies which variables have global scope instead of local. Value is a “flag” variable - you can specify multiple values separated by commas
30+Specifies which variables have global scope instead of local. Value is a "flag" variable - you can specify multiple values separated by commas
31
32 * ``none``:
33 All variables use local scope
34
35=== modified file 'doc/source/reliability/innodb_corrupt_table_action.rst'
36--- doc/source/reliability/innodb_corrupt_table_action.rst 2012-05-21 12:56:39 +0000
37+++ doc/source/reliability/innodb_corrupt_table_action.rst 2012-08-03 09:12:26 +0000
38@@ -45,6 +45,6 @@
39 :default: ``assert``
40 :range: ``assert``, ``warn``
41
42-Pass corruptions of user tables as ``corrupt table`` instead of not crashing itself, when used with file_per_table. All file I/O for the datafile after detected as corrupt is disabled, except for the deletion.
43+When the default value is used InnoDB will stop the server if it finds a checksum mismatch on the tables. If ``warn`` values is used it will pass corruption of the table as ``corrupt table`` instead of crashing itself. For this to work :option:`innodb_file_per_table` should be enabled. All file I/O for the datafile after detected as corrupt is disabled, except for the deletion.
44
45 This variable was added in release 5.5.10-20.1. Prior to that, it was named :variable:`innodb_pass_corrupt_table`, which still exists in earlier versions.
46
47=== modified file 'doc/source/scalability/innodb_insert_buffer.rst'
48--- doc/source/scalability/innodb_insert_buffer.rst 2012-05-21 12:56:39 +0000
49+++ doc/source/scalability/innodb_insert_buffer.rst 2012-08-03 09:12:26 +0000
50@@ -38,11 +38,11 @@
51 :default: 100
52 :range: 100 - 999999999
53
54-This variable allows better control of the background thread processing the insert buffer. Each time the thread is called, its activity is altered by the value of both ``innodb_io_capacity`` and ``innodb_ibuf_merge_rate`` this way: ::
55-
56- [real activity] = [default activity] * (innodb_io_capacity/100) * (innodb_ibuf_merge_rate/100)
57-
58-By increasing the value of ``innodb_ibuf_merge_rate``, you will increase the insert buffer activity.
59+This variable allows better control of the background thread processing the insert buffer. Each time the thread is called, its activity is altered by the value of both ``innodb_io_capacity`` and ``innodb_ibuf_accel_rate`` this way: ::
60+
61+ [real activity] = [default activity] * (innodb_io_capacity/100) * (innodb_ibuf_accel_rate/100)
62+
63+By increasing the value of :variable:`innodb_ibuf_accel_rate`, you will increase the insert buffer activity.
64
65 .. variable:: innodb_ibuf_max_size
66

Subscribers

People subscribed via source and target branches