Merge lp:~hrvojem/percona-server/bug1057031-5.1 into lp:percona-server/5.1
- bug1057031-5.1
- Merge into 5.1
Proposed by
Hrvoje Matijakovic
Status: | Merged | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Approved by: | Stewart Smith | ||||||||||||||||
Approved revision: | no longer in the source branch. | ||||||||||||||||
Merged at revision: | 508 | ||||||||||||||||
Proposed branch: | lp:~hrvojem/percona-server/bug1057031-5.1 | ||||||||||||||||
Merge into: | lp:percona-server/5.1 | ||||||||||||||||
Diff against target: |
753 lines (+55/-181) 36 files modified
doc/source/development.rst (+4/-4) doc/source/diagnostics/innodb_deadlock_count.rst (+1/-1) doc/source/diagnostics/mysql_syslog.rst (+1/-1) doc/source/diagnostics/process_list.rst (+0/-25) doc/source/diagnostics/response_time_distribution.rst (+3/-3) doc/source/diagnostics/show_engines.rst (+1/-1) doc/source/diagnostics/slow_extended.rst (+2/-14) doc/source/flexibility/buff_read_ahead_area.rst (+1/-1) doc/source/flexibility/innodb_fast_shutdown.rst (+1/-1) doc/source/flexibility/log_warnings_suppress.rst (+3/-33) doc/source/flexibility/mysql_remove_eol_carret.rst (+1/-1) doc/source/flexibility/mysqlbinlog_change_db.rst (+1/-1) doc/source/flexibility/replication_skip_single_statement.rst (+1/-1) doc/source/index.rst (+1/-2) doc/source/installation.rst (+1/-1) doc/source/management/changed_page_tracking.rst (+1/-1) doc/source/management/innodb_buffer_pool_shm.rst (+3/-3) doc/source/management/innodb_expand_import.rst (+3/-22) doc/source/management/innodb_extended_fast_index_creation.rst (+1/-1) doc/source/management/innodb_fast_index_creation.rst (+2/-2) doc/source/management/innodb_fast_index_renaming.rst (+0/-38) doc/source/management/innodb_lru_dump_restore.rst (+1/-1) doc/source/management/sql_no_fcache.rst (+1/-1) doc/source/management/udf_maatkit.rst (+1/-1) doc/source/performance/handlersocket.rst (+1/-1) doc/source/performance/innodb_doublewrite_path.rst (+3/-3) doc/source/performance/innodb_lazy_drop_table.rst (+3/-3) doc/source/performance/innodb_purge_thread.rst (+2/-2) doc/source/performance/remove_fcntl_excessive_calls.rst (+1/-1) doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst (+1/-1) doc/source/reliability/crash_resistant_replication.rst (+1/-1) doc/source/reliability/error_pad.rst (+1/-1) doc/source/reliability/log_connection_error.rst (+1/-1) doc/source/reliability/show_slave_status_nolock.rst (+1/-2) doc/source/scalability/innodb_extra_rseg.rst (+3/-3) doc/source/scalability/innodb_io.rst (+2/-2) |
||||||||||||||||
To merge this branch: | bzr merge lp:~hrvojem/percona-server/bug1057031-5.1 | ||||||||||||||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Stewart Smith (community) | Approve | ||
Review via email: mp+139694@code.launchpad.net |
Commit message
Description of the change
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
1 | === modified file 'doc/source/development.rst' | |||
2 | --- doc/source/development.rst 2012-01-27 11:37:42 +0000 | |||
3 | +++ doc/source/development.rst 2012-12-13 13:30:28 +0000 | |||
4 | @@ -19,7 +19,7 @@ | |||
5 | 19 | 19 | ||
6 | 20 | Overview | 20 | Overview |
7 | 21 | ~~~~~~~~ | 21 | ~~~~~~~~ |
9 | 22 | At Percona we use `Bazaar <http://www.bazaar-vcs.org>`_ for source | 22 | At Percona we use `Bazaar <http://bazaar.canonical.com/en/>`_ for source |
10 | 23 | control and `launchpad <http://www.launchpad.net>`_ for both | 23 | control and `launchpad <http://www.launchpad.net>`_ for both |
11 | 24 | code hosting and release management. | 24 | code hosting and release management. |
12 | 25 | 25 | ||
13 | @@ -205,7 +205,7 @@ | |||
14 | 205 | Percona Xtrabackup | 205 | Percona Xtrabackup |
15 | 206 | ~~~~~~~~~~~~~~~~~~ | 206 | ~~~~~~~~~~~~~~~~~~ |
16 | 207 | 207 | ||
18 | 208 | `<http://jenkins.percona.com/view/Percona%20Xtrabackup/>`_ | 208 | `<http://jenkins.percona.com/view/XtraBackup/>`_ |
19 | 209 | 209 | ||
20 | 210 | We currently build both xtrabackup 1.6 and xtrabackup trunk (will become 1.7). | 210 | We currently build both xtrabackup 1.6 and xtrabackup trunk (will become 1.7). |
21 | 211 | 211 | ||
22 | @@ -221,14 +221,14 @@ | |||
23 | 221 | Percona Server 5.1 | 221 | Percona Server 5.1 |
24 | 222 | ------------------ | 222 | ------------------ |
25 | 223 | 223 | ||
27 | 224 | `<http://jenkins.percona.com/view/Percona%20Server%205.1/>`_ | 224 | `<http://jenkins.percona.com/view/PS%205.1/>`_ |
28 | 225 | 225 | ||
29 | 226 | We have trunk and param jobs. We also have a valgrind job that will run after a successful trunk build. | 226 | We have trunk and param jobs. We also have a valgrind job that will run after a successful trunk build. |
30 | 227 | 227 | ||
31 | 228 | Percona Server 5.5 | 228 | Percona Server 5.5 |
32 | 229 | ------------------ | 229 | ------------------ |
33 | 230 | 230 | ||
35 | 231 | `<http://jenkins.percona.com/view/Percona%20Server%205.5/>`_ | 231 | `<http://jenkins.percona.com/view/PS%205.5/>`_ |
36 | 232 | 232 | ||
37 | 233 | Similar to 5.1, but for PS5.5 instead. | 233 | Similar to 5.1, but for PS5.5 instead. |
38 | 234 | 234 | ||
39 | 235 | 235 | ||
40 | === modified file 'doc/source/diagnostics/innodb_deadlock_count.rst' | |||
41 | --- doc/source/diagnostics/innodb_deadlock_count.rst 2011-10-07 00:55:06 +0000 | |||
42 | +++ doc/source/diagnostics/innodb_deadlock_count.rst 2012-12-13 13:30:28 +0000 | |||
43 | @@ -36,7 +36,7 @@ | |||
44 | 36 | Version Specific Information | 36 | Version Specific Information |
45 | 37 | ============================ | 37 | ============================ |
46 | 38 | 38 | ||
48 | 39 | * 5.1.47-11.0: | 39 | * :rn:`5.1.47-rel11.1`: |
49 | 40 | Full functionality available. | 40 | Full functionality available. |
50 | 41 | 41 | ||
51 | 42 | Status Variables | 42 | Status Variables |
52 | 43 | 43 | ||
53 | === modified file 'doc/source/diagnostics/mysql_syslog.rst' | |||
54 | --- doc/source/diagnostics/mysql_syslog.rst 2012-05-29 18:31:23 +0000 | |||
55 | +++ doc/source/diagnostics/mysql_syslog.rst 2012-12-13 13:30:28 +0000 | |||
56 | @@ -10,7 +10,7 @@ | |||
57 | 10 | Version Specific Information | 10 | Version Specific Information |
58 | 11 | ============================ | 11 | ============================ |
59 | 12 | 12 | ||
61 | 13 | * 5.1.49-12.0: | 13 | * :rn:`5.1.49-rel12.0`: |
62 | 14 | Full functionality available. | 14 | Full functionality available. |
63 | 15 | 15 | ||
64 | 16 | Other Information | 16 | Other Information |
65 | 17 | 17 | ||
66 | === modified file 'doc/source/diagnostics/process_list.rst' | |||
67 | --- doc/source/diagnostics/process_list.rst 2011-10-07 00:55:06 +0000 | |||
68 | +++ doc/source/diagnostics/process_list.rst 2012-12-13 13:30:28 +0000 | |||
69 | @@ -6,29 +6,6 @@ | |||
70 | 6 | 6 | ||
71 | 7 | This page describes Percona changes to both the standard |MySQL| ``SHOW PROCESSLIST`` command and the standard |MySQL| ``INFORMATION_SCHEMA`` table ``PROCESSLIST``. | 7 | This page describes Percona changes to both the standard |MySQL| ``SHOW PROCESSLIST`` command and the standard |MySQL| ``INFORMATION_SCHEMA`` table ``PROCESSLIST``. |
72 | 8 | 8 | ||
73 | 9 | The changes that have been made as of version 5.5 of the server are: | ||
74 | 10 | |||
75 | 11 | * ``SHOW PROCESSLIST`` command: | ||
76 | 12 | |||
77 | 13 | * added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` | ||
78 | 14 | |||
79 | 15 | * ``PROCESSLIST`` table: | ||
80 | 16 | |||
81 | 17 | * added columns ``TIME_MS``, ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` | ||
82 | 18 | |||
83 | 19 | Version Specific Information | ||
84 | 20 | ============================ | ||
85 | 21 | |||
86 | 22 | * 5.0.91-22: | ||
87 | 23 | |||
88 | 24 | * Added column ``TIME_MS`` to table ``PROCESSLIST``. | ||
89 | 25 | |||
90 | 26 | * 5.5.10-20.1: | ||
91 | 27 | |||
92 | 28 | * Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` to ``SHOW PROCESSLIST`` command. | ||
93 | 29 | |||
94 | 30 | * Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` to table ``PROCESSLIST``. | ||
95 | 31 | |||
96 | 32 | INFORMATION_SCHEMA Tables | 9 | INFORMATION_SCHEMA Tables |
97 | 33 | ========================= | 10 | ========================= |
98 | 34 | 11 | ||
99 | @@ -48,8 +25,6 @@ | |||
100 | 48 | :column ROWS_EXAMINED: The number of rows examined by the statement being executed. | 25 | :column ROWS_EXAMINED: The number of rows examined by the statement being executed. |
101 | 49 | :column ROWS_SENT: The number of rows sent by the statement being executed. | 26 | :column ROWS_SENT: The number of rows sent by the statement being executed. |
102 | 50 | :column ROWS_READ: The number of rows read by the statement being executed. | 27 | :column ROWS_READ: The number of rows read by the statement being executed. |
103 | 51 | :version 5.0.91-22: Added column ``TIME_MS`` | ||
104 | 52 | :version 5.5.10-20.1: Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` | ||
105 | 53 | 28 | ||
106 | 54 | 29 | ||
107 | 55 | Example Output | 30 | Example Output |
108 | 56 | 31 | ||
109 | === modified file 'doc/source/diagnostics/response_time_distribution.rst' | |||
110 | --- doc/source/diagnostics/response_time_distribution.rst 2012-12-10 14:01:11 +0000 | |||
111 | +++ doc/source/diagnostics/response_time_distribution.rst 2012-12-13 13:30:28 +0000 | |||
112 | @@ -193,10 +193,10 @@ | |||
113 | 193 | Version Specific Information | 193 | Version Specific Information |
114 | 194 | ============================ | 194 | ============================ |
115 | 195 | 195 | ||
117 | 196 | * 5.1.49-12.0: | 196 | * :rn:`5.1.49-rel12.0`: |
118 | 197 | Full functionality available. | 197 | Full functionality available. |
119 | 198 | 198 | ||
121 | 199 | * 5.1.53-12.4: | 199 | * :rn:`5.1.53-12.4`: |
122 | 200 | Introduced :variable:`have_response_time_distribution`. | 200 | Introduced :variable:`have_response_time_distribution`. |
123 | 201 | 201 | ||
124 | 202 | System Variables | 202 | System Variables |
125 | @@ -232,7 +232,7 @@ | |||
126 | 232 | 232 | ||
127 | 233 | .. variable:: enable_query_response_time_stats | 233 | .. variable:: enable_query_response_time_stats |
128 | 234 | 234 | ||
130 | 235 | :version 5.1.49-12.0: Introduced. | 235 | :version 5.1.49-rel12.0: Introduced. |
131 | 236 | :cli: Yes | 236 | :cli: Yes |
132 | 237 | :conf: Yes | 237 | :conf: Yes |
133 | 238 | :scope: Global | 238 | :scope: Global |
134 | 239 | 239 | ||
135 | === modified file 'doc/source/diagnostics/show_engines.rst' | |||
136 | --- doc/source/diagnostics/show_engines.rst 2011-10-07 00:55:06 +0000 | |||
137 | +++ doc/source/diagnostics/show_engines.rst 2012-12-13 13:30:28 +0000 | |||
138 | @@ -29,7 +29,7 @@ | |||
139 | 29 | Version-Specific Information | 29 | Version-Specific Information |
140 | 30 | ============================ | 30 | ============================ |
141 | 31 | 31 | ||
143 | 32 | * 5.1.49-12.0: | 32 | * :rn:`5.1.49-rel12.0`: |
144 | 33 | Full functionality available. | 33 | Full functionality available. |
145 | 34 | 34 | ||
146 | 35 | Other Information | 35 | Other Information |
147 | 36 | 36 | ||
148 | === modified file 'doc/source/diagnostics/slow_extended.rst' | |||
149 | --- doc/source/diagnostics/slow_extended.rst 2012-09-17 07:36:57 +0000 | |||
150 | +++ doc/source/diagnostics/slow_extended.rst 2012-12-13 13:30:28 +0000 | |||
151 | @@ -8,20 +8,12 @@ | |||
152 | 8 | 8 | ||
153 | 9 | The ability to log queries with microsecond precision is essential for measuring the work the |MySQL| server performs. The standard slow query log in |MySQL| 5.0 has only 1-second granularity, which is too coarse for all but the slowest queries. |MySQL| 5.1 has microsecond resolution, but does not have the extra information about query execution that is included in the |Percona Server|. | 9 | The ability to log queries with microsecond precision is essential for measuring the work the |MySQL| server performs. The standard slow query log in |MySQL| 5.0 has only 1-second granularity, which is too coarse for all but the slowest queries. |MySQL| 5.1 has microsecond resolution, but does not have the extra information about query execution that is included in the |Percona Server|. |
154 | 10 | 10 | ||
156 | 11 | You can use *Percona Toolkit* 's ''mk-query-digest'' tool to aggregate similar queries together and report on those that consume the most execution time. | 11 | You can use *Percona Toolkit*'s ''pt-query-digest'' tool to aggregate similar queries together and report on those that consume the most execution time. |
157 | 12 | 12 | ||
158 | 13 | 13 | ||
159 | 14 | Version Specific Information | 14 | Version Specific Information |
160 | 15 | ============================ | 15 | ============================ |
161 | 16 | 16 | ||
162 | 17 | * ``4.1.x``: | ||
163 | 18 | |||
164 | 19 | * Limited functionality available: only microsecond resolution, no added statistics. | ||
165 | 20 | |||
166 | 21 | * ``5.0.x``: | ||
167 | 22 | |||
168 | 23 | * Full functionality available. | ||
169 | 24 | |||
170 | 25 | * ``5.1.x``: | 17 | * ``5.1.x``: |
171 | 26 | 18 | ||
172 | 27 | * Microsecond resolution included in official |MySQL| server; this feature adds statistics. | 19 | * Microsecond resolution included in official |MySQL| server; this feature adds statistics. |
173 | @@ -34,7 +26,7 @@ | |||
174 | 34 | 26 | ||
175 | 35 | * Full functionality of :variable:`use_global_log_slow_control` available. | 27 | * Full functionality of :variable:`use_global_log_slow_control` available. |
176 | 36 | 28 | ||
178 | 37 | * Fixed :bug:`600684` - :variable:`log_slow_verbosity` ``=iInnodb`` doesn't work on slave (statement-based replication) | 29 | * Fixed :bug:`600684` - :variable:`log_slow_verbosity` ``=Innodb`` doesn't work on slave (statement-based replication) |
179 | 38 | 30 | ||
180 | 39 | * :rn:`5.1.53-11.7`: | 31 | * :rn:`5.1.53-11.7`: |
181 | 40 | 32 | ||
182 | @@ -134,16 +126,12 @@ | |||
183 | 134 | 126 | ||
184 | 135 | If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time. | 127 | If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time. |
185 | 136 | 128 | ||
186 | 137 | **NOTE:** This variable has been renamed to :variable:`slow_query_log_timestamp_always` since :rn:`5.5.10-20.1`. | ||
187 | 138 | |||
188 | 139 | |||
189 | 140 | .. variable:: log_slow_verbosity | 129 | .. variable:: log_slow_verbosity |
190 | 141 | 130 | ||
191 | 142 | :cli: Yes | 131 | :cli: Yes |
192 | 143 | :conf: Yes | 132 | :conf: Yes |
193 | 144 | :scope: Global, session | 133 | :scope: Global, session |
194 | 145 | :dyn: Yes | 134 | :dyn: Yes |
195 | 146 | :version 5.5.8-20.0: Added ``profiling`` and ``profiling_use_getrusage`` | ||
196 | 147 | 135 | ||
197 | 148 | Specifies how much information to include in your slow log. The value is a comma-delimited string, and can contain any combination of the following values: | 136 | Specifies how much information to include in your slow log. The value is a comma-delimited string, and can contain any combination of the following values: |
198 | 149 | 137 | ||
199 | 150 | 138 | ||
200 | === modified file 'doc/source/flexibility/buff_read_ahead_area.rst' | |||
201 | --- doc/source/flexibility/buff_read_ahead_area.rst 2012-06-13 10:52:23 +0000 | |||
202 | +++ doc/source/flexibility/buff_read_ahead_area.rst 2012-12-13 13:30:28 +0000 | |||
203 | @@ -18,7 +18,7 @@ | |||
204 | 18 | Version Specific Information | 18 | Version Specific Information |
205 | 19 | ============================ | 19 | ============================ |
206 | 20 | 20 | ||
208 | 21 | * :rn:`5.1.47-12.0` : | 21 | * :rn:`5.1.49-rel12.0` : |
209 | 22 | Full functionality available. | 22 | Full functionality available. |
210 | 23 | 23 | ||
211 | 24 | Other Information | 24 | Other Information |
212 | 25 | 25 | ||
213 | === modified file 'doc/source/flexibility/innodb_fast_shutdown.rst' | |||
214 | --- doc/source/flexibility/innodb_fast_shutdown.rst 2011-10-07 00:55:06 +0000 | |||
215 | +++ doc/source/flexibility/innodb_fast_shutdown.rst 2012-12-13 13:30:28 +0000 | |||
216 | @@ -15,7 +15,7 @@ | |||
217 | 15 | Version Specific Information | 15 | Version Specific Information |
218 | 16 | ============================ | 16 | ============================ |
219 | 17 | 17 | ||
221 | 18 | * 5.1.52-12.3: | 18 | * :rn:`5.1.52-12.3` |
222 | 19 | Full functionality available. | 19 | Full functionality available. |
223 | 20 | 20 | ||
224 | 21 | Other Information | 21 | Other Information |
225 | 22 | 22 | ||
226 | === modified file 'doc/source/flexibility/log_warnings_suppress.rst' | |||
227 | --- doc/source/flexibility/log_warnings_suppress.rst 2011-10-07 00:55:06 +0000 | |||
228 | +++ doc/source/flexibility/log_warnings_suppress.rst 2012-12-13 13:30:28 +0000 | |||
229 | @@ -10,22 +10,15 @@ | |||
230 | 10 | Version Specific Information | 10 | Version Specific Information |
231 | 11 | ============================ | 11 | ============================ |
232 | 12 | 12 | ||
234 | 13 | * 5.1.47-11.0: | 13 | * :rn:`5.1.47-rel11.1` |
235 | 14 | System variable :variable:`suppress_log_warning_1592` introduced. | 14 | System variable :variable:`suppress_log_warning_1592` introduced. |
236 | 15 | 15 | ||
237 | 16 | * 5.5.8-20.0: | ||
238 | 17 | System variable :variable:`suppress_log_warning_1592` replaced by :variable:`log_warnings_silence`. | ||
239 | 18 | |||
240 | 19 | * 5.5.10-20.1: | ||
241 | 20 | Renamed variable :variable:`log_warnings_silence` to :variable:`log_warnings_suppress`. | ||
242 | 21 | |||
243 | 22 | System Variables | 16 | System Variables |
244 | 23 | ================ | 17 | ================ |
245 | 24 | 18 | ||
246 | 25 | .. variable:: suppress_log_warning_1592 | 19 | .. variable:: suppress_log_warning_1592 |
247 | 26 | 20 | ||
250 | 27 | :version 5.1.47-11.0: Introduced. | 21 | :version 5.1.47-rel11.1: Introduced. |
249 | 28 | :version 5.5.8-20.0: Deleted. | ||
251 | 29 | :cli: Yes | 22 | :cli: Yes |
252 | 30 | :conf: Yes | 23 | :conf: Yes |
253 | 31 | :scope: Global | 24 | :scope: Global |
254 | @@ -46,33 +39,10 @@ | |||
255 | 46 | 39 | ||
256 | 47 | 090213 16:58:54 [Warning] Statement is not safe to log in statement format. | 40 | 090213 16:58:54 [Warning] Statement is not safe to log in statement format. |
257 | 48 | 41 | ||
258 | 49 | This variable was obsoleted, beginning in release :rn:`5.5.8-20.0`. It still exists in versions :rn:`5.1.47-11.0` to :rn:`5.1.54-12.5`. | ||
259 | 50 | |||
260 | 51 | .. variable:: log_warnings_suppress | ||
261 | 52 | |||
262 | 53 | :version 5.5.8-20.0: Introduced. | ||
263 | 54 | :version 5.5.10-20.1: Renamed. | ||
264 | 55 | :cli: Yes | ||
265 | 56 | :conf: Yes | ||
266 | 57 | :scope: Global | ||
267 | 58 | :dyn: Yes | ||
268 | 59 | :vartype: SET | ||
269 | 60 | :default: ``(empty string)`` | ||
270 | 61 | :range: ``(empty string)``, ``1592`` | ||
271 | 62 | |||
272 | 63 | This variable was added in beta release ``5.5.8-20.0`` as :variable:`log_warnings_silence` and renamed in release 5.5.10-20.1. | ||
273 | 64 | |||
274 | 65 | It is intended to provide a more general mechanism for disabling warnings than existed previously with variable suppress_log_warning_1592. | ||
275 | 66 | |||
276 | 67 | When set to the empty string, no warnings are disabled. When set to ``1592``, warning #1592 messages (unsafe statement for binary logging) are suppressed. | ||
277 | 68 | |||
278 | 69 | In the future, the ability to optionally disable additional warnings may also be added. | ||
279 | 70 | |||
280 | 71 | |||
281 | 72 | Related Reading | 42 | Related Reading |
282 | 73 | =============== | 43 | =============== |
283 | 74 | 44 | ||
285 | 75 | * `MySQL bug 42851 <http://bugs.mysql.com/bug.php?id=42851>`_ | 45 | * `MySQL bug #42851 <http://bugs.mysql.com/bug.php?id=42851>`_ |
286 | 76 | 46 | ||
287 | 77 | * `MySQL InnoDB replication <http://dev.mysql.com/doc/refman/5.1/en/innodb-and-mysql-replication.html>`_ | 47 | * `MySQL InnoDB replication <http://dev.mysql.com/doc/refman/5.1/en/innodb-and-mysql-replication.html>`_ |
288 | 78 | 48 | ||
289 | 79 | 49 | ||
290 | === modified file 'doc/source/flexibility/mysql_remove_eol_carret.rst' | |||
291 | --- doc/source/flexibility/mysql_remove_eol_carret.rst 2011-10-07 00:55:06 +0000 | |||
292 | +++ doc/source/flexibility/mysql_remove_eol_carret.rst 2012-12-13 13:30:28 +0000 | |||
293 | @@ -14,7 +14,7 @@ | |||
294 | 14 | Version Specific Information | 14 | Version Specific Information |
295 | 15 | ============================ | 15 | ============================ |
296 | 16 | 16 | ||
298 | 17 | * 5.1.50-12.1: | 17 | * :rn:`5.1.50-rel12.1` |
299 | 18 | Full functionality. | 18 | Full functionality. |
300 | 19 | 19 | ||
301 | 20 | Client Command Line Parameter | 20 | Client Command Line Parameter |
302 | 21 | 21 | ||
303 | === modified file 'doc/source/flexibility/mysqlbinlog_change_db.rst' | |||
304 | --- doc/source/flexibility/mysqlbinlog_change_db.rst 2012-05-17 11:21:21 +0000 | |||
305 | +++ doc/source/flexibility/mysqlbinlog_change_db.rst 2012-12-13 13:30:28 +0000 | |||
306 | @@ -66,7 +66,7 @@ | |||
307 | 66 | Version Specific Information | 66 | Version Specific Information |
308 | 67 | ============================ | 67 | ============================ |
309 | 68 | 68 | ||
311 | 69 | * 5.1.62-13.3 | 69 | * :rn:`5.1.62-13.3` |
312 | 70 | Full functionality. | 70 | Full functionality. |
313 | 71 | 71 | ||
314 | 72 | Client Command Line Parameter | 72 | Client Command Line Parameter |
315 | 73 | 73 | ||
316 | === modified file 'doc/source/flexibility/replication_skip_single_statement.rst' | |||
317 | --- doc/source/flexibility/replication_skip_single_statement.rst 2011-10-07 00:55:06 +0000 | |||
318 | +++ doc/source/flexibility/replication_skip_single_statement.rst 2012-12-13 13:30:28 +0000 | |||
319 | @@ -25,7 +25,7 @@ | |||
320 | 25 | Version Specific Information | 25 | Version Specific Information |
321 | 26 | ============================ | 26 | ============================ |
322 | 27 | 27 | ||
324 | 28 | * 5.1.49-12.0: | 28 | * :rn:`5.1.49-rel12.0` |
325 | 29 | Full functionality released. | 29 | Full functionality released. |
326 | 30 | 30 | ||
327 | 31 | System Variables | 31 | System Variables |
328 | 32 | 32 | ||
329 | === modified file 'doc/source/index.rst' | |||
330 | --- doc/source/index.rst 2012-12-10 14:01:11 +0000 | |||
331 | +++ doc/source/index.rst 2012-12-13 13:30:28 +0000 | |||
332 | @@ -103,7 +103,7 @@ | |||
333 | 103 | reliability/log_connection_error | 103 | reliability/log_connection_error |
334 | 104 | reliability/error_pad | 104 | reliability/error_pad |
335 | 105 | reliability/innodb_corrupt_table_action | 105 | reliability/innodb_corrupt_table_action |
337 | 106 | reliability/innodb_recovery_update_relay_log | 106 | reliability/crash_resistant_replication |
338 | 107 | reliability/show_slave_status_nolock | 107 | reliability/show_slave_status_nolock |
339 | 108 | 108 | ||
340 | 109 | Management Improvements | 109 | Management Improvements |
341 | @@ -120,7 +120,6 @@ | |||
342 | 120 | management/innodb_lru_dump_restore | 120 | management/innodb_lru_dump_restore |
343 | 121 | management/innodb_fast_index_creation | 121 | management/innodb_fast_index_creation |
344 | 122 | management/innodb_extended_fast_index_creation | 122 | management/innodb_extended_fast_index_creation |
345 | 123 | management/innodb_fast_index_renaming | ||
346 | 124 | management/sql_no_fcache | 123 | management/sql_no_fcache |
347 | 125 | management/udf_maatkit | 124 | management/udf_maatkit |
348 | 126 | management/innodb_fake_changes | 125 | management/innodb_fake_changes |
349 | 127 | 126 | ||
350 | === modified file 'doc/source/installation.rst' | |||
351 | --- doc/source/installation.rst 2012-01-09 04:30:56 +0000 | |||
352 | +++ doc/source/installation.rst 2012-12-13 13:30:28 +0000 | |||
353 | @@ -170,7 +170,7 @@ | |||
354 | 170 | Installing |Percona Server| from the Bazaar Source Tree | 170 | Installing |Percona Server| from the Bazaar Source Tree |
355 | 171 | ======================================================== | 171 | ======================================================== |
356 | 172 | 172 | ||
358 | 173 | Percona uses the `Bazaar <http://www.bazaar-vcs.org>`_ revision | 173 | Percona uses the `Bazaar <http://bazaar.canonical.com/en/>`_ revision |
359 | 174 | control system for development. To build the latest Percona Server | 174 | control system for development. To build the latest Percona Server |
360 | 175 | from the source tree you will need Bazaar installed on your system. | 175 | from the source tree you will need Bazaar installed on your system. |
361 | 176 | 176 | ||
362 | 177 | 177 | ||
363 | === modified file 'doc/source/management/changed_page_tracking.rst' | |||
364 | --- doc/source/management/changed_page_tracking.rst 2012-09-03 09:31:43 +0000 | |||
365 | +++ doc/source/management/changed_page_tracking.rst 2012-12-13 13:30:28 +0000 | |||
366 | @@ -35,7 +35,7 @@ | |||
367 | 35 | .. variable:: innodb_track_changed_pages | 35 | .. variable:: innodb_track_changed_pages |
368 | 36 | 36 | ||
369 | 37 | :version 5.1.65-14.0: Variable introduced | 37 | :version 5.1.65-14.0: Variable introduced |
371 | 38 | :cli: No | 38 | :cli: Yes |
372 | 39 | :conf: Yes | 39 | :conf: Yes |
373 | 40 | :scope: Global | 40 | :scope: Global |
374 | 41 | :dyn: No | 41 | :dyn: No |
375 | 42 | 42 | ||
376 | === modified file 'doc/source/management/innodb_buffer_pool_shm.rst' | |||
377 | --- doc/source/management/innodb_buffer_pool_shm.rst 2011-10-07 00:55:06 +0000 | |||
378 | +++ doc/source/management/innodb_buffer_pool_shm.rst 2012-12-13 13:30:28 +0000 | |||
379 | @@ -17,12 +17,12 @@ | |||
380 | 17 | Version Specific Information | 17 | Version Specific Information |
381 | 18 | ============================ | 18 | ============================ |
382 | 19 | 19 | ||
384 | 20 | * 5.1.49-12.0: | 20 | * :rn:`5.1.49-rel12.0` |
385 | 21 | Feature introduced. | 21 | Feature introduced. |
386 | 22 | 22 | ||
388 | 23 | * 5.1.50-12.1: | 23 | * :rn:`5.1.50-rel12.1` |
389 | 24 | System variable :variable:`innodb_buffer_pool_shm_checksum` added. | 24 | System variable :variable:`innodb_buffer_pool_shm_checksum` added. |
390 | 25 | 25 | ||
392 | 26 | * 5.1.58-12.9: | 26 | * :rn:`5.1.58-12.9` |
393 | 27 | Feature removed, as LRU Dump/Restore is less invasive, more | 27 | Feature removed, as LRU Dump/Restore is less invasive, more |
394 | 28 | reliable and a better solution. | 28 | reliable and a better solution. |
395 | 29 | 29 | ||
396 | === modified file 'doc/source/management/innodb_expand_import.rst' | |||
397 | --- doc/source/management/innodb_expand_import.rst 2012-06-13 10:52:23 +0000 | |||
398 | +++ doc/source/management/innodb_expand_import.rst 2012-12-13 13:30:28 +0000 | |||
399 | @@ -74,15 +74,15 @@ | |||
400 | 74 | Version Specific Information | 74 | Version Specific Information |
401 | 75 | ============================ | 75 | ============================ |
402 | 76 | 76 | ||
405 | 77 | * 5.5.10-20.1: | 77 | * :rn:`5.1.50-rel12.1` |
406 | 78 | Renamed variable :variable:`innodb_expand_import` to :variable:`innodb_import_table_from_xtrabackup`. | 78 | Introduced variable :variable:`innodb_expand_import`. |
407 | 79 | 79 | ||
408 | 80 | System Variables | 80 | System Variables |
409 | 81 | ================ | 81 | ================ |
410 | 82 | 82 | ||
411 | 83 | .. variable:: innodb_expand_import | 83 | .. variable:: innodb_expand_import |
412 | 84 | 84 | ||
414 | 85 | :version 5.5.10-20.1: Renamed. | 85 | :version 5.1.50-rel12.1: Introduced |
415 | 86 | :cli: Yes | 86 | :cli: Yes |
416 | 87 | :conf: Yes | 87 | :conf: Yes |
417 | 88 | :scope: Global | 88 | :scope: Global |
418 | @@ -93,25 +93,6 @@ | |||
419 | 93 | 93 | ||
420 | 94 | If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in ``.exp`` file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command). | 94 | If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in ``.exp`` file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command). |
421 | 95 | 95 | ||
422 | 96 | This variable was renamed to :variable:`innodb_import_table_from_xtrabackup`, beginning in release 5.5.10-20.1. It still exists as :variable:`innodb_expand_import` in versions prior to that. | ||
423 | 97 | |||
424 | 98 | |||
425 | 99 | .. variable:: innodb_import_table_from_xtrabackup | ||
426 | 100 | |||
427 | 101 | :version 5.5.10-20.1: Introduced. | ||
428 | 102 | :cli: Yes | ||
429 | 103 | :conf: Yes | ||
430 | 104 | :scope: Global | ||
431 | 105 | :dyn: Yes | ||
432 | 106 | :vartype: ULONG | ||
433 | 107 | :default: 0 | ||
434 | 108 | :range: 0-1 | ||
435 | 109 | |||
436 | 110 | If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in .exp file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command). | ||
437 | 111 | |||
438 | 112 | This variable was added in release 5.5.10-20.1. Prior to that, it was named :variable:`innodb_expand_import`, which still exists in earlier versions. | ||
439 | 113 | |||
440 | 114 | |||
441 | 115 | .. Other Information | 96 | .. Other Information |
442 | 116 | 97 | ||
443 | 117 | 98 | ||
444 | 118 | 99 | ||
445 | === modified file 'doc/source/management/innodb_extended_fast_index_creation.rst' | |||
446 | --- doc/source/management/innodb_extended_fast_index_creation.rst 2012-01-30 16:43:47 +0000 | |||
447 | +++ doc/source/management/innodb_extended_fast_index_creation.rst 2012-12-13 13:30:28 +0000 | |||
448 | @@ -58,7 +58,7 @@ | |||
449 | 58 | Version Specific Information | 58 | Version Specific Information |
450 | 59 | ============================ | 59 | ============================ |
451 | 60 | 60 | ||
453 | 61 | * 5.1.59-13.0 | 61 | * :rn:`5.1.59-13.0`: |
454 | 62 | Variable :variable:`expand_fast_index_creation` implemented. | 62 | Variable :variable:`expand_fast_index_creation` implemented. |
455 | 63 | This variable controls whether fast index creation optimizations made by Perocna are used. | 63 | This variable controls whether fast index creation optimizations made by Perocna are used. |
456 | 64 | 64 | ||
457 | 65 | 65 | ||
458 | === modified file 'doc/source/management/innodb_fast_index_creation.rst' | |||
459 | --- doc/source/management/innodb_fast_index_creation.rst 2012-07-12 08:48:23 +0000 | |||
460 | +++ doc/source/management/innodb_fast_index_creation.rst 2012-12-13 13:30:28 +0000 | |||
461 | @@ -23,10 +23,10 @@ | |||
462 | 23 | Version Specific Information | 23 | Version Specific Information |
463 | 24 | ============================ | 24 | ============================ |
464 | 25 | 25 | ||
466 | 26 | * 5.1.49-12.0: | 26 | * :rn:`5.1.49-rel12.0`: |
467 | 27 | Variable :variable:`fast_index_creation` implemented. | 27 | Variable :variable:`fast_index_creation` implemented. |
468 | 28 | 28 | ||
470 | 29 | * 5.1.56-12.7, 5.5.11-21.2: | 29 | * :rn:`5.1.56-12.7`: |
471 | 30 | Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``. | 30 | Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``. |
472 | 31 | 31 | ||
473 | 32 | 32 | ||
474 | 33 | 33 | ||
475 | === removed file 'doc/source/management/innodb_fast_index_renaming.rst' | |||
476 | --- doc/source/management/innodb_fast_index_renaming.rst 2011-10-07 00:55:06 +0000 | |||
477 | +++ doc/source/management/innodb_fast_index_renaming.rst 1970-01-01 00:00:00 +0000 | |||
478 | @@ -1,38 +0,0 @@ | |||
479 | 1 | .. _innodb_fast_index_renaming: | ||
480 | 2 | |||
481 | 3 | ===================== | ||
482 | 4 | Fast Index Renaming | ||
483 | 5 | ===================== | ||
484 | 6 | |||
485 | 7 | This feature provides a way to have a fast (online) way to rename an index without rebuilding the whole table. It does this by adding a ``RENAME INDEX`` clause to the ``ALTER TABLE`` statement: :: | ||
486 | 8 | |||
487 | 9 | ALTER TABLE ... RENAME INDEX xxx TO yyy; | ||
488 | 10 | |||
489 | 11 | Several limitations exist: | ||
490 | 12 | |||
491 | 13 | * The ``RENAME INDEX`` clause cannot be used with any other type of clause. If it is, an error message is displayed and an error code returned. | ||
492 | 14 | |||
493 | 15 | * The ``RENAME INDEX`` clause can only be used when MyISAM or XtraDB is the storage engine. Otherwise, an error message will be displayed: ``wrong for the engine 'engine name'``. | ||
494 | 16 | |||
495 | 17 | * Use of a partitioned table is not allowed. If ``ALTER TABLE`` is applied to a partitioned table, an error will occur. | ||
496 | 18 | |||
497 | 19 | * If use of the ``RENAME INDEX`` clause results in an XtraDB error, an inconsistency between the index name in MySQL and Percona Server with XtraDB may occur. | ||
498 | 20 | |||
499 | 21 | Errors like ``duplicate key name`` or ``key name not found`` are not caused by ``RENAME INDEX``. These errors occur before processing of the ``RENAME INDEX`` clause occurs. So they don't cause an inconsistency problem. | ||
500 | 22 | |||
501 | 23 | An internally reserved InnoDB name (e.g., ``GEN_CLUST_INDEX``) cannot be used as an index name. If one is, an error is reported. | ||
502 | 24 | |||
503 | 25 | If any error is returned by the ``ALTER TABLE`` command due to the ``RENAME INDEX`` clause, the best way to resolve the problem is to re-create the table. | ||
504 | 26 | |||
505 | 27 | |||
506 | 28 | Version Specific Information | ||
507 | 29 | ============================ | ||
508 | 30 | |||
509 | 31 | * 5.1.49-12.0: | ||
510 | 32 | Not yet released externally | ||
511 | 33 | |||
512 | 34 | Error Codes | ||
513 | 35 | =========== | ||
514 | 36 | |||
515 | 37 | * ``error_er_wrong_usage``: | ||
516 | 38 | Incorrect usage of %s and %s | ||
517 | 39 | 0 | ||
518 | === modified file 'doc/source/management/innodb_lru_dump_restore.rst' | |||
519 | --- doc/source/management/innodb_lru_dump_restore.rst 2012-12-10 14:01:11 +0000 | |||
520 | +++ doc/source/management/innodb_lru_dump_restore.rst 2012-12-13 13:30:28 +0000 | |||
521 | @@ -15,7 +15,7 @@ | |||
522 | 15 | Automatic Operation | 15 | Automatic Operation |
523 | 16 | =================== | 16 | =================== |
524 | 17 | 17 | ||
526 | 18 | To perform dump/restore of the buffer pool automatically, set the :variable:`innodb_lru_dump_restore` configuration variable. A non-zero value for this variable causes the server to create a new thread at startup. This thread's first task is to read and sort the saved file, and then restore the LRU accordingly. | 18 | To perform dump/restore of the buffer pool automatically, set the :variable:`innodb_auto_lru_dump` configuration variable. A non-zero value for this variable causes the server to create a new thread at startup. This thread's first task is to read and sort the saved file, and then restore the LRU accordingly. |
527 | 19 | 19 | ||
528 | 20 | After 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. | 20 | After 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. |
529 | 21 | 21 | ||
530 | 22 | 22 | ||
531 | === modified file 'doc/source/management/sql_no_fcache.rst' | |||
532 | --- doc/source/management/sql_no_fcache.rst 2011-10-07 00:55:06 +0000 | |||
533 | +++ doc/source/management/sql_no_fcache.rst 2012-12-13 13:30:28 +0000 | |||
534 | @@ -18,7 +18,7 @@ | |||
535 | 18 | Version-Specific Information | 18 | Version-Specific Information |
536 | 19 | ============================ | 19 | ============================ |
537 | 20 | 20 | ||
539 | 21 | * 5.1.49-12.0: | 21 | * :rn:`5.1.49-rel12.0`: |
540 | 22 | Full functionality available. | 22 | Full functionality available. |
541 | 23 | 23 | ||
542 | 24 | Other Information | 24 | Other Information |
543 | 25 | 25 | ||
544 | === modified file 'doc/source/management/udf_maatkit.rst' | |||
545 | --- doc/source/management/udf_maatkit.rst 2011-10-07 00:55:06 +0000 | |||
546 | +++ doc/source/management/udf_maatkit.rst 2012-12-13 13:30:28 +0000 | |||
547 | @@ -15,7 +15,7 @@ | |||
548 | 15 | Version Specific Information | 15 | Version Specific Information |
549 | 16 | ============================ | 16 | ============================ |
550 | 17 | 17 | ||
552 | 18 | * 5.1.53-12.4: | 18 | * :rn:`5.1.53-12.4`: |
553 | 19 | Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``. | 19 | Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``. |
554 | 20 | 20 | ||
555 | 21 | Other Information | 21 | Other Information |
556 | 22 | 22 | ||
557 | === modified file 'doc/source/performance/handlersocket.rst' | |||
558 | --- doc/source/performance/handlersocket.rst 2011-10-07 00:55:06 +0000 | |||
559 | +++ doc/source/performance/handlersocket.rst 2012-12-13 13:30:28 +0000 | |||
560 | @@ -19,7 +19,7 @@ | |||
561 | 19 | Version Specific Information | 19 | Version Specific Information |
562 | 20 | ============================ | 20 | ============================ |
563 | 21 | 21 | ||
565 | 22 | * 5.1.52-12.3 | 22 | * :rn:`5.1.52-12.3` |
566 | 23 | Full functionality available. | 23 | Full functionality available. |
567 | 24 | 24 | ||
568 | 25 | Other Information | 25 | Other Information |
569 | 26 | 26 | ||
570 | === modified file 'doc/source/performance/innodb_doublewrite_path.rst' | |||
571 | --- doc/source/performance/innodb_doublewrite_path.rst 2011-10-07 00:55:06 +0000 | |||
572 | +++ doc/source/performance/innodb_doublewrite_path.rst 2012-12-13 13:30:28 +0000 | |||
573 | @@ -50,16 +50,16 @@ | |||
574 | 50 | 50 | ||
575 | 51 | Basically if you want to improve the I/O activity, you will put the doublewrite buffer on a different disk. But is it better on an SSD or a more traditional HDD? First you should note that pages are written in a circular fashion in the doublewrite buffer and only read on recovery. So the doublewrite buffer performs mostly sequential writes and a few sequential reads. Second HDDs are very good at sequential write if a write cache is enabled, which is not the case of SSDs. Therefore you should choose a fast HDD if you want to see performance benefits from this option. For instance, you could place the redo logs (also written in a sequential way) and the doublewrite buffer on the same disk. | 51 | Basically if you want to improve the I/O activity, you will put the doublewrite buffer on a different disk. But is it better on an SSD or a more traditional HDD? First you should note that pages are written in a circular fashion in the doublewrite buffer and only read on recovery. So the doublewrite buffer performs mostly sequential writes and a few sequential reads. Second HDDs are very good at sequential write if a write cache is enabled, which is not the case of SSDs. Therefore you should choose a fast HDD if you want to see performance benefits from this option. For instance, you could place the redo logs (also written in a sequential way) and the doublewrite buffer on the same disk. |
576 | 52 | 52 | ||
578 | 53 | Prior to release 5.1.53-12.4, it was necessary to recreate your database and |InnoDB| system files when a dedicated file to contain the doublewrite buffer was specified. Beginning with release 5.1.53-12.4, you no longer need to do this. | 53 | Prior to release :rn:`5.1.53-12.4`, it was necessary to recreate your database and |InnoDB| system files when a dedicated file to contain the doublewrite buffer was specified. Beginning with release 5.1.53-12.4, you no longer need to do this. |
579 | 54 | 54 | ||
580 | 55 | 55 | ||
581 | 56 | Version Specific Information | 56 | Version Specific Information |
582 | 57 | ============================ | 57 | ============================ |
583 | 58 | 58 | ||
585 | 59 | * 5.1.47-11.0 | 59 | * :rn:`5.1.47-rel11.1` |
586 | 60 | Full functionality available. | 60 | Full functionality available. |
587 | 61 | 61 | ||
589 | 62 | * 5.1.53-12.4 | 62 | * :rn:`5.1.53-12.4` |
590 | 63 | Rebuild of database and system files no longer necessary. | 63 | Rebuild of database and system files no longer necessary. |
591 | 64 | 64 | ||
592 | 65 | System Variables | 65 | System Variables |
593 | 66 | 66 | ||
594 | === modified file 'doc/source/performance/innodb_lazy_drop_table.rst' | |||
595 | --- doc/source/performance/innodb_lazy_drop_table.rst 2012-01-27 11:37:42 +0000 | |||
596 | +++ doc/source/performance/innodb_lazy_drop_table.rst 2012-12-13 13:30:28 +0000 | |||
597 | @@ -4,14 +4,14 @@ | |||
598 | 4 | Drop table performance | 4 | Drop table performance |
599 | 5 | ====================== | 5 | ====================== |
600 | 6 | 6 | ||
602 | 7 | When *innodb_file_per_table* is set to 1, doing a DROP TABLE can take a long time on servers with a large buffer pool, even on an empty |InnoDB| table. This is because InnoDB has to scan through the buffer pool to purge pages that belong to the corresponding tablespace. Furthermore, no other queries can start while that scan is in progress. | 7 | When :variable:`innodb_file_per_table` is set to 1, doing a ``DROP TABLE`` can take a long time on servers with a large buffer pool, even on an empty |InnoDB| table. This is because InnoDB has to scan through the buffer pool to purge pages that belong to the corresponding tablespace. Furthermore, no other queries can start while that scan is in progress. |
603 | 8 | 8 | ||
604 | 9 | This feature allows you to do "background table drop". | 9 | This feature allows you to do "background table drop". |
605 | 10 | 10 | ||
606 | 11 | Version Specific Information | 11 | Version Specific Information |
607 | 12 | ============================ | 12 | ============================ |
608 | 13 | 13 | ||
610 | 14 | * 5.1.56-12-7 Feature added. | 14 | * :rn:`5.1.56-12.7` Feature added. |
611 | 15 | 15 | ||
612 | 16 | System Variables | 16 | System Variables |
613 | 17 | ================ | 17 | ================ |
614 | @@ -26,7 +26,7 @@ | |||
615 | 26 | :default: FALSE | 26 | :default: FALSE |
616 | 27 | :range: TRUE/FALSE | 27 | :range: TRUE/FALSE |
617 | 28 | 28 | ||
619 | 29 | When this option is ON, XtraDB optimizes that process by only marking the pages corresponding to the tablespace being deleted. It defers the actual work of evicting those pages until it needs to find some free pages in the buffer pool. | 29 | When this option is ON, |XtraDB| optimizes that process by only marking the pages corresponding to the tablespace being deleted. It defers the actual work of evicting those pages until it needs to find some free pages in the buffer pool. |
620 | 30 | 30 | ||
621 | 31 | When this option is OFF, the usual behavior for dropping tables is in effect. | 31 | When this option is OFF, the usual behavior for dropping tables is in effect. |
622 | 32 | 32 | ||
623 | 33 | 33 | ||
624 | === modified file 'doc/source/performance/innodb_purge_thread.rst' | |||
625 | --- doc/source/performance/innodb_purge_thread.rst 2011-10-07 00:55:06 +0000 | |||
626 | +++ doc/source/performance/innodb_purge_thread.rst 2012-12-13 13:30:28 +0000 | |||
627 | @@ -61,6 +61,6 @@ | |||
628 | 61 | 61 | ||
629 | 62 | * `Tuning for heavy writing workloads <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_ | 62 | * `Tuning for heavy writing workloads <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_ |
630 | 63 | 63 | ||
632 | 64 | * `Reasons for run-away main |InnoDB| tablespace <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_ | 64 | * `Reasons for run-away main InnoDB tablespace <http://www.mysqlperformanceblog.com/2010/06/10/reasons-for-run-away-main-innodb-tablespace/>`_ |
633 | 65 | 65 | ||
635 | 66 | * `Purge thread spiral of death <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_ | 66 | * `Purge thread spiral of death <http://www.mysqlperformanceblog.com/2010/06/10/purge-thread-spira-of-death/>`_ |
636 | 67 | 67 | ||
637 | === modified file 'doc/source/performance/remove_fcntl_excessive_calls.rst' | |||
638 | --- doc/source/performance/remove_fcntl_excessive_calls.rst 2012-10-19 10:36:02 +0000 | |||
639 | +++ doc/source/performance/remove_fcntl_excessive_calls.rst 2012-12-13 13:30:28 +0000 | |||
640 | @@ -20,7 +20,7 @@ | |||
641 | 20 | Version Specific Information | 20 | Version Specific Information |
642 | 21 | ============================ | 21 | ============================ |
643 | 22 | 22 | ||
645 | 23 | * :rn:`5.1.49-12.0`: | 23 | * :rn:`5.1.49-rel12.0`: |
646 | 24 | Feature implemented | 24 | Feature implemented |
647 | 25 | * :rn:`5.1.55-12.6`: | 25 | * :rn:`5.1.55-12.6`: |
648 | 26 | Feature updated | 26 | Feature updated |
649 | 27 | 27 | ||
650 | === modified file 'doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst' | |||
651 | --- doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst 2012-10-13 08:58:19 +0000 | |||
652 | +++ doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst 2012-12-13 13:30:28 +0000 | |||
653 | @@ -17,7 +17,7 @@ | |||
654 | 17 | 17 | ||
655 | 18 | * :ref:`innodb_buffer_pool_shm` - Implemented option :variable:`innodb_buffer_pool_shm_checksum`; when enabled, shared memory buffer pool is checksum validated. Bugs fixed: :bug:`643724`, :bug:`649408`, and :bug:`649393`. (*Yasufumi Kinoshita*) | 18 | * :ref:`innodb_buffer_pool_shm` - Implemented option :variable:`innodb_buffer_pool_shm_checksum`; when enabled, shared memory buffer pool is checksum validated. Bugs fixed: :bug:`643724`, :bug:`649408`, and :bug:`649393`. (*Yasufumi Kinoshita*) |
656 | 19 | 19 | ||
658 | 20 | * :ref:`innodb_expand_import_page` - Implemented more exact checking to avoid corruption of the ``.ibd`` file using :variable:`innodb_expand_export`. (*Yasufumi Kinoshita*) | 20 | * :ref:`innodb_expand_import_page` - Implemented more exact checking to avoid corruption of the ``.ibd`` file using :variable:`innodb_expand_import`. (*Yasufumi Kinoshita*) |
659 | 21 | 21 | ||
660 | 22 | * :ref:`mysql_remove_eol_carret` - Implemented a |MySQL| client option to handle end-of-line in BLOB fields differently. Bug fixed: :bug:`625066`. (*Sasha Pachev*) | 22 | * :ref:`mysql_remove_eol_carret` - Implemented a |MySQL| client option to handle end-of-line in BLOB fields differently. Bug fixed: :bug:`625066`. (*Sasha Pachev*) |
661 | 23 | 23 | ||
662 | 24 | 24 | ||
663 | === renamed file 'doc/source/reliability/innodb_recovery_update_relay_log.rst' => 'doc/source/reliability/crash_resistant_replication.rst' | |||
664 | --- doc/source/reliability/innodb_recovery_update_relay_log.rst 2012-06-13 10:52:23 +0000 | |||
665 | +++ doc/source/reliability/crash_resistant_replication.rst 2012-12-13 13:30:28 +0000 | |||
666 | @@ -59,7 +59,7 @@ | |||
667 | 59 | 59 | ||
668 | 60 | .. variable:: innodb_overwrite_relay_log_info | 60 | .. variable:: innodb_overwrite_relay_log_info |
669 | 61 | 61 | ||
671 | 62 | :version 5.5.10-20.1: Renamed. | 62 | :version 1.0.3-4: Introduced |
672 | 63 | :cli: Yes | 63 | :cli: Yes |
673 | 64 | :conf: Yes | 64 | :conf: Yes |
674 | 65 | :scope: Global | 65 | :scope: Global |
675 | 66 | 66 | ||
676 | === modified file 'doc/source/reliability/error_pad.rst' | |||
677 | --- doc/source/reliability/error_pad.rst 2011-10-07 00:55:06 +0000 | |||
678 | +++ doc/source/reliability/error_pad.rst 2012-12-13 13:30:28 +0000 | |||
679 | @@ -51,5 +51,5 @@ | |||
680 | 51 | Version-Specific Information | 51 | Version-Specific Information |
681 | 52 | ============================ | 52 | ============================ |
682 | 53 | 53 | ||
684 | 54 | * 5.1.49-12.0: | 54 | * :rn:`5.1.49-rel12.0` |
685 | 55 | Full functionality available. | 55 | Full functionality available. |
686 | 56 | 56 | ||
687 | === modified file 'doc/source/reliability/log_connection_error.rst' | |||
688 | --- doc/source/reliability/log_connection_error.rst 2011-10-07 00:55:06 +0000 | |||
689 | +++ doc/source/reliability/log_connection_error.rst 2012-12-13 13:30:28 +0000 | |||
690 | @@ -10,5 +10,5 @@ | |||
691 | 10 | Version-Specific Information | 10 | Version-Specific Information |
692 | 11 | ============================ | 11 | ============================ |
693 | 12 | 12 | ||
695 | 13 | * 5.1.49-12.0: | 13 | * :rn:`5.1.49-rel12.0` |
696 | 14 | Full functionality available. | 14 | Full functionality available. |
697 | 15 | 15 | ||
698 | === modified file 'doc/source/reliability/show_slave_status_nolock.rst' | |||
699 | --- doc/source/reliability/show_slave_status_nolock.rst 2012-09-03 09:31:43 +0000 | |||
700 | +++ doc/source/reliability/show_slave_status_nolock.rst 2012-12-13 13:30:28 +0000 | |||
701 | @@ -21,5 +21,4 @@ | |||
702 | 21 | Version Specific Information | 21 | Version Specific Information |
703 | 22 | ============================ | 22 | ============================ |
704 | 23 | 23 | ||
707 | 24 | * 5.1.52-12.3: | 24 | * :rn:`5.1.52-12.3` - Introduced |
706 | 25 | Currently only the source code is distributed; the feature is not included in binaries. | ||
708 | 26 | 25 | ||
709 | === modified file 'doc/source/scalability/innodb_extra_rseg.rst' | |||
710 | --- doc/source/scalability/innodb_extra_rseg.rst 2012-05-29 17:18:20 +0000 | |||
711 | +++ doc/source/scalability/innodb_extra_rseg.rst 2012-12-13 13:30:28 +0000 | |||
712 | @@ -10,7 +10,9 @@ | |||
713 | 10 | 10 | ||
714 | 11 | Some write-intensive workloads on boxes with many CPUs have scalability problems. The contention is caused by the rollback segment, which is single: all transactions are serialized when needing to access the segment. With this feature you can now create and use multiple segments (up to 256). | 11 | Some write-intensive workloads on boxes with many CPUs have scalability problems. The contention is caused by the rollback segment, which is single: all transactions are serialized when needing to access the segment. With this feature you can now create and use multiple segments (up to 256). |
715 | 12 | 12 | ||
717 | 13 | **NOTE**: This feature is incompatible with |InnoDB|. As long as a single rollback segment is used, there is no problem; the database can still be used by both |XtraDB| and |InnoDB|. However, creating multiple rollback segments will cause an internal format change to the system tablespace. Once multiple segments have been created, the database will no longer be compatible with |InnoDB|. | 13 | .. note:: |
718 | 14 | |||
719 | 15 | This feature is incompatible with |InnoDB|. As long as a single rollback segment is used, there is no problem; the database can still be used by both |XtraDB| and |InnoDB|. However, creating multiple rollback segments will cause an internal format change to the system tablespace. Once multiple segments have been created, the database will no longer be compatible with |InnoDB|. | ||
720 | 14 | 16 | ||
721 | 15 | 17 | ||
722 | 16 | System Variables | 18 | System Variables |
723 | @@ -40,8 +42,6 @@ | |||
724 | 40 | 42 | ||
725 | 41 | The result should be the number of extra segments + 1 (as a default single segment always exists). | 43 | The result should be the number of extra segments + 1 (as a default single segment always exists). |
726 | 42 | 44 | ||
727 | 43 | This variable has been removed from |Percona Server| 5.5.11-20.2 because an equivalent variable, ``innodb_rollback_segment``, has been implemented in |MySQL| 5.5. | ||
728 | 44 | |||
729 | 45 | 45 | ||
730 | 46 | ``INFORMATION_SCHEMA`` Tables | 46 | ``INFORMATION_SCHEMA`` Tables |
731 | 47 | ============================= | 47 | ============================= |
732 | 48 | 48 | ||
733 | === modified file 'doc/source/scalability/innodb_io.rst' | |||
734 | --- doc/source/scalability/innodb_io.rst 2012-10-05 10:57:57 +0000 | |||
735 | +++ doc/source/scalability/innodb_io.rst 2012-12-13 13:30:28 +0000 | |||
736 | @@ -36,7 +36,7 @@ | |||
737 | 36 | 36 | ||
738 | 37 | .. variable:: innodb_adaptive_checkpoint | 37 | .. variable:: innodb_adaptive_checkpoint |
739 | 38 | 38 | ||
741 | 39 | :version: 5.1.54-12.5 Added | 39 | :version 5.1.54-12.5: Added |
742 | 40 | :cli: Yes | 40 | :cli: Yes |
743 | 41 | :conf: Yes | 41 | :conf: Yes |
744 | 42 | :scope: Global | 42 | :scope: Global |
745 | @@ -109,7 +109,7 @@ | |||
746 | 109 | 109 | ||
747 | 110 | .. variable:: innodb_flush_log_at_trx_commit_session | 110 | .. variable:: innodb_flush_log_at_trx_commit_session |
748 | 111 | 111 | ||
750 | 112 | :version: 5.1.49-13 Added | 112 | :version 5.1.49-rel11.3: Added |
751 | 113 | :cli: Yes | 113 | :cli: Yes |
752 | 114 | :conf: Yes | 114 | :conf: Yes |
753 | 115 | :scope: Global | 115 | :scope: Global |