Merge lp:~hrvojem/percona-server/doc-28 into lp:percona-server/5.6
- doc-28
- Merge into 5.6
Status: | Merged |
---|---|
Approved by: | Laurynas Biveinis |
Approved revision: | no longer in the source branch. |
Merged at revision: | 375 |
Proposed branch: | lp:~hrvojem/percona-server/doc-28 |
Merge into: | lp:percona-server/5.6 |
Diff against target: |
2374 lines (+751/-859) 35 files modified
doc/source/changed_in_56.rst (+4/-4) doc/source/conf.py (+3/-1) doc/source/diagnostics/innodb_deadlock_count.rst (+1/-1) doc/source/diagnostics/innodb_show_status.rst (+135/-164) doc/source/diagnostics/misc_info_schema_tables.rst (+40/-0) doc/source/diagnostics/mysql_syslog.rst (+2/-2) doc/source/diagnostics/show_engines.rst (+1/-7) doc/source/diagnostics/slow_extended.rst (+355/-0) doc/source/diagnostics/slow_extended_55.rst (+0/-377) doc/source/diagnostics/thread_based_profiling.rst (+2/-2) doc/source/diagnostics/user_stats.rst (+5/-5) doc/source/flexibility/buff_read_ahead_area.rst (+0/-36) doc/source/flexibility/innodb_files_extend.rst (+0/-25) doc/source/flexibility/log_warnings_suppress.rst (+3/-11) doc/source/flexibility/max_binlog_files.rst (+2/-2) doc/source/index.rst (+18/-4) doc/source/index_info_schema_tables.rst (+8/-36) doc/source/installation.rst (+1/-1) doc/source/management/changed_page_tracking.rst (+4/-5) doc/source/management/enforce_engine.rst (+1/-1) doc/source/management/expanded_program_option_modifiers.rst (+1/-1) doc/source/management/innodb_fake_changes.rst (+12/-2) doc/source/management/innodb_fast_index_creation.rst (+0/-63) doc/source/management/innodb_kill_idle_trx.rst (+1/-1) doc/source/management/pam_plugin.rst (+1/-1) doc/source/management/secure_file_priv_extended.rst (+1/-1) doc/source/management/udf_maatkit.rst (+0/-49) doc/source/management/udf_percona_toolkit.rst (+54/-0) doc/source/management/utility_user.rst (+4/-4) doc/source/performance/innodb_numa_support.rst (+1/-1) doc/source/performance/query_cache_enhance.rst (+8/-42) doc/source/reliability/error_pad.rst (+6/-6) doc/source/reliability/log_connection_error.rst (+2/-2) doc/source/reliability/show_slave_status_nolock.rst (+4/-2) doc/source/scalability/innodb_io.rst (+71/-0) |
To merge this branch: | bzr merge lp:~hrvojem/percona-server/doc-28 |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email: mp+166285@code.launchpad.net |
Commit message
Description of the change
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- the list of status variables itself does not look updated?
i.e. AFAIK it should not have 1 or 10 second loops one but
should have some new ones like background or active loops.
- innodb_
the other changes under version-specific change list.
- doc/source/
redundant, it should be fully replaced by the upstream
features, so it needs upgrade documentation.
- innodb_stats_method is an upstream feature.
- other variables do not exist.
- INNODB_SYS_TABLES, INNODB_
different too IIRC.
- doc/source/
- Maciej is no longer with Percona
- No need to document upstream variables
- The log entry example is outdated, i.e. rows_read: is not
there anymore, needs updating to the actual current output.
- The profiling one too.
- doc/source/
- 5.6.11 changes: "Feature ported from PS 5.5"
- doc/source/
- XTRADB_
tables do not exist?
- doc/source/
"
default. ... "
- doc/source/
ported to 5.6.
- doc/source/
Server|."
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- Line 59: bug 29123/29126 conflict, probably in the lower
versions as well.
- Line 102: should be fixed in lower versions as well?
- Line 702: can be removed (also from 5.5 too I guess).
- doc/source/
ported to 5.6.
- Where are innodb_
Should I report the lower version issues separately?
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
- innodb_io.rst: innodb_
innodb_
ported. innodb_
(replaced in upstream). That leaves ported status vars,
innodb_
innodb_
needs updating, it doesn't seem to have received any since 5.0,
i.e. "Note that some of these parameters are already available
in the |InnoDB| plugin." should be removed, the rest rewritten
perhaps.
Laurynas Biveinis (laurynas-biveinis) : | # |
Stewart Smith (stewart) wrote : | # |
Hrvoje Matijakovic <email address hidden> writes:
> - * 5.5.8-20.0:
> + * :rn:`5.6.11-60.3`:
I wonder if we should keep the 5.5 introduction number in the 5.6 docs
too (perhaps as well as the 5.6 introduction version).
--
Stewart Smith
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
Stewart -
What would be the advantage? The 5.5 docs are there too. I'd prefer to have only 5.6 versions in 5.6, I think I already asked Hrvoje to remove the 5.5 versions earlier
Stewart Smith (stewart) wrote : | # |
Laurynas Biveinis <email address hidden> writes:
> What would be the advantage? The 5.5 docs are there too. I'd prefer to
> have only 5.6 versions in 5.6, I think I already asked Hrvoje to
> remove the 5.5 versions earlier
I guess it's fine either way....
--
Stewart Smith
Preview Diff
1 | === modified file 'doc/source/changed_in_56.rst' |
2 | --- doc/source/changed_in_56.rst 2013-05-10 13:29:38 +0000 |
3 | +++ doc/source/changed_in_56.rst 2013-06-03 10:03:31 +0000 |
4 | @@ -10,15 +10,15 @@ |
5 | |
6 | * `fast_index_creation <http://www.percona.com/doc/percona-server/5.5/management/innodb_fast_index_creation.html>`_ (use MySQL 5.6's ALGORITHM= option instead) |
7 | * `HandlerSocket <http://www.percona.com/doc/percona-server/5.5/performance/handlersocket.html>`_ (may return when HandlerSocket supports MySQL 5.6) |
8 | - * SHOW [GLOBAL] TEMPORARY TABLES functionality is now only available via the INFORMATION_SCHEMA tables TEMPORARY_TABLES and GLOBAL_TEMPORARY_TABLES. |
9 | + * SHOW [GLOBAL] TEMPORARY TABLES functionality is now only available via the INFORMATION_SCHEMA tables :table:`TEMPORARY_TABLES` and :table:`GLOBAL_TEMPORARY_TABLES`. |
10 | * `InnoDB timer-based Concurrency Throttling <http://www.percona.com/doc/percona-server/5.5/performance/innodb_thread_concurrency_timer_based.html>`_ |
11 | * `InnoDB Recovery Stats <http://www.percona.com/doc/percona-server/5.5/management/innodb_recovery_patches.html>`_ |
12 | |
13 | Some features that were present in |Percona Server| 5.5 have been replaced by a different implementation of the same/similar functionality in |Percona Server| 5.6. These are: |
14 | |
15 | - * SHOW INNODB STATUS section "OLDEST VIEW" has been replaced by the XTRADB_READ_VIEW INFORMATION_SCHEMA table. |
16 | - * SHOW INNODB STATUS sections on memory usage for InnoDB/XtraDB hash tables has been replaced by the XTRADB_INTERNAL_HASH_TABLES INFORMATION_SCHEMA table. |
17 | - * The INNODB_RSEG table has been renamed to XTRADB_RSEG |
18 | + * ``SHOW ENGINE INNODB STATUS`` section "OLDEST VIEW" has been replaced by the :table:`XTRADB_READ_VIEW` INFORMATION_SCHEMA table. |
19 | + * ``SHOW ENGINE INNODB STATUS`` sections on memory usage for InnoDB/XtraDB hash tables has been replaced by the :table:`XTRADB_INTERNAL_HASH_TABLES` INFORMATION_SCHEMA table. |
20 | + * The :table:`INNODB_RSEG` table has been renamed to :table:`XTRADB_RSEG`. |
21 | |
22 | Some |Percona Server| 5.5 features have been replaced by similar or equivalent MySQL 5.6 features, so we now keep the MySQL 5.6 implementations in |Percona Server| 5.6. These are: |
23 | |
24 | |
25 | === modified file 'doc/source/conf.py' |
26 | --- doc/source/conf.py 2013-05-27 03:01:29 +0000 |
27 | +++ doc/source/conf.py 2013-06-03 10:03:31 +0000 |
28 | @@ -108,6 +108,8 @@ |
29 | |
30 | .. |XtraBackup| replace:: *XtraBackup* |
31 | |
32 | +.. |Percona XtraBackup| replace:: *Percona XtraBackup* |
33 | + |
34 | .. |Percona Server| replace:: *Percona Server* |
35 | |
36 | .. |Percona| replace:: *Percona* |
37 | @@ -265,6 +267,6 @@ |
38 | intersphinx_mapping = { |
39 | 'ps51' : ('http://www.percona.com/doc/percona-server/5.1/', None), |
40 | 'ps55' : ('http://www.percona.com/doc/percona-server/5.5/', None), |
41 | - 'xtrabackup' : ('http://www.percona.com/doc/percona-xtrabackup', None), |
42 | + 'xtrabackup' : ('http://www.percona.com/doc/percona-xtrabackup/2.1/', None), |
43 | 'ptoolkit' : ('http://www.percona.com/doc/percona-toolkit/2.1/', None) |
44 | } |
45 | |
46 | === modified file 'doc/source/diagnostics/innodb_deadlock_count.rst' |
47 | --- doc/source/diagnostics/innodb_deadlock_count.rst 2013-05-27 13:59:13 +0000 |
48 | +++ doc/source/diagnostics/innodb_deadlock_count.rst 2013-06-03 10:03:31 +0000 |
49 | @@ -36,7 +36,7 @@ |
50 | Version Specific Information |
51 | ============================ |
52 | |
53 | - * 5.5.8-20.0: |
54 | + * :rn:`5.6.11-60.3`: |
55 | Full functionality available. |
56 | |
57 | Status Variables |
58 | |
59 | === modified file 'doc/source/diagnostics/innodb_show_status.rst' |
60 | --- doc/source/diagnostics/innodb_show_status.rst 2013-05-10 09:39:17 +0000 |
61 | +++ doc/source/diagnostics/innodb_show_status.rst 2013-06-03 10:03:31 +0000 |
62 | @@ -1,16 +1,16 @@ |
63 | .. _innodb_show_status: |
64 | |
65 | -====================== |
66 | - Show |InnoDB| Status |
67 | -====================== |
68 | - |
69 | -This feature reorganizes the output of ``SHOW INNODB STATUS`` for a better readability and prints the amount of memory used by the internal hash tables. In addition, new variables are available to control the output. |
70 | - |
71 | -This feature modified the ``SHOW INNODB STATUS`` command as follows: |
72 | +====================================== |
73 | + Extended Show Engine |InnoDB| Status |
74 | +====================================== |
75 | + |
76 | +This feature reorganizes the output of ``SHOW ENGINE INNODB STATUS`` for a better readability and prints the amount of memory used by the internal hash tables. In addition, new variables are available to control the output. |
77 | + |
78 | +This feature modified the ``SHOW ENGINE INNODB STATUS`` command as follows: |
79 | |
80 | * ``TRANSACTION`` section was moved to the end of the output, so that important information is not overlooked when the there is a large amount of it. |
81 | |
82 | - * Added two variables to control ``SHOW INNODB STATUS`` information presented (bugfix for `#29123 <http://bugs.mysql.com/bug.php?id=29126>`_): |
83 | + * Added two variables to control ``SHOW ENGINE INNODB STATUS`` information presented (bugfix for `#29123 <http://bugs.mysql.com/bug.php?id=29123>`_): |
84 | |
85 | * :variable:`innodb_show_verbose_locks` - Whether to show records locked |
86 | |
87 | @@ -18,19 +18,15 @@ |
88 | |
89 | * Added extended information about |InnoDB| internal hash table sizes (in bytes) in the ``BUFFER POOL AND MEMORY`` section; also added buffer pool size in bytes. |
90 | |
91 | - * Added additional LOG section information (beginning in release 5.5.8-20.0). |
92 | + * Added additional LOG section information. |
93 | |
94 | Version Specific Information |
95 | ============================ |
96 | |
97 | - * 5.5.8-20.0 |
98 | - Added status variables showing information from ``SHOW INNODB STATUS``. |
99 | - |
100 | - * 5.5.8-20.0 |
101 | - Added additional information in the LOG section. |
102 | - |
103 | - * 5.5.10-20.1: |
104 | - Renamed status variable :variable:`innodb_row_lock_numbers` to :variable:`innodb_current_row_locks`. |
105 | + * :rn:`5.6.11-60.3`: |
106 | + |
107 | + Feature ported from |Percona Server| 5.5. |
108 | + |
109 | |
110 | Other Information |
111 | ================= |
112 | @@ -52,7 +48,7 @@ |
113 | :default: 0 |
114 | :range: 0 - 1 |
115 | |
116 | -Specifies to show records locked in ``SHOW INNODB STATUS``. The default is 0, which means only the higher-level information about the lock (which table and index is locked, etc.) is printed. If set to 1, then traditional |InnoDB| behavior is enabled: the records that are locked are dumped to the output. |
117 | +Specifies to show records locked in ``SHOW ENGINE INNODB STATUS``. The default is 0, which means only the higher-level information about the lock (which table and index is locked, etc.) is printed. If set to 1, then traditional |InnoDB| behavior is enabled: the records that are locked are dumped to the output. |
118 | |
119 | .. variable:: innodb_show_locks_held |
120 | |
121 | @@ -64,62 +60,44 @@ |
122 | :default: 10 |
123 | :range: 0 - 1000 |
124 | |
125 | -Specifies the number of locks held to print for each |InnoDB| transaction in SHOW INNODB STATUS. |
126 | +Specifies the number of locks held to print for each |InnoDB| transaction in ``SHOW ENGINE INNODB STATUS``. |
127 | |
128 | |
129 | Status Variables |
130 | ================ |
131 | |
132 | -The status variables here contain information available in the output of ``SHOW INNODB STATUS``, organized by the sections ``SHOW INNODB STATUS`` displays. If you are familiar with the output of ``SHOW INNODB STATUS``, you will probably already recognize the information these variables contain. |
133 | +The status variables here contain information available in the output of ``SHOW ENGINE INNODB STATUS``, organized by the sections ``SHOW ENGINE INNODB STATUS`` displays. If you are familiar with the output of ``SHOW ENGINE INNODB STATUS``, you will probably already recognize the information these variables contain. |
134 | |
135 | |
136 | BACKGROUND THREAD |
137 | ----------------- |
138 | |
139 | -The following variables contain information in the BACKGROUND THREAD section of the output from ``SHOW INNODB STATUS``. An example of that output is: |
140 | - |
141 | - Insert an example of BACKGROUND THREAD section output here. |
142 | - |
143 | -.. variable:: innodb_master_thread_1_second_loops |
144 | - |
145 | - :version 5.5.8-20.0: Introduced. |
146 | - :vartype: Numeric |
147 | - :scope: Global |
148 | - |
149 | -.. variable:: innodb_master_thread_10_second_loops |
150 | - |
151 | - :version 5.5.8-20.0: Introduced. |
152 | - :vartype: Numeric |
153 | - :scope: Global |
154 | - |
155 | -.. variable:: innodb_master_thread_background_loops |
156 | - |
157 | - :version 5.5.8-20.0: Introduced. |
158 | - :vartype: Numeric |
159 | - :scope: Global |
160 | - |
161 | -.. variable:: innodb_master_thread_main_flush_loops |
162 | - |
163 | - :version 5.5.8-20.0: Introduced. |
164 | - :vartype: Numeric |
165 | - :scope: Global |
166 | - |
167 | -.. variable:: innodb_master_thread_sleeps |
168 | - |
169 | - :version 5.5.8-20.0: Introduced. |
170 | - :vartype: Numeric |
171 | - :scope: Global |
172 | - |
173 | -.. variable:: innodb_background_log_sync |
174 | - |
175 | - :version 5.5.8-20.0: Introduced. |
176 | - :vartype: Numeric |
177 | - :scope: Global |
178 | +The following variables contain information in the BACKGROUND THREAD section of the output from ``SHOW ENGINE INNODB STATUS``. An example of that output is: :: |
179 | + |
180 | + ----------------- |
181 | + BACKGROUND THREAD |
182 | + ----------------- |
183 | + srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 11844 srv_idle |
184 | + srv_master_thread log flush and writes: 11844 |
185 | + |
186 | + |
187 | +.. variable:: innodb_master_thread_active_loops |
188 | + |
189 | + :version 5.6.11-60.3: Introduced. |
190 | + :vartype: Numeric |
191 | + :scope: Global |
192 | + |
193 | +.. variable:: innodb_master_thread_idle_loops |
194 | + |
195 | + :version 5.6.11-60.3: Introduced. |
196 | + :vartype: Numeric |
197 | + :scope: Global |
198 | + |
199 | |
200 | SEMAPHORES |
201 | ---------- |
202 | |
203 | -The following variables contain information in the SEMAPHORES section of the output from ``SHOW INNODB STATUS``. An example of that output is: :: |
204 | +The following variables contain information in the SEMAPHORES section of the output from ``SHOW ENGINE INNODB STATUS``. An example of that output is: :: |
205 | |
206 | ---------- |
207 | SEMAPHORES |
208 | @@ -131,281 +109,255 @@ |
209 | |
210 | .. variable:: innodb_mutex_os_waits |
211 | |
212 | - :version 5.5.8-20.0: Introduced. |
213 | + :version 5.6.11-60.3: Introduced. |
214 | :vartype: Numeric |
215 | :scope: Global |
216 | |
217 | .. variable:: innodb_mutex_spin_rounds |
218 | |
219 | - :version 5.5.8-20.0: Introduced. |
220 | + :version 5.6.11-60.3: Introduced. |
221 | :vartype: Numeric |
222 | :scope: Global |
223 | |
224 | .. variable:: innodb_mutex_spin_waits |
225 | |
226 | - :version 5.5.8-20.0: Introduced. |
227 | + :version 5.6.11-60.3: Introduced. |
228 | :vartype: Numeric |
229 | :scope: Global |
230 | |
231 | .. variable:: innodb_s_lock_os_waits |
232 | |
233 | - :version 5.5.8-20.0: Introduced. |
234 | + :version 5.6.11-60.3: Introduced. |
235 | :vartype: Numeric |
236 | :scope: Global |
237 | |
238 | .. variable:: innodb_s_lock_spin_rounds |
239 | |
240 | - :version 5.5.8-20.0: Introduced. |
241 | + :version 5.6.11-60.3: Introduced. |
242 | :vartype: Numeric |
243 | :scope: Global |
244 | |
245 | .. variable:: innodb_s_lock_spin_waits |
246 | |
247 | - :version 5.5.8-20.0: Introduced. |
248 | + :version 5.6.11-60.3: Introduced. |
249 | :vartype: Numeric |
250 | :scope: Global |
251 | |
252 | .. variable:: innodb_x_lock_os_waits |
253 | |
254 | - :version 5.5.8-20.0: Introduced. |
255 | + :version 5.6.11-60.3: Introduced. |
256 | :vartype: Numeric |
257 | :scope: Global |
258 | |
259 | .. variable:: innodb_x_lock_spin_rounds |
260 | |
261 | - :version 5.5.8-20.0: Introduced. |
262 | + :version 5.6.11-60.3: Introduced. |
263 | :vartype: Numeric |
264 | :scope: Global |
265 | |
266 | .. variable:: innodb_x_lock_spin_waits |
267 | |
268 | - :version 5.5.8-20.0: Introduced. |
269 | + :version 5.6.11-60.3: Introduced. |
270 | :vartype: Numeric |
271 | :scope: Global |
272 | |
273 | INSERT BUFFER AND ADAPTIVE HASH INDEX |
274 | ------------------------------------- |
275 | |
276 | -The following variables contain information in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output from SHOW |InnoDB| STATUS. An example of that output is: :: |
277 | +The following variables contain information in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the output from ``SHOW ENGINE INNODB STATUS``. An example of that output is: :: |
278 | |
279 | ------------------------------------- |
280 | INSERT BUFFER AND ADAPTIVE HASH INDEX |
281 | ------------------------------------- |
282 | Ibuf: size 1, free list len 6089, seg size 6091, |
283 | 44497 inserts, 44497 merged recs, 8734 merges |
284 | - Hash table size 276707, node heap has 1 buffer(s) |
285 | 0.00 hash searches/s, 0.00 non-hash searches/s |
286 | |
287 | .. variable:: innodb_ibuf_discarded_delete_marks |
288 | |
289 | - :version 5.5.8-20.0: Introduced. |
290 | + :version 5.6.11-60.3: Introduced. |
291 | :vartype: Numeric |
292 | :scope: Global |
293 | |
294 | .. variable:: innodb_ibuf_discarded_deletes |
295 | |
296 | - :version 5.5.8-20.0: Introduced. |
297 | + :version 5.6.11-60.3: Introduced. |
298 | :vartype: Numeric |
299 | :scope: Global |
300 | |
301 | .. variable:: innodb_ibuf_discarded_inserts |
302 | |
303 | - :version 5.5.8-20.0: Introduced. |
304 | + :version 5.6.11-60.3: Introduced. |
305 | :vartype: Numeric |
306 | :scope: Global |
307 | |
308 | .. variable:: innodb_ibuf_free_list |
309 | |
310 | - :version 5.5.8-20.0: Introduced. |
311 | + :version 5.6.11-60.3: Introduced. |
312 | :vartype: Numeric |
313 | :scope: Global |
314 | |
315 | .. variable:: innodb_ibuf_merged_delete_marks |
316 | |
317 | - :version 5.5.8-20.0: Introduced. |
318 | + :version 5.6.11-60.3: Introduced. |
319 | :vartype: Numeric |
320 | :scope: Global |
321 | |
322 | .. variable:: innodb_ibuf_merged_deletes |
323 | |
324 | - :version 5.5.8-20.0: Introduced. |
325 | + :version 5.6.11-60.3: Introduced. |
326 | :vartype: Numeric |
327 | :scope: Global |
328 | |
329 | .. variable:: innodb_ibuf_merged_inserts |
330 | |
331 | - :version 5.5.8-20.0: Introduced. |
332 | + :version 5.6.11-60.3: Introduced. |
333 | :vartype: Numeric |
334 | :scope: Global |
335 | |
336 | .. variable:: innodb_ibuf_merges |
337 | |
338 | - :version 5.5.8-20.0: Introduced. |
339 | + :version 5.6.11-60.3: Introduced. |
340 | :vartype: Numeric |
341 | :scope: Global |
342 | |
343 | .. variable:: innodb_ibuf_segment_size |
344 | |
345 | - :version 5.5.8-20.0: Introduced. |
346 | + :version 5.6.11-60.3: Introduced. |
347 | :vartype: Numeric |
348 | :scope: Global |
349 | |
350 | .. variable:: innodb_ibuf_size |
351 | |
352 | - :version 5.5.8-20.0: Introduced. |
353 | - :vartype: Numeric |
354 | - :scope: Global |
355 | - |
356 | -.. variable:: innodb_adaptive_hash_cells |
357 | - |
358 | - :version 5.5.8-20.0: Introduced. |
359 | - :vartype: Numeric |
360 | - :scope: Global |
361 | - |
362 | -.. variable:: innodb_adaptive_hash_heap_buffers |
363 | - |
364 | - :version 5.5.8-20.0: Introduced. |
365 | - :vartype: Numeric |
366 | - :scope: Global |
367 | - |
368 | -.. variable:: innodb_adaptive_hash_hash_searches |
369 | - |
370 | - :version 5.5.8-20.0: Introduced. |
371 | - :vartype: Numeric |
372 | - :scope: Global |
373 | - |
374 | -.. variable:: innodb_adaptive_hash_non_hash_searches |
375 | - |
376 | - :version 5.5.8-20.0: Introduced. |
377 | + :version 5.6.11-60.3: Introduced. |
378 | :vartype: Numeric |
379 | :scope: Global |
380 | |
381 | LOG |
382 | --- |
383 | |
384 | -The following variables contain information in the LOG section of the output from ``SHOW INNODB STATUS``. An example of that output is: :: |
385 | +The following variables contain information in the LOG section of the output from ``SHOW ENGINE INNODB STATUS``. An example of that output is: :: |
386 | |
387 | - --- |
388 | LOG |
389 | --- |
390 | - Log sequence number 28219393219 |
391 | - Log flushed up to 28219393219 |
392 | - Last checkpoint at 28212583337 |
393 | - Max checkpoint age 7782360 |
394 | - Checkpoint age target 7539162 |
395 | - Modified age 6809882 |
396 | - Checkpoint age 6809882 |
397 | + Log sequence number 10145937666 |
398 | + Log flushed up to 10145937666 |
399 | + Pages flushed up to 10145937666 |
400 | + Last checkpoint at 10145937666 |
401 | + Max checkpoint age 80826164 |
402 | + Checkpoint age target 78300347 |
403 | + Modified age 0 |
404 | + Checkpoint age 0 |
405 | 0 pending log writes, 0 pending chkp writes |
406 | - 8570 log i/o's done, 2000.00 log i/o's/second |
407 | + 9 log i/o's done, 0.00 log i/o's/second |
408 | + Log tracking enabled |
409 | + Log tracked up to 10145937666 |
410 | + Max tracked LSN age 80826164 |
411 | |
412 | .. variable:: innodb_lsn_current |
413 | |
414 | - :version 5.5.8-20.0: Introduced. |
415 | + :version 5.6.11-60.3: Introduced. |
416 | :vartype: Numeric |
417 | :scope: Global |
418 | |
419 | .. variable:: innodb_lsn_flushed |
420 | |
421 | - :version 5.5.8-20.0: Introduced. |
422 | + :version 5.6.11-60.3: Introduced. |
423 | :vartype: Numeric |
424 | :scope: Global |
425 | |
426 | .. variable:: innodb_lsn_last_checkpoint |
427 | |
428 | - :version 5.5.8-20.0: Introduced. |
429 | + :version 5.6.11-60.3: Introduced. |
430 | :vartype: Numeric |
431 | :scope: Global |
432 | |
433 | .. variable:: innodb_checkpoint_age |
434 | |
435 | - :version 5.5.8-20.0: Introduced. |
436 | + :version 5.6.11-60.3: Introduced. |
437 | :vartype: Numeric |
438 | :scope: Global |
439 | |
440 | .. variable:: innodb_checkpoint_max_age |
441 | |
442 | - :version 5.5.8-20.0: Introduced. |
443 | - :vartype: Numeric |
444 | - :scope: Global |
445 | - |
446 | -.. variable:: innodb_checkpoint_target_age |
447 | - |
448 | - :version 5.5.8-20.0: Introduced. |
449 | + :version 5.6.11-60.3: Introduced. |
450 | :vartype: Numeric |
451 | :scope: Global |
452 | |
453 | BUFFER POOL AND MEMORY |
454 | ---------------------- |
455 | |
456 | -The following variables contain information in the BUFFER POOL AND MEMORY section of the output from ``SHOW INNODB STATUS``. An example of that output is: :: |
457 | +The following variables contain information in the BUFFER POOL AND MEMORY section of the output from ``SHOW ENGINE INNODB STATUS``. An example of that output is: :: |
458 | |
459 | ---------------------- |
460 | BUFFER POOL AND MEMORY |
461 | ---------------------- |
462 | - Total memory allocated 137625600; in additional pool allocated 0 |
463 | + Total memory allocated 137363456; in additional pool allocated 0 |
464 | + Total memory allocated by read views 88 |
465 | Internal hash tables (constant factor + variable factor) |
466 | - Adaptive hash index 3774352 (2213656 + 1560696) |
467 | - Page hash 139144 |
468 | - Dictionary cache 629811 (554864 + 74947) |
469 | - File system 83536 (82672 + 864) |
470 | - Lock system 380792 (332872 + 47920) |
471 | - Recovery system 0 (0 + 0) |
472 | - Threads 84040 (82696 + 1344) |
473 | - Dictionary memory allocated 74947 |
474 | - Buffer pool size 8192 |
475 | - Buffer pool size, bytes 134217728 |
476 | - Free buffers 0 |
477 | - Database pages 8095 |
478 | - Old database pages 2968 |
479 | - Modified db pages 5914 |
480 | + Adaptive hash index 2266736 (2213368 + 53368) |
481 | + Page hash 139112 (buffer pool 0 only) |
482 | + Dictionary cache 729463 (554768 + 174695) |
483 | + File system 824800 (812272 + 12528) |
484 | + Lock system 333248 (332872 + 376) |
485 | + Recovery system 0 (0 + 0) |
486 | + Dictionary memory allocated 174695 |
487 | + Buffer pool size 8191 |
488 | + Buffer pool size, bytes 134201344 |
489 | + Free buffers 7481 |
490 | + Database pages 707 |
491 | + Old database pages 280 |
492 | + Modified db pages 0 |
493 | Pending reads 0 |
494 | - Pending writes: LRU 0, flush list 129, single page 0 |
495 | - Pages made young 372084, not young 0 |
496 | - 2546000.00 youngs/s, 0.00 non-youngs/s |
497 | - Pages read 103356, created 154787, written 979572 |
498 | - 469000.00 reads/s, 78000.00 creates/s, 138000.00 writes/s |
499 | - Buffer pool hit rate 994 / 1000, young-making rate 34 / 1000 not 0 / 1000 |
500 | - Pages read ahead 0.00/s, evicted without access 15000.00/s |
501 | + Pending writes: LRU 0, flush list 0 single page 0 |
502 | + Pages made young 0, not young 0 |
503 | + 0.00 youngs/s, 0.00 non-youngs/s |
504 | + Pages read 707, created 0, written 1 |
505 | + 0.00 reads/s, 0.00 creates/s, 0.00 writes/s |
506 | + No buffer pool page gets since the last printout |
507 | + Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s |
508 | + LRU len: 707, unzip_LRU len: 0 |
509 | + |
510 | |
511 | .. variable:: innodb_mem_adaptive_hash |
512 | |
513 | - :version 5.5.8-20.0: Introduced. |
514 | + :version 5.6.11-60.3: Introduced. |
515 | :vartype: Numeric |
516 | :scope: Global |
517 | |
518 | .. variable:: innodb_mem_dictionary |
519 | |
520 | - :version 5.5.8-20.0: Introduced. |
521 | + :version 5.6.11-60.3: Introduced. |
522 | :vartype: Numeric |
523 | :scope: Global |
524 | |
525 | .. variable:: innodb_mem_total |
526 | |
527 | - :version 5.5.8-20.0: Introduced. |
528 | + :version 5.6.11-60.3: Introduced. |
529 | :vartype: Numeric |
530 | :scope: Global |
531 | |
532 | .. variable:: innodb_buffer_pool_pages_LRU_flushed |
533 | |
534 | - :version 5.5.8-20.0: Introduced. |
535 | + :version 5.6.11-60.3: Introduced. |
536 | :vartype: Numeric |
537 | :scope: Global |
538 | |
539 | .. variable:: innodb_buffer_pool_pages_made_not_young |
540 | |
541 | - :version 5.5.8-20.0: Introduced. |
542 | + :version 5.6.11-60.3: Introduced. |
543 | :vartype: Numeric |
544 | :scope: Global |
545 | |
546 | .. variable:: innodb_buffer_pool_pages_made_young |
547 | |
548 | - :version 5.5.8-20.0: Introduced. |
549 | + :version 5.6.11-60.3: Introduced. |
550 | :vartype: Numeric |
551 | :scope: Global |
552 | |
553 | .. variable:: innodb_buffer_pool_pages_old |
554 | |
555 | - :version 5.5.8-20.0: Introduced. |
556 | + :version 5.6.11-60.3: Introduced. |
557 | :vartype: Numeric |
558 | :scope: Global |
559 | |
560 | @@ -427,44 +379,63 @@ |
561 | ---TRANSACTION F561FC, ACTIVE 29 sec, process no 993, OS thread id 140213152769808 updating or deleting |
562 | mysql tables in use 1, locked 1 |
563 | |
564 | + |
565 | .. variable:: innodb_history_list_length |
566 | |
567 | - :version 5.5.8-20.0: Introduced. |
568 | + :version 5.6.11-60.3: Introduced. |
569 | :vartype: Numeric |
570 | :scope: Global |
571 | |
572 | .. variable:: innodb_max_trx_id |
573 | |
574 | - :version 5.5.8-20.0: Introduced. |
575 | + :version 5.6.11-60.3: Introduced. |
576 | :vartype: Numeric |
577 | :scope: Global |
578 | |
579 | .. variable:: innodb_oldest_view_low_limit_trx_id |
580 | |
581 | - :version 5.5.8-20.0: Introduced. |
582 | + :version 5.6.11-60.3: Introduced. |
583 | :vartype: Numeric |
584 | :scope: Global |
585 | |
586 | .. variable:: innodb_purge_trx_id |
587 | |
588 | - :version 5.5.8-20.0: Introduced. |
589 | + :version 5.6.11-60.3: Introduced. |
590 | :vartype: Numeric |
591 | :scope: Global |
592 | |
593 | .. variable:: innodb_purge_undo_no |
594 | |
595 | - :version 5.5.8-20.0: Introduced. |
596 | + :version 5.6.11-60.3: Introduced. |
597 | :vartype: Numeric |
598 | :scope: Global |
599 | |
600 | .. variable:: innodb_current_row_locks |
601 | |
602 | - :version 5.5.8-20.0: Introduced. |
603 | - :version 5.5.10-20.1: Renamed. |
604 | + :version 5.6.11-60.3: Introduced. |
605 | :vartype: Numeric |
606 | :scope: Global |
607 | |
608 | - This variable was named :variable:`innodb_row_lock_numbers` in release 5.5.8-20.0. |
609 | +INFORMATION_SCHEMA Tables |
610 | +========================= |
611 | + |
612 | +The following table contains information about the oldest active transaction in the system. |
613 | + |
614 | +.. table:: INFORMATION_SCHEMA.XTRADB_READ_VIEW |
615 | + |
616 | + :column READ_VIEW_UNDO_NUMBER: |
617 | + :column READ_VIEW_LOW_LIMIT_TRX_NUMBER: This is the highest transactions number at the time the view was created. |
618 | + :column READ_VIEW_UPPER_LIMIT_TRX_ID: This is the highest transactions ID at the time the view was created. This means that it should not see newer transactions with IDs bigger than or equal to that value. |
619 | + :column READ_VIEW_LOW_LIMIT_TRX_ID: This is the latest committed transaction ID at the time the oldest view was created. This means that it should see all transactions with IDs smaller than or equal to that value. |
620 | + |
621 | +The following table contains information about the memory usage for InnoDB/XtraDB hash tables. |
622 | + |
623 | +.. table:: INFORMATION_SCHEMA.XTRADB_INTERNAL_HASH_TABLES |
624 | + |
625 | + :column INTERNAL_HASH_TABLE_NAME: Hash table name |
626 | + :column TOTAL_MEMORY: Total amount of memory |
627 | + :column CONSTANT_MEMORY: Constant memory |
628 | + :column VARIABLE_MEMORY: Variable memory |
629 | |
630 | |
631 | Other reading |
632 | |
633 | === modified file 'doc/source/diagnostics/misc_info_schema_tables.rst' |
634 | --- doc/source/diagnostics/misc_info_schema_tables.rst 2013-05-27 13:59:13 +0000 |
635 | +++ doc/source/diagnostics/misc_info_schema_tables.rst 2013-06-03 10:03:31 +0000 |
636 | @@ -46,3 +46,43 @@ |
637 | :column UPDATE_TIME: Date and time of the latest update of the temporary table |
638 | |
639 | This table holds information on the temporary tables existing for the running connection. |
640 | + |
641 | +Multiple Rollback Segments |
642 | +========================== |
643 | + |
644 | +|Percona Server|, in addition to the upstream multiple rollback segment implementation, provides the additional Information Schema table: INFORMATION_SCHEMA.XTRADB_RSEG. |
645 | + |
646 | +``INFORMATION_SCHEMA`` Tables |
647 | +============================= |
648 | + |
649 | +This feature provides the following table: |
650 | + |
651 | +.. table:: INFORMATION_SCHEMA.XTRADB_RSEG |
652 | + |
653 | + :column rseg_id: rollback segment id |
654 | + :column space_id: space where the segment placed |
655 | + :column zip_size: compressed page size in bytes if compressed otherwise 0 |
656 | + :column page_no: page number of the segment header |
657 | + :column max_size: max size in pages |
658 | + :column curr_size: current size in pages |
659 | + |
660 | +This table shows information about all the rollback segments (the default segment and the extra segments). |
661 | + |
662 | +Here is an example of output with ``innodb_extra_rsegments = 8`` :: |
663 | + |
664 | + mysql> select * from information_schema.innodb_rseg; |
665 | + +---------+----------+----------+---------+------------+-----------+ |
666 | + | rseg_id | space_id | zip_size | page_no | max_size | curr_size | |
667 | + +---------+----------+----------+---------+------------+-----------+ |
668 | + | 0 | 0 | 0 | 6 | 4294967294 | 1 | |
669 | + | 1 | 0 | 0 | 13 | 4294967294 | 2 | |
670 | + | 2 | 0 | 0 | 14 | 4294967294 | 1 | |
671 | + | 3 | 0 | 0 | 15 | 4294967294 | 1 | |
672 | + | 4 | 0 | 0 | 16 | 4294967294 | 1 | |
673 | + | 5 | 0 | 0 | 17 | 4294967294 | 1 | |
674 | + | 6 | 0 | 0 | 18 | 4294967294 | 1 | |
675 | + | 7 | 0 | 0 | 19 | 4294967294 | 1 | |
676 | + | 8 | 0 | 0 | 20 | 4294967294 | 1 | |
677 | + +---------+----------+----------+---------+------------+-----------+ |
678 | + 9 rows in set (0.00 sec) |
679 | + |
680 | |
681 | === modified file 'doc/source/diagnostics/mysql_syslog.rst' |
682 | --- doc/source/diagnostics/mysql_syslog.rst 2013-05-27 13:46:13 +0000 |
683 | +++ doc/source/diagnostics/mysql_syslog.rst 2013-06-03 10:03:31 +0000 |
684 | @@ -9,8 +9,8 @@ |
685 | Version Specific Information |
686 | ============================ |
687 | |
688 | - * :rn:`5.5.8-20.0`: |
689 | - Full functionality available. |
690 | + * :rn:`5.6.11-60.3`: |
691 | + Feature ported from |Percona Server| 5.5. |
692 | |
693 | Other Information |
694 | ================= |
695 | |
696 | === modified file 'doc/source/diagnostics/show_engines.rst' |
697 | --- doc/source/diagnostics/show_engines.rst 2013-05-27 13:59:13 +0000 |
698 | +++ doc/source/diagnostics/show_engines.rst 2013-06-03 10:03:31 +0000 |
699 | @@ -29,12 +29,6 @@ |
700 | Version-Specific Information |
701 | ============================ |
702 | |
703 | - * 5.5.8-20.0: |
704 | + * :rn:`5.6.11-60.3`: |
705 | Full functionality available. |
706 | |
707 | -Other Information |
708 | -================= |
709 | - |
710 | - * Author / Origin: |
711 | - Percona |
712 | - |
713 | |
714 | === added file 'doc/source/diagnostics/slow_extended.rst' |
715 | --- doc/source/diagnostics/slow_extended.rst 1970-01-01 00:00:00 +0000 |
716 | +++ doc/source/diagnostics/slow_extended.rst 2013-06-03 10:03:31 +0000 |
717 | @@ -0,0 +1,355 @@ |
718 | +.. _slow_extended: |
719 | + |
720 | +================ |
721 | + Slow Query Log |
722 | +================ |
723 | + |
724 | +This feature adds microsecond time resolution and additional statistics to the slow query log output. It lets you enable or disable the slow query log at runtime, adds logging for the slave SQL thread, and adds fine-grained control over what and how much to log into the slow query log. |
725 | + |
726 | +You can use *Percona-Toolkit*'s `pt-query-digest <http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html>`_ tool to aggregate similar queries together and report on those that consume the most execution time. |
727 | + |
728 | + |
729 | +Version Specific Information |
730 | +============================ |
731 | + |
732 | + * :rn:`5.6.11-60.3`: |
733 | + |
734 | + * Feature ported from |Percona Server| 5.5. |
735 | + |
736 | +Other Information |
737 | +================= |
738 | + |
739 | + * Author / Origin: |
740 | + Maciej Dobrzanski |
741 | + |
742 | +System Variables |
743 | +================ |
744 | + |
745 | +.. variable:: log_slow_filter |
746 | + |
747 | + :cli: Yes |
748 | + :conf: Yes |
749 | + :scope: Global, Session |
750 | + :dyn: Yes |
751 | + |
752 | +Filters the slow log by the query's execution plan. The value is a comma-delimited string, and can contain any combination of the following values: |
753 | + |
754 | + * ``qc_miss``: |
755 | + The query was not found in the query cache. |
756 | + |
757 | + * ``full_scan``: |
758 | + The query performed a full table scan. |
759 | + |
760 | + * ``full_join``: |
761 | + The query performed a full join (a join without indexes). |
762 | + |
763 | + * ``tmp_table``: |
764 | + The query created an implicit internal temporary table. |
765 | + |
766 | + * ``tmp_table_on_disk``: |
767 | + The query's temporary table was stored on disk. |
768 | + |
769 | + * ``filesort``: |
770 | + The query used a filesort. |
771 | + |
772 | + * ``filesort_on_disk``: |
773 | + The filesort was performed on disk. |
774 | + |
775 | +Values are OR'ed together. If the string is empty, then the filter is disabled. If it is not empty, then queries will only be logged to the slow log if their execution plan matches one of the types of plans present in the filter. |
776 | + |
777 | +For example, to log only queries that perform a full table scan, set the value to ``full_scan``. To log only queries that use on-disk temporary storage for intermediate results, set the value to ``tmp_table_on_disk,filesort_on_disk``. |
778 | + |
779 | +.. variable:: log_slow_rate_type |
780 | + |
781 | + :cli: Yes |
782 | + :conf: Yes |
783 | + :scope: Global |
784 | + :dyn: Yes |
785 | + :vartype: Enumerated |
786 | + :default: ``session`` |
787 | + :range: ``session``, ``query`` |
788 | + |
789 | +Specifies semantic of :variable:`log_slow_rate_limit` - ``session`` or ``query``. |
790 | + |
791 | +.. variable:: log_slow_rate_limit |
792 | + |
793 | + :cli: Yes |
794 | + :conf: Yes |
795 | + :scope: Global, session |
796 | + :dyn: Yes |
797 | + |
798 | +Behavior of this variable depends from :variable:`log_slow_rate_type`. |
799 | + |
800 | +Specifies that only a fraction of ``session/query`` should be logged. Logging is enabled for every nth ``session/query``. By default, n is 1, so logging is enabled for every ``session/query``. Please note: when :variable:`log_slow_rate_type` is ``session`` rate limiting is disabled for the replication thread. |
801 | + |
802 | +Logging all queries might consume I/O bandwidth and cause the log file to grow large. |
803 | + * 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. |
804 | + |
805 | + * 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. |
806 | + |
807 | +Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:`log_slow_rate_limit`. |
808 | +Decision "log or no" calculated in following manner: |
809 | + |
810 | + * if ``log_slow_rate_limit`` is 0 - log every query |
811 | + |
812 | + * If ``log_slow_rate_limit`` > 0 - log query when (``query_id`` % ``log_slow_rate_limit``) is zero. |
813 | + |
814 | +This allows flexible setup logging behavior. |
815 | + |
816 | +For example, if you set the value to 100, then one percent of ``sessions/queries`` will be logged. |
817 | + |
818 | +.. variable:: log_slow_sp_statements |
819 | + |
820 | + :cli: Yes |
821 | + :conf: Yes |
822 | + :scope: Global |
823 | + :dyn: Yes |
824 | + :vartype: Boolean |
825 | + :default: TRUE |
826 | + :range: TRUE/FALSE |
827 | + |
828 | +If ``TRUE``, statements executed by stored procedures are logged to the slow if it is open. |
829 | + |
830 | +.. note:: |
831 | + |
832 | + Support for logging stored procedures doesn't involve triggers, so they won't be logged even if this feature is enabled. |
833 | + |
834 | +.. variable:: log_slow_verbosity |
835 | + |
836 | + :cli: Yes |
837 | + :conf: Yes |
838 | + :scope: Global, session |
839 | + :dyn: Yes |
840 | + |
841 | +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: |
842 | + |
843 | + * ``microtime``: |
844 | + Log queries with microsecond precision. |
845 | + |
846 | + * ``query_plan``: |
847 | + Log information about the query's execution plan. |
848 | + |
849 | + * ``innodb``: |
850 | + Log |InnoDB| statistics. |
851 | + |
852 | + * ``minimal``: |
853 | + Equivalent to enabling just ``microtime``. |
854 | + |
855 | + * ``standard``: |
856 | + Equivalent to enabling ``microtime,innodb``. |
857 | + |
858 | + * ``full``: |
859 | + Equivalent to all other values OR'ed together. |
860 | + |
861 | + * ``profiling``: |
862 | + Enables profiling of all queries in all connections. |
863 | + |
864 | + * ``profiling_use_getrusage``: |
865 | + Enables usage of the getrusage function. |
866 | + |
867 | +Values are OR'ed together. |
868 | + |
869 | +For example, to enable microsecond query timing and |InnoDB| statistics, set this option to ``microtime,innodb`` or ``standard``. To turn all options on, set the option to ``full``. |
870 | + |
871 | +.. variable:: slow_query_log_timestamp_always |
872 | + |
873 | + :cli: Yes |
874 | + :conf: Yes |
875 | + :scope: Global |
876 | + :dyn: Yes |
877 | + :vartype: Boolean |
878 | + :default: FALSE |
879 | + :range: TRUE/FALSE |
880 | + |
881 | +If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time. |
882 | + |
883 | +.. variable:: slow_query_log_timestamp_precision |
884 | + |
885 | + :cli: Yes |
886 | + :conf: Yes |
887 | + :scope: Global |
888 | + :dyn: Yes |
889 | + :vartype: Enumerated |
890 | + :default: ``second`` |
891 | + :range: ``second``, ``microsecond`` |
892 | + |
893 | +Normally, entries to the slow query log are in seconds precision, in this format: :: |
894 | + |
895 | + # Time: 090402 9:23:36 # User@Host: XXX @ XXX [10.X.X.X] |
896 | + |
897 | +If :variable:`slow_query_log_timestamp_precision` ``=microsecond``, entries to the slow query log are in microsecond precision, in this format: :: |
898 | + |
899 | + # Time: 090402 9:23:36.123456 # User@Host: XXX @ XXX [10.X.X.X] |
900 | + |
901 | +.. variable:: slow_query_log_use_global_control |
902 | + |
903 | + :cli: Yes |
904 | + :conf: Yes |
905 | + :scope: Global |
906 | + :dyn: Yes |
907 | + :default: None |
908 | + |
909 | +Specifies which variables have global scope instead of local. Value is a "flag" variable - you can specify multiple values separated by commas |
910 | + |
911 | + * ``none``: |
912 | + All variables use local scope |
913 | + |
914 | + * ``log_slow_filter``: |
915 | + Global variable :variable:`log_slow_filter` has effect (instead of local) |
916 | + |
917 | + * ``log_slow_rate_limit``: |
918 | + Global variable :variable:`log_slow_rate_limit` has effect (instead of local) |
919 | + |
920 | + * ``log_slow_verbosity``: |
921 | + Global variable :variable:`log_slow_verbosity` has effect (instead of local) |
922 | + |
923 | + * ``long_query_time``: |
924 | + Global variable :variable:`long_query_time` has effect (instead of local) |
925 | + |
926 | + * ``min_examined_row_limit``: |
927 | + Global variable ``min_examined_row_limit`` has effect (instead of local) |
928 | + |
929 | + * ``all`` |
930 | + Global variables has effect (instead of local) |
931 | + |
932 | + |
933 | +Other Information |
934 | +================= |
935 | + |
936 | +Changes to the Log Format |
937 | +------------------------- |
938 | + |
939 | +The feature adds more information to the slow log output. Here is a sample log entry: :: |
940 | + |
941 | + # Time: 130601 8:01:06.058915 |
942 | + # User@Host: root[root] @ localhost [] Id: 42 |
943 | + # Schema: imdb Last_errno: 0 Killed: 0 |
944 | + # Query_time: 7.725616 Lock_time: 0.000328 Rows_sent: 4 Rows_examined: 1543720 Rows_affected: 0 |
945 | + # Bytes_sent: 272 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 |
946 | + # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No |
947 | + # Filesort: No Filesort_on_disk: No Merge_passes: 0 |
948 | + SET timestamp=1370073666; |
949 | + SELECT id,title,production_year FROM title WHERE title = 'Bambi'; |
950 | + |
951 | + |
952 | +Another example (:variable:`log_slow_verbosity` ``=profiling``): :: |
953 | + |
954 | + # Time: 130601 8:03:20.700441 |
955 | + # User@Host: root[root] @ localhost [] Id: 43 |
956 | + # Schema: imdb Last_errno: 0 Killed: 0 |
957 | + # Query_time: 7.815071 Lock_time: 0.000261 Rows_sent: 4 Rows_examined: 1543720 Rows_affected: 0 |
958 | + # Bytes_sent: 272 |
959 | + # Profile_starting: 0.000125 Profile_starting_cpu: 0.000120 |
960 | + Profile_checking_permissions: 0.000021 Profile_checking_permissions_cpu: 0.000021 |
961 | + Profile_Opening_tables: 0.000049 Profile_Opening_tables_cpu: 0.000048 Profile_init: 0.000048 |
962 | + Profile_init_cpu: 0.000049 Profile_System_lock: 0.000049 Profile_System_lock_cpu: 0.000048 |
963 | + Profile_optimizing: 0.000024 Profile_optimizing_cpu: 0.000024 Profile_statistics: 0.000036 |
964 | + Profile_statistics_cpu: 0.000037 Profile_preparing: 0.000029 Profile_preparing_cpu: 0.000029 |
965 | + Profile_executing: 0.000012 Profile_executing_cpu: 0.000012 Profile_Sending_data: 7.814583 |
966 | + Profile_Sending_data_cpu: 7.811634 Profile_end: 0.000013 Profile_end_cpu: 0.000012 |
967 | + Profile_query_end: 0.000014 Profile_query_end_cpu: 0.000014 Profile_closing_tables: 0.000023 |
968 | + Profile_closing_tables_cpu: 0.000023 Profile_freeing_items: 0.000051 |
969 | + Profile_freeing_items_cpu: 0.000050 Profile_logging_slow_query: 0.000006 |
970 | + Profile_logging_slow_query_cpu: 0.000006 |
971 | + # Profile_total: 7.815085 Profile_total_cpu: 7.812127 |
972 | + SET timestamp=1370073800; |
973 | + SELECT id,title,production_year FROM title WHERE title = 'Bambi'; |
974 | + |
975 | + |
976 | +Connection and Schema Identifier |
977 | +-------------------------------- |
978 | + |
979 | +Each slow log entry now contains a connection identifier, so you can trace all the queries coming from a single connection. This is the same value that is shown in the Id column in ``SHOW FULL PROCESSLIST`` or returned from the ``CONNECTION_ID()`` function. |
980 | + |
981 | +Each entry also contains a schema name, so you can trace all the queries whose default database was set to a particular schema. :: |
982 | + |
983 | + # Id: 43 Schema: imdb |
984 | + |
985 | +Microsecond Time Resolution and Extra Row Information |
986 | +----------------------------------------------------- |
987 | + |
988 | +This is the original functionality offered by the ``microslow`` feature. ``Query_time`` and ``Lock_time`` are logged with microsecond resolution. |
989 | + |
990 | +The feature also adds information about how many rows were examined for ``SELECT`` queries, and how many were analyzed and affected for ``UPDATE``, ``DELETE``, and ``INSERT`` queries, :: |
991 | + |
992 | + # Query_time: 0.962742 Lock_time: 0.000202 Rows_sent: 4 Rows_examined: 1543719 Rows_affected: 0 |
993 | + |
994 | +Values and context: |
995 | + |
996 | + * ``Rows_examined``: |
997 | + Number of rows scanned - ``SELECT`` |
998 | + |
999 | + * ``Rows_affected``: |
1000 | + Number of rows changed - ``UPDATE``, ``DELETE``, ``INSERT`` |
1001 | + |
1002 | +Memory Footprint |
1003 | +---------------- |
1004 | + |
1005 | +The feature provides information about the amount of bytes sent for the result of the query and the number of temporary tables created for its execution - differentiated by whether they were created on memory or on disk - with the total number of bytes used by them. :: |
1006 | + |
1007 | + # Bytes_sent: 8053 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 950528 |
1008 | + |
1009 | +Values and context: |
1010 | + |
1011 | + * ``Bytes_sent``: |
1012 | + The amount of bytes sent for the result of the query |
1013 | + |
1014 | + * ``Tmp_tables``: |
1015 | + Number of temporary tables created on memory for the query |
1016 | + |
1017 | + * ``Tmp_disk_tables``: |
1018 | + Number of temporary tables created on disk for the query |
1019 | + |
1020 | + * ``Tmp_table_sizes``: |
1021 | + Total Size in bytes for all temporary tables used in the query |
1022 | + |
1023 | + |
1024 | +Query Plan Information |
1025 | +---------------------- |
1026 | + |
1027 | +Each query can be executed in various ways. For example, it may use indexes or do a full table scan, or a temporary table may be needed. These are the things that you can usually see by running ``EXPLAIN`` on the query. The feature will now allow you to see the most important facts about the execution in the log file. :: |
1028 | + |
1029 | + # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No |
1030 | + # Filesort: No Filesort_on_disk: No Merge_passes: 0 |
1031 | + |
1032 | +The values and their meanings are documented with the :variable:`log_slow_filter` option. |
1033 | + |
1034 | +|InnoDB| Usage Information |
1035 | +-------------------------- |
1036 | + |
1037 | +The final part of the output is the |InnoDB| usage statistics. |MySQL| currently shows many per-session statistics for operations with ``SHOW SESSION STATUS``, but that does not include those of |InnoDB|, which are always global and shared by all threads. This feature lets you see those values for a given query. :: |
1038 | + |
1039 | + # InnoDB_IO_r_ops: 6415 InnoDB_IO_r_bytes: 105103360 InnoDB_IO_r_wait: 0.001279 |
1040 | + # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 |
1041 | + # InnoDB_pages_distinct: 6430 |
1042 | + |
1043 | +Values: |
1044 | + |
1045 | + * ``innodb_IO_r_ops``: |
1046 | + Counts the number of page read operations scheduled. The actual number of read operations may be different, but since this can be done asynchronously, there is no good way to measure it. |
1047 | + |
1048 | + * ``innodb_IO_r_bytes``: |
1049 | + Similar to innodb_IO_r_ops, but the unit is bytes. |
1050 | + |
1051 | + * ``innodb_IO_r_wait``: |
1052 | + Shows how long (in seconds) it took |InnoDB| to actually read the data from storage. |
1053 | + |
1054 | + * ``innodb_rec_lock_wait``: |
1055 | + Shows how long (in seconds) the query waited for row locks. |
1056 | + |
1057 | + * ``innodb_queue_wait``: |
1058 | + Shows how long (in seconds) the query spent either waiting to enter the |InnoDB| queue or inside that queue waiting for execution. |
1059 | + |
1060 | + * ``innodb_pages_distinct``: |
1061 | + Counts approximately the number of unique pages the query accessed. The approximation is based on a small hash array representing the entire buffer pool, because it could take a lot of memory to map all the pages. The inaccuracy grows with the number of pages accessed by a query, because there is a higher probability of hash collisions. |
1062 | + |
1063 | +If the query did not use |InnoDB| tables, that information is written into the log instead of the above statistics. |
1064 | + |
1065 | +Related Reading |
1066 | +=============== |
1067 | + |
1068 | + * `Impact of logging on MySQL's performance <http://www.mysqlperformanceblog.com/2009/02/10/impact-of-logging-on-mysql%E2%80%99s-performance/>`_ |
1069 | + |
1070 | + * `log_slow_filter Usage <http://www.mysqlperformanceblog.com/2008/09/22/finding-what-created_tmp_disk_tables-with-log_slow_filter/>`_ |
1071 | + |
1072 | + * `Blueprint in Launchpad <https://blueprints.launchpad.net/percona-server/+spec/microseconds-in-query-log>`_ |
1073 | |
1074 | === removed file 'doc/source/diagnostics/slow_extended_55.rst' |
1075 | --- doc/source/diagnostics/slow_extended_55.rst 2013-05-10 09:39:17 +0000 |
1076 | +++ doc/source/diagnostics/slow_extended_55.rst 1970-01-01 00:00:00 +0000 |
1077 | @@ -1,377 +0,0 @@ |
1078 | -.. _slow_extended_55: |
1079 | - |
1080 | -================ |
1081 | - Slow Query Log |
1082 | -================ |
1083 | - |
1084 | -This feature adds microsecond time resolution and additional statistics to the slow query log output. It lets you enable or disable the slow query log at runtime, adds logging for the slave SQL thread, and adds fine-grained control over what and how much to log into the slow query log. |
1085 | - |
1086 | -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|. |
1087 | - |
1088 | -You can use *Percona-Toolkit*'s `pt-query-digest <http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html>`_ tool to aggregate similar queries together and report on those that consume the most execution time. |
1089 | - |
1090 | - |
1091 | -Version Specific Information |
1092 | -============================ |
1093 | - |
1094 | - * 5.5.8-20.0: |
1095 | - Added values ``profiling`` and ``profiling_use_getrusage`` to variable log_slow_verbosity. |
1096 | - |
1097 | - * 5.5.10-20.1: |
1098 | - * Renamed variable :variable:`slow_query_log_timestamp_always` to :variable:`slow_query_log_timestamp_always`. |
1099 | - |
1100 | - * Renamed variable :variable:`slow_query_log_microseconds_timestamp` to :variable:`slow_query_log_timestamp_precision`. |
1101 | - |
1102 | - * Renamed variable :variable:`use_global_log_slow_control` to :variable:`slow_query_log_use_global_control`. |
1103 | - |
1104 | -Other Information |
1105 | -================= |
1106 | - |
1107 | - * Author / Origin: |
1108 | - Maciej Dobrzanski, Percona |
1109 | - |
1110 | -System Variables |
1111 | -================ |
1112 | - |
1113 | -.. variable:: log_slow_admin_statements |
1114 | - |
1115 | - :cli: Yes |
1116 | - :conf: Yes |
1117 | - :scope: Global |
1118 | - :dyn: yes |
1119 | - |
1120 | -When this variable is enabled, administrative statements will be logged to the slow query log. Upstream version of the |MySQL| server has implemented command line option with same name. Significant difference is that this feature is implemented as variable in |Percona Server|, that means it can be enabled/disabled dynamically without restarting the server. |
1121 | - |
1122 | -.. variable:: log_slow_filter |
1123 | - |
1124 | - :cli: Yes |
1125 | - :conf: Yes |
1126 | - :scope: Global, Session |
1127 | - :dyn: Yes |
1128 | - |
1129 | -Filters the slow log by the query's execution plan. The value is a comma-delimited string, and can contain any combination of the following values: |
1130 | - |
1131 | - * ``qc_miss``: |
1132 | - The query was not found in the query cache. |
1133 | - |
1134 | - * ``full_scan``: |
1135 | - The query performed a full table scan. |
1136 | - |
1137 | - * ``full_join``: |
1138 | - The query performed a full join (a join without indexes). |
1139 | - |
1140 | - * ``tmp_table``: |
1141 | - The query created an implicit internal temporary table. |
1142 | - |
1143 | - * ``tmp_table_on_disk``: |
1144 | - The query``s temporary table was stored on disk. |
1145 | - |
1146 | - * ``filesort``: |
1147 | - The query used a filesort. |
1148 | - |
1149 | - * ``filesort_on_disk``: |
1150 | - The filesort was performed on disk. |
1151 | - |
1152 | -Values are OR'ed together. If the string is empty, then the filter is disabled. If it is not empty, then queries will only be logged to the slow log if their execution plan matches one of the types of plans present in the filter. |
1153 | - |
1154 | -For example, to log only queries that perform a full table scan, set the value to ``full_scan``. To log only queries that use on-disk temporary storage for intermediate results, set the value to ``tmp_table_on_disk,filesort_on_disk``. |
1155 | - |
1156 | -.. variable:: log_slow_rate_type |
1157 | - |
1158 | - :cli: Yes |
1159 | - :conf: Yes |
1160 | - :scope: Global |
1161 | - :dyn: Yes |
1162 | - :vartype: Enumerated |
1163 | - :default: ``session`` |
1164 | - :range: ``session``, ``query`` |
1165 | - |
1166 | -Specifies semantic of :variable:`log_slow_rate_limit` - ``session`` or ``query``. |
1167 | - |
1168 | -.. variable:: log_slow_rate_limit |
1169 | - |
1170 | - :cli: Yes |
1171 | - :conf: Yes |
1172 | - :scope: Global, session |
1173 | - :dyn: Yes |
1174 | - |
1175 | -Behavior of this variable depends from :variable:`log_slow_rate_type`. |
1176 | - |
1177 | -Specifies that only a fraction of ``session/query`` should be logged. Logging is enabled for every nth ``session/query``. By default, n is 1, so logging is enabled for every ``session/query``. Please note: when :variable:`log_slow_rate_type` is ``session`` rate limiting is disabled for the replication thread. |
1178 | - |
1179 | -Logging all queries might consume I/O bandwidth and cause the log file to grow large. |
1180 | - * 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. |
1181 | - |
1182 | - * 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. |
1183 | - |
1184 | -Note that every query has global unique ``query_id`` and every connection can has it own (session) :variable:``log_slow_rate_limit``. |
1185 | -Decision "log or no" calculated in following manner: |
1186 | - |
1187 | - * if ``log_slow_rate_limit`` is 0 - log every query |
1188 | - |
1189 | - * If ``log_slow_rate_limit`` > 0 - log query when (``query_id`` % ``log_slow_rate_limit``) is zero. |
1190 | - |
1191 | -This allows flexible setup logging behavior. |
1192 | - |
1193 | -For example, if you set the value to 100, then one percent of ``sessions/queries`` will be logged. |
1194 | - |
1195 | -.. variable:: log_slow_slave_statements |
1196 | - |
1197 | - :cli: Yes |
1198 | - :conf: Yes |
1199 | - :scope: Global, session |
1200 | - :dyn: Yes (in 5.1 releases only) |
1201 | - |
1202 | -Specifies that slow queries replayed by the slave SQL thread on a |MySQL| slave will be logged. Upstream version of the |MySQL| server has implemented command line option with same name. Significant difference is that this feature is implemented as variable in |Percona Server|, that means it can be enabled/disabled dynamically without restarting the server. |
1203 | - |
1204 | -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. |
1205 | - |
1206 | -To stop the logging from the slave thread, you should just change the global value: set global :variable:`log_slow_slave_statements` ``=OFF``; the logging stops immediately. |
1207 | - |
1208 | - |
1209 | -.. variable:: log_slow_sp_statements |
1210 | - |
1211 | - :cli: Yes |
1212 | - :conf: Yes |
1213 | - :scope: Global |
1214 | - :dyn: Yes |
1215 | - :vartype: Boolean |
1216 | - :default: TRUE |
1217 | - :range: TRUE/FALSE |
1218 | - |
1219 | -If ``TRUE``, statements executed by stored procedures are logged to the slow if it is open. |
1220 | - |
1221 | -.. note:: |
1222 | - |
1223 | - Support for logging stored procedures doesn't involve triggers, so they won't be logged even if this feature is enabled. |
1224 | - |
1225 | -.. variable:: log_slow_verbosity |
1226 | - |
1227 | - :version 5.5.8-20.0: Added ``profiling`` and ``profiling_use_getrusage`` |
1228 | - :cli: Yes |
1229 | - :conf: Yes |
1230 | - :scope: Global, session |
1231 | - :dyn: Yes |
1232 | - |
1233 | -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: |
1234 | - |
1235 | - * ``microtime``: |
1236 | - Log queries with microsecond precision. |
1237 | - |
1238 | - * ``query_plan``: |
1239 | - Log information about the query's execution plan. |
1240 | - |
1241 | - * ``innodb``: |
1242 | - Log |InnoDB| statistics. |
1243 | - |
1244 | - * ``minimal``: |
1245 | - Equivalent to enabling just ``microtime``. |
1246 | - |
1247 | - * ``standard``: |
1248 | - Equivalent to enabling ``microtime,innodb``. |
1249 | - |
1250 | - * ``full``: |
1251 | - Equivalent to all other values OR'ed together. |
1252 | - |
1253 | - * ``profiling``: |
1254 | - Enables profiling of all queries in all connections. |
1255 | - |
1256 | - * ``profiling_use_getrusage``: |
1257 | - Enables usage of the getrusage function. |
1258 | - |
1259 | -Values are OR'ed together. |
1260 | - |
1261 | -For example, to enable microsecond query timing and |InnoDB| statistics, set this option to ``microtime,innodb`` or ``standard``. To turn all options on, set the option to ``full``. |
1262 | - |
1263 | -.. variable:: slow_query_log_timestamp_always |
1264 | - |
1265 | - :version 5.5.10-20.1: Introduced (renamed from :variable:`log_slow_timestamp_every`) |
1266 | - :cli: Yes |
1267 | - :conf: Yes |
1268 | - :scope: Global |
1269 | - :dyn: Yes |
1270 | - :vartype: Boolean |
1271 | - :default: FALSE |
1272 | - :range: TRUE/FALSE |
1273 | - |
1274 | -If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time. |
1275 | - |
1276 | -.. variable:: slow_query_log_timestamp_precision |
1277 | - |
1278 | - :version 5.5.10-20.1: Introduced (renamed from ``slow_query_log_microseconds_timestamp``) |
1279 | - :cli: Yes |
1280 | - :conf: Yes |
1281 | - :scope: Global |
1282 | - :dyn: Yes |
1283 | - :vartype: Enumerated |
1284 | - :default: ``second`` |
1285 | - :range: ``second``, ``microsecond`` |
1286 | - |
1287 | -Normally, entries to the slow query log are in seconds precision, in this format: :: |
1288 | - |
1289 | - # Time: 090402 9:23:36 # User@Host: XXX @ XXX [10.X.X.X] |
1290 | - |
1291 | -If :variable:`slow_query_log_timestamp_precision` ``=microsecond``, entries to the slow query log are in microsecond precision, in this format: :: |
1292 | - |
1293 | - # Time: 090402 9:23:36.123456 # User@Host: XXX @ XXX [10.X.X.X] |
1294 | - |
1295 | -.. variable:: slow_query_log_use_global_control |
1296 | - |
1297 | - :cli: Yes |
1298 | - :conf: Yes |
1299 | - :scope: Global |
1300 | - :dyn: Yes |
1301 | - :default: None |
1302 | - :version 5.5.10-20.1: Introduced (renamed from :variable:`log_slow_timestamp_every`) |
1303 | - |
1304 | -Specifies which variables have global scope instead of local. Value is a “flag” variable - you can specify multiple values separated by commas |
1305 | - |
1306 | - * ``none``: |
1307 | - All variables use local scope |
1308 | - |
1309 | - * ``log_slow_filter``: |
1310 | - Global variable :variable:`log_slow_filter` has effect (instead of local) |
1311 | - |
1312 | - * ``log_slow_rate_limit``: |
1313 | - Global variable :variable:`log_slow_rate_limit` has effect (instead of local) |
1314 | - |
1315 | - * ``log_slow_verbosity``: |
1316 | - Global variable :variable:`log_slow_verbosity` has effect (instead of local) |
1317 | - |
1318 | - * ``long_query_time``: |
1319 | - Global variable :variable:`long_query_time` has effect (instead of local) |
1320 | - |
1321 | - * ``min_examined_row_limit``: |
1322 | - Global variable ``min_examined_row_limit`` has effect (instead of local) |
1323 | - |
1324 | - * ``all`` |
1325 | - Global variables has effect (instead of local) |
1326 | - |
1327 | -**NOTE:** This variable has been renamed from :variable:`log_slow_timestamp_every` since 5.5.10-20.1. |
1328 | - |
1329 | - |
1330 | -Other Information |
1331 | -================= |
1332 | - |
1333 | -Changes to the Log Format |
1334 | -------------------------- |
1335 | - |
1336 | -The feature adds more information to the slow log output. Here is a sample log entry: :: |
1337 | - |
1338 | - # User@Host: mailboxer[mailboxer] @ [192.168.10.165] |
1339 | - # Thread_id: 11167745 Schema: board |
1340 | - # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No |
1341 | - # Filesort: Yes Disk_filesort: No Merge_passes: 0 |
1342 | - # Query_time: 0.000659 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 30 Rows_affected: 0 Rows_read: 30 |
1343 | - # innodb_IO_r_ops: 1 innodb_IO_r_bytes: 16384 innodb_IO_r_wait: 0.028487 |
1344 | - # innodb_rec_lock_wait: 0.000000 innodb_queue_wait: 0.000000 |
1345 | - # innodb_pages_distinct: 5 |
1346 | - select count(distinct author_id) from art87.article87 force index (forum_id) where forum_id = 240215 and thread_id = ``710575`` |
1347 | - |
1348 | -Another example (:variable:`log_slow_verbosity` ``=profiling``): :: |
1349 | - |
1350 | - # Query_time: 4.555235 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 Rows_read: 1 |
1351 | - # Profile_starting: 4.554799 Profile_starting_cpu: 0.000000 Profile_checking_permissions: 0.000095 Profile_checking_permissions_cpu: 0.000000 Profile_Opening_tables: 0.000088 Profile_Opening_tables_cpu: 0.000000 Profile_init: 0.000056 Profile_init_cpu: 0.000000 Profile_optimizing: 0.000046 Profile_optimizing_cpu: 0.000000 Profile_executing: 0.000098 Profile_executing_cpu: 0.000000 Profile_end: 0.000049 Profile_end_cpu: 0.000000 Profile_query_end: 0.000045 Profile_query_end_cpu: 0.000000 Profile_freeing_items: 0.000084 Profile_freeing_items_cpu: 0.000000 Profile_logging_slow_query: 0.000045 Profile_logging_slow_query_cpu: 0.000000 |
1352 | - # Profile_total: 4.555405 Profile_total_cpu: 0.000000 |
1353 | - insert into teee4 select * from teee4 limit 10000000; |
1354 | - |
1355 | -Connection and Schema Identifier |
1356 | --------------------------------- |
1357 | - |
1358 | -Each slow log entry now contains a connection identifier, so you can trace all the queries coming from a single connection. This is the same value that is shown in the Id column in ``SHOW FULL PROCESSLIST`` or returned from the ``CONNECTION_ID()`` function. |
1359 | - |
1360 | -Each entry also contains a schema name, so you can trace all the queries whose default database was set to a particular schema. :: |
1361 | - |
1362 | - # Thread_id: 11167745 Schema: board |
1363 | - |
1364 | -Microsecond Time Resolution and Extra Row Information |
1365 | ------------------------------------------------------ |
1366 | - |
1367 | -This is the original functionality offered by the ``microslow`` feature. ``Query_time`` and ``Lock_time`` are logged with microsecond resolution. |
1368 | - |
1369 | -The feature also adds information about how many rows were examined for ``SELECT`` queries, and how many were analyzed and affected for ``UPDATE``, ``DELETE``, and ``INSERT`` queries, :: |
1370 | - |
1371 | - # Query_time: 0.000659 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 30 Rows_affected: 0 Rows_read: 30 |
1372 | - |
1373 | -Values and context: |
1374 | - |
1375 | - * ``Rows_examined``: |
1376 | - Number of rows scanned - ``SELECT`` |
1377 | - |
1378 | - * ``Rows_affected``: |
1379 | - Number of rows changed - ``UPDATE``, ``DELETE``, ``INSERT`` |
1380 | - |
1381 | - * ``Rows_read``: |
1382 | - Number of rows read - ``UPDATE``, ``DELETE``, ``INSERT`` |
1383 | - |
1384 | -Memory Footprint |
1385 | ----------------- |
1386 | - |
1387 | -The feature provides information about the amount of bytes sent for the result of the query and the number of temporary tables created for its execution - differentiated by whether they were created on memory or on disk - with the total number of bytes used by them. :: |
1388 | - |
1389 | - # Bytes_sent: 8053 Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 950528 |
1390 | - |
1391 | -Values and context: |
1392 | - |
1393 | - * ``Bytes_sent``: |
1394 | - The amount of bytes sent for the result of the query |
1395 | - |
1396 | - * ``Tmp_tables``: |
1397 | - Number of temporary tables created on memory for the query |
1398 | - |
1399 | - * ``Tmp_disk_tables``: |
1400 | - Number of temporary tables created on disk for the query |
1401 | - |
1402 | - * ``Tmp_table_sizes``: |
1403 | - Total Size in bytes for all temporary tables used in the query |
1404 | - |
1405 | - |
1406 | -Query Plan Information |
1407 | ----------------------- |
1408 | - |
1409 | -Each query can be executed in various ways. For example, it may use indexes or do a full table scan, or a temporary table may be needed. These are the things that you can usually see by running ``EXPLAIN`` on the query. The feature will now allow you to see the most important facts about the execution in the log file. :: |
1410 | - |
1411 | - # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No |
1412 | - # Filesort: Yes Disk_filesort: No Merge_passes: 0 |
1413 | - |
1414 | -The values and their meanings are documented with the :variable:`log_slow_filter` option. |
1415 | - |
1416 | -|InnoDB| Usage Information |
1417 | --------------------------- |
1418 | - |
1419 | -The final part of the output is the |InnoDB| usage statistics. |MySQL| currently shows many per-session statistics for operations with ``SHOW SESSION STATUS``, but that does not include those of |InnoDB|, which are always global and shared by all threads. This feature lets you see those values for a given query. :: |
1420 | - |
1421 | - # innodb_IO_r_ops: 1 innodb_IO_r_bytes: 16384 innodb_IO_r_wait: 0.028487 |
1422 | - # innodb_rec_lock_wait: 0.000000 innodb_queue_wait: 0.000000 |
1423 | - # innodb_pages_distinct: 5 |
1424 | - |
1425 | -Values: |
1426 | - |
1427 | - * ``innodb_IO_r_ops``: |
1428 | - Counts the number of page read operations scheduled. The actual number of read operations may be different, but since this can be done asynchronously, there is no good way to measure it. |
1429 | - |
1430 | - * ``innodb_IO_r_bytes``: |
1431 | - Similar to innodb_IO_r_ops, but the unit is bytes. |
1432 | - |
1433 | - * ``innodb_IO_r_wait``: |
1434 | - Shows how long (in seconds) it took |InnoDB| to actually read the data from storage. |
1435 | - |
1436 | - * ``innodb_rec_lock_wait``: |
1437 | - Shows how long (in seconds) the query waited for row locks. |
1438 | - |
1439 | - * ``innodb_queue_wait``: |
1440 | - Shows how long (in seconds) the query spent either waiting to enter the |InnoDB| queue or inside that queue waiting for execution. |
1441 | - |
1442 | - * ``innodb_pages_distinct``: |
1443 | - Counts approximately the number of unique pages the query accessed. The approximation is based on a small hash array representing the entire buffer pool, because it could take a lot of memory to map all the pages. The inaccuracy grows with the number of pages accessed by a query, because there is a higher probability of hash collisions. |
1444 | - |
1445 | -If the query did not use |InnoDB| tables, that information is written into the log instead of the above statistics. |
1446 | - |
1447 | -Related Reading |
1448 | -=============== |
1449 | - |
1450 | - * http://www.mysqlperformanceblog.com/2009/02/10/impact-of-logging-on-mysql%E2%80%99s-performance/ |
1451 | - |
1452 | - * `log_slow_filter Usage <http://www.mysqlperformanceblog.com/2008/09/22/finding-what-created_tmp_disk_tables-with-log_slow_filter/>`_ |
1453 | - |
1454 | - * `Blueprint in Launchpad <https://blueprints.launchpad.net/percona-server/+spec/microseconds-in-query-log>`_ |
1455 | |
1456 | === modified file 'doc/source/diagnostics/thread_based_profiling.rst' |
1457 | --- doc/source/diagnostics/thread_based_profiling.rst 2012-09-18 05:04:43 +0000 |
1458 | +++ doc/source/diagnostics/thread_based_profiling.rst 2013-06-03 10:03:31 +0000 |
1459 | @@ -13,5 +13,5 @@ |
1460 | Version Specific Information |
1461 | ============================ |
1462 | |
1463 | - * :rn:`5.5.25a-27.1`: |
1464 | - Thread based profiling introduced |
1465 | + * :rn:`5.6.11-60.3`: |
1466 | + Thread based profiling ported from |Percona Server| 5.5. |
1467 | |
1468 | === modified file 'doc/source/diagnostics/user_stats.rst' |
1469 | --- doc/source/diagnostics/user_stats.rst 2013-05-27 13:59:13 +0000 |
1470 | +++ doc/source/diagnostics/user_stats.rst 2013-06-03 10:03:31 +0000 |
1471 | @@ -12,21 +12,21 @@ |
1472 | Version Specific Information |
1473 | ============================ |
1474 | |
1475 | - * :rn:`5.5.10-20.1`: |
1476 | - Renamed variable :variable:`userstat_running` to :variable:`userstat`. |
1477 | + * :rn:`5.6.11-60.3`: |
1478 | + Feature ported from |Percona Server| 5.5. |
1479 | |
1480 | Other Information |
1481 | ================= |
1482 | |
1483 | * Author/Origin: |
1484 | - *Google*; *Percona* added the ``INFORMATION_SCHEMA`` tables and the :variable:`userstat_running` variable. |
1485 | + *Google*; *Percona* added the ``INFORMATION_SCHEMA`` tables and the :variable:`userstat` variable. |
1486 | |
1487 | System Variables |
1488 | ================ |
1489 | |
1490 | -.. variable:: userstat_running |
1491 | +.. variable:: userstat |
1492 | |
1493 | - :version 5.5.10-20.1: Renamed to :variable:`userstat` |
1494 | + :version 5.6.11-60.3: Variable introduced |
1495 | :cli: Yes |
1496 | :conf: Yes |
1497 | :scope: Global |
1498 | |
1499 | === removed file 'doc/source/flexibility/buff_read_ahead_area.rst' |
1500 | --- doc/source/flexibility/buff_read_ahead_area.rst 2013-05-27 13:46:13 +0000 |
1501 | +++ doc/source/flexibility/buff_read_ahead_area.rst 1970-01-01 00:00:00 +0000 |
1502 | @@ -1,36 +0,0 @@ |
1503 | -.. _buff_read_ahead_area: |
1504 | - |
1505 | -==================================== |
1506 | - Fixed Size for the Read Ahead Area |
1507 | -==================================== |
1508 | - |
1509 | -|InnoDB| dynamically calculates the size of the read-ahead area in case it has to trigger its read-ahead algorithm. When the workload involves heavy I/O operations, this size is computed so frequently that it has a non-negligeable impact on the CPU usage. |
1510 | - |
1511 | -This variable only depends on the size of the buffer pool set by the :variable:`innodb_buffer_pool_size` variable, and as soon as the buffer pool has a size properly greater than 1024 pages (or 16 MB), it is always 64. With this change, its value is fixed to 64, thus removing a bottleneck experienced by some users. |
1512 | - |
1513 | -Please note that the minimum allowed value for the |InnoDB| buffer pool is de facto set to 32 MB. |
1514 | - |
1515 | -This change is a port of the feature from Facebook: |
1516 | - |
1517 | - * http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1/revision/3538 |
1518 | - |
1519 | - |
1520 | -Version Specific Information |
1521 | -============================ |
1522 | - |
1523 | - * :rn:`5.5.8-20.0` : |
1524 | - Full functionality available. |
1525 | - |
1526 | -Other Information |
1527 | -================= |
1528 | - |
1529 | - * Author/Origin: |
1530 | |
1531 | - |
1532 | - * Bugs fixed: |
1533 | - :bug:`606811` |
1534 | - |
1535 | -Other Reading |
1536 | -============= |
1537 | - |
1538 | - * `BUF_READ_AHEAD_AREA Bottleneck <http://www.facebook.com/notes/mysqlfacebook/using-pmp-to-double-mysql-throughput-part-2/405092575932>`_ |
1539 | |
1540 | === removed file 'doc/source/flexibility/innodb_files_extend.rst' |
1541 | --- doc/source/flexibility/innodb_files_extend.rst 2013-05-26 07:09:29 +0000 |
1542 | +++ doc/source/flexibility/innodb_files_extend.rst 1970-01-01 00:00:00 +0000 |
1543 | @@ -1,25 +0,0 @@ |
1544 | -.. _innodb_files_extend: |
1545 | - |
1546 | -================================ |
1547 | - Support of Multiple Page Sizes |
1548 | -================================ |
1549 | - |
1550 | -In standard |InnoDB|, the size of the read-ahead area is computed dynamically, but it always has the same value. This change makes the size fixed, avoiding unuseful computations. |
1551 | - |
1552 | -This feature adds a new system variable for setting it. |
1553 | - |
1554 | - |
1555 | -System Variables |
1556 | -================ |
1557 | - |
1558 | -.. variable:: innodb_page_size |
1559 | - |
1560 | - :cli: Yes |
1561 | - :conf: Yes |
1562 | - :scope: |
1563 | - :dyn: No |
1564 | - :vartype: ULONG |
1565 | - :default: 1 « 14 |
1566 | - :range: 1 « 12 to 1 « ``UNIV_PAGE_SIZE_SHIFT_MAX`` |
1567 | - |
1568 | -**EXPERIMENTAL**: The universal page size of the database. Changing for an existing database is not supported. Use at your own risk! |
1569 | |
1570 | === modified file 'doc/source/flexibility/log_warnings_suppress.rst' |
1571 | --- doc/source/flexibility/log_warnings_suppress.rst 2013-05-27 13:46:13 +0000 |
1572 | +++ doc/source/flexibility/log_warnings_suppress.rst 2013-06-03 10:03:31 +0000 |
1573 | @@ -10,11 +10,8 @@ |
1574 | Version Specific Information |
1575 | ============================ |
1576 | |
1577 | - * :rn:`5.5.8-20.0`: |
1578 | - System variable :variable:`log_warnings_silence` introduced. |
1579 | - |
1580 | - * :rn:`5.5.10-20.1`: |
1581 | - Renamed variable :variable:`log_warnings_silence` to :variable:`log_warnings_suppress`. |
1582 | + * :rn:`5.6.11-60.3`: |
1583 | + Variable :variable:`log_warnings_suppress` ported from |Percona Server| 5.5. |
1584 | |
1585 | |
1586 | System Variables |
1587 | @@ -22,8 +19,7 @@ |
1588 | |
1589 | .. variable:: log_warnings_suppress |
1590 | |
1591 | - :version 5.5.8-20.0: Introduced. |
1592 | - :version 5.5.10-20.1: Renamed. |
1593 | + :version 5.6.11-60.3: Introduced. |
1594 | :cli: Yes |
1595 | :conf: Yes |
1596 | :scope: Global |
1597 | @@ -32,12 +28,8 @@ |
1598 | :default: ``(empty string)`` |
1599 | :range: ``(empty string)``, ``1592`` |
1600 | |
1601 | -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. |
1602 | - |
1603 | It is intended to provide a more general mechanism for disabling warnings than existed previously with variable :variable:`suppress_log_warning_1592`. |
1604 | - |
1605 | When set to the empty string, no warnings are disabled. When set to ``1592``, warning #1592 messages (unsafe statement for binary logging) are suppressed. |
1606 | - |
1607 | In the future, the ability to optionally disable additional warnings may also be added. |
1608 | |
1609 | |
1610 | |
1611 | === modified file 'doc/source/flexibility/max_binlog_files.rst' |
1612 | --- doc/source/flexibility/max_binlog_files.rst 2013-01-30 10:01:50 +0000 |
1613 | +++ doc/source/flexibility/max_binlog_files.rst 2013-06-03 10:03:31 +0000 |
1614 | @@ -11,7 +11,7 @@ |
1615 | Version Specific Information |
1616 | ============================ |
1617 | |
1618 | - * 5.5.27-29.0: |
1619 | + * 5.6.11-60.3: |
1620 | Variable :variable:`max_binlog_files` introduced. |
1621 | |
1622 | System Variables |
1623 | @@ -19,7 +19,7 @@ |
1624 | |
1625 | .. variable:: max_binlog_files |
1626 | |
1627 | - :version 5.5.27-29.0: Introduced. |
1628 | + :version 5.6.11-60.3: Introduced. |
1629 | :cli: Yes |
1630 | :conf: Yes |
1631 | :scope: Global |
1632 | |
1633 | === modified file 'doc/source/index.rst' |
1634 | --- doc/source/index.rst 2013-05-13 04:25:56 +0000 |
1635 | +++ doc/source/index.rst 2013-06-03 10:03:31 +0000 |
1636 | @@ -51,6 +51,15 @@ |
1637 | installation |
1638 | upgrading_guide_55_56 |
1639 | |
1640 | +Scalability Improvements |
1641 | +======================== |
1642 | + |
1643 | +.. toctree:: |
1644 | + :maxdepth: 1 |
1645 | + :glob: |
1646 | + |
1647 | + scalability/innodb_io |
1648 | + |
1649 | Performance Improvements |
1650 | ======================== |
1651 | |
1652 | @@ -69,6 +78,9 @@ |
1653 | :maxdepth: 1 |
1654 | :glob: |
1655 | |
1656 | + flexibility/log_warnings_suppress |
1657 | + flexibility/improved_memory_engine |
1658 | + flexibility/max_binlog_files |
1659 | flexibility/mysqldump_ignore_create_error |
1660 | |
1661 | Reliability Improvements |
1662 | @@ -81,6 +93,7 @@ |
1663 | reliability/log_connection_error |
1664 | reliability/error_pad |
1665 | reliability/innodb_corrupt_table_action |
1666 | + reliability/show_slave_status_nolock |
1667 | |
1668 | Management Improvements |
1669 | ======================= |
1670 | @@ -89,7 +102,7 @@ |
1671 | :maxdepth: 1 |
1672 | :glob: |
1673 | |
1674 | - management/udf_maatkit |
1675 | + management/udf_percona_toolkit |
1676 | management/innodb_fake_changes |
1677 | management/innodb_kill_idle_trx |
1678 | management/enforce_engine |
1679 | @@ -107,16 +120,16 @@ |
1680 | :maxdepth: 1 |
1681 | :glob: |
1682 | |
1683 | - diagnostics/index_info_schema_tables |
1684 | - diagnostics/innodb_stats |
1685 | diagnostics/user_stats |
1686 | - diagnostics/slow_extended_55 |
1687 | + diagnostics/slow_extended |
1688 | diagnostics/innodb_show_status |
1689 | diagnostics/innodb_deadlock_count |
1690 | diagnostics/mysql_syslog |
1691 | diagnostics/show_engines |
1692 | + diagnostics/innodb_show_lock_names |
1693 | diagnostics/process_list |
1694 | diagnostics/misc_info_schema_tables |
1695 | + diagnostics/thread_based_profiling |
1696 | |
1697 | Reference |
1698 | ========= |
1699 | @@ -128,6 +141,7 @@ |
1700 | upstream-bug-fixes |
1701 | development |
1702 | trademark-policy |
1703 | + index_info_schema_tables |
1704 | faq |
1705 | compatibility |
1706 | release-notes/release-notes_index |
1707 | |
1708 | === modified file 'doc/source/index_info_schema_tables.rst' |
1709 | --- doc/source/index_info_schema_tables.rst 2012-12-10 15:24:56 +0000 |
1710 | +++ doc/source/index_info_schema_tables.rst 2013-06-03 10:03:31 +0000 |
1711 | @@ -8,11 +8,11 @@ |
1712 | |
1713 | * :table:`CLIENT_STATISTICS` |
1714 | |
1715 | + * :table:`GLOBAL_TEMPORARY_TABLES` |
1716 | + |
1717 | * :table:`INDEX_STATISTICS` |
1718 | |
1719 | - * :table:`GLOBAL_TEMPORARY_TABLES` |
1720 | - |
1721 | - * :table:`QUERY_RESPONSE_TIME` |
1722 | + * :table:`INNODB_CHANGED_PAGES` |
1723 | |
1724 | * :table:`TABLE_STATISTICS` |
1725 | |
1726 | @@ -22,37 +22,9 @@ |
1727 | |
1728 | * :table:`USER_STATISTICS` |
1729 | |
1730 | - * :table:`INNODB_RSEG` |
1731 | - |
1732 | - * :table:`INNODB_UNDO_LOGS` |
1733 | - |
1734 | - * :table:`INNODB_SYS_TABLESTATS` |
1735 | - |
1736 | - * :table:`INNODB_INDEX_STATS` |
1737 | - |
1738 | - * :table:`INNODB_CHANGED_PAGES` |
1739 | - |
1740 | - * :table:`INNODB_BUFFER_POOL_PAGES` |
1741 | - |
1742 | - * :table:`INNODB_BUFFER_POOL_PAGES_BLOB` |
1743 | - |
1744 | - * :table:`INNODB_BUFFER_POOL_PAGES_INDEX` |
1745 | - |
1746 | - * :table:`INNODB_SYS_TABLES` |
1747 | - |
1748 | - * :table:`INNODB_SYS_FIELDS` |
1749 | - |
1750 | - * :table:`INNODB_SYS_COLUMNS` |
1751 | - |
1752 | - * :table:`INNODB_SYS_STATS` |
1753 | - |
1754 | - * :table:`INNODB_SYS_FOREIGN` |
1755 | - |
1756 | - * :table:`INNODB_SYS_INDEXES` |
1757 | - |
1758 | - * :table:`XTRADB_ADMIN_COMMAND` |
1759 | - |
1760 | - * :table:`INNODB_TABLE_STATS` |
1761 | - |
1762 | - * :table:`INNODB_SYS_FOREIGN_COLS` |
1763 | + * :table:`XTRADB_INTERNAL_HASH_TABLES` |
1764 | + |
1765 | + * :table:`XTRADB_READ_VIEW` |
1766 | + |
1767 | + * :table:`XTRADB_RSEG` |
1768 | |
1769 | |
1770 | === modified file 'doc/source/installation.rst' |
1771 | --- doc/source/installation.rst 2013-05-27 13:59:13 +0000 |
1772 | +++ doc/source/installation.rst 2013-06-03 10:03:31 +0000 |
1773 | @@ -201,4 +201,4 @@ |
1774 | |
1775 | .. note:: |
1776 | |
1777 | - :ref:`pam_plugin` has been merged into |Percona Server| in :rn:`5.5.24-26.0` but it is not built with the server by default. In order to build the Percona Server with PAM plugin, additional option :option:`-DWITH_PAM=ON` should be used. |
1778 | + :ref:`pam_plugin` is not built with the server by default. In order to build the Percona Server with PAM plugin, additional option :option:`-DWITH_PAM=ON` should be used. |
1779 | |
1780 | === modified file 'doc/source/management/changed_page_tracking.rst' |
1781 | --- doc/source/management/changed_page_tracking.rst 2013-03-06 06:41:38 +0000 |
1782 | +++ doc/source/management/changed_page_tracking.rst 2013-06-03 10:03:31 +0000 |
1783 | @@ -18,7 +18,7 @@ |
1784 | User statements for handling the XtraDB changed page bitmaps |
1785 | ============================================================ |
1786 | |
1787 | -In |Percona Server| :rn:`5.5.29-30.0` new statements have been introduced for handling the changed page bitmap tracking. All of these statements require ``SUPER`` privilege. |
1788 | +In |Percona Server| :rn:`5.6.11-60.3` new statements have been introduced for handling the changed page bitmap tracking. All of these statements require ``SUPER`` privilege. |
1789 | |
1790 | * ``FLUSH CHANGED_PAGE_BITMAPS`` - this statement can be used for synchronous bitmap write for immediate catch-up with the log checkpoint. This is used by innobackupex to make sure that XtraBackup indeed has all the required data it needs. |
1791 | * ``RESET CHANGED_PAGE_BITMAPS`` - this statement will delete all the bitmap log files and restart the bitmap log file sequence. |
1792 | @@ -52,8 +52,7 @@ |
1793 | |
1794 | .. variable:: innodb_max_changed_pages |
1795 | |
1796 | - :version 5.5.27-29.0: Variable :variable:`innodb_changed_pages_limit` introduced |
1797 | - :version 5.5.29-30.0: Variable renamed to :variable:`innodb_max_changed_pages` |
1798 | + :version 5.6.11-60.3: Variable :variable:`innodb_max_changed_pages` introduced |
1799 | :cli: Yes |
1800 | :conf: Yes |
1801 | :scope: Global |
1802 | @@ -64,7 +63,7 @@ |
1803 | |
1804 | .. variable:: innodb_track_changed_pages |
1805 | |
1806 | - :version 5.5.27-29.0: Variable introduced |
1807 | + :version 5.6.11-60.3: Variable introduced |
1808 | :cli: Yes |
1809 | :conf: Yes |
1810 | :scope: Global |
1811 | @@ -75,7 +74,7 @@ |
1812 | |
1813 | .. variable:: innodb_max_bitmap_file_size |
1814 | |
1815 | - :version 5.5.28-29.2: Variable introduced |
1816 | + :version 5.6.11-60.3: Variable introduced |
1817 | :cli: Yes |
1818 | :conf: Yes |
1819 | :scope: Global |
1820 | |
1821 | === modified file 'doc/source/management/enforce_engine.rst' |
1822 | --- doc/source/management/enforce_engine.rst 2012-12-14 09:58:23 +0000 |
1823 | +++ doc/source/management/enforce_engine.rst 2013-06-03 10:03:31 +0000 |
1824 | @@ -13,7 +13,7 @@ |
1825 | Version Specific Information |
1826 | ============================ |
1827 | |
1828 | - * :rn:`5.5.24-26.0` |
1829 | + * :rn:`5.6.11-60.3` |
1830 | Variable :variable:`enforce_storage_engine` implemented. |
1831 | |
1832 | System Variables |
1833 | |
1834 | === modified file 'doc/source/management/expanded_program_option_modifiers.rst' |
1835 | --- doc/source/management/expanded_program_option_modifiers.rst 2012-09-04 23:24:39 +0000 |
1836 | +++ doc/source/management/expanded_program_option_modifiers.rst 2013-06-03 10:03:31 +0000 |
1837 | @@ -31,7 +31,7 @@ |
1838 | Version Specific Information |
1839 | ============================ |
1840 | |
1841 | - * :rn:`5.5.27-28.0` |
1842 | + * :rn:`5.6.11-60.3` |
1843 | Expanded program option modifiers implemented |
1844 | |
1845 | Examples |
1846 | |
1847 | === modified file 'doc/source/management/innodb_fake_changes.rst' |
1848 | --- doc/source/management/innodb_fake_changes.rst 2013-05-27 13:59:13 +0000 |
1849 | +++ doc/source/management/innodb_fake_changes.rst 2013-06-03 10:03:31 +0000 |
1850 | @@ -4,7 +4,7 @@ |
1851 | Support for Fake Changes |
1852 | ========================== |
1853 | |
1854 | -Restarting 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. |
1855 | +Restarting 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 sped up by having prefetch threads to warm the server: replay statements and then rollback at commit. |
1856 | |
1857 | That makes prefetch simple but has high overhead from locking rows only to undo changes at rollback. |
1858 | |
1859 | @@ -35,7 +35,7 @@ |
1860 | |
1861 | .. variable:: innodb_fake_changes |
1862 | |
1863 | - :version 5.5.16-22.0: Introduced |
1864 | + :version 5.6.11-60.3: Introduced |
1865 | :scope: ``GLOBAL`` |
1866 | :type: ``BOOLEAN`` |
1867 | :dyn: ``YES`` |
1868 | @@ -43,6 +43,16 @@ |
1869 | |
1870 | This variable enables the *Fake Changes* feature. |
1871 | |
1872 | +.. variable:: innodb_locking_fake_changes |
1873 | + |
1874 | + :version 5.6.11-60.3: Introduced |
1875 | + :scope: ``GLOBAL`` |
1876 | + :type: ``BOOLEAN`` |
1877 | + :dyn: ``YES`` |
1878 | + :default: ``TRUE`` |
1879 | + |
1880 | + When this variable is set to ``FALSE``, it makes fake transactions not to take any row locks. This feature was implemented because, although fake change transactions downgrade the requested exclusive (X) row locks to shared (S) locks, these S locks prevent X locks from being taken and block the real changes. However, this option is not safe to set to FALSE by default, because the fake changes implementation is not ready for lock-less operation for all workloads. Namely, if a real transaction will remove a row that a fake transaction is doing a secondary index maintenance for, the latter will fail. This option is considered experimental and might be removed in the future if lockless operation mode fixes are implemented. |
1881 | + |
1882 | Implementation Details |
1883 | ====================== |
1884 | |
1885 | |
1886 | === removed file 'doc/source/management/innodb_fast_index_creation.rst' |
1887 | --- doc/source/management/innodb_fast_index_creation.rst 2012-12-14 09:58:23 +0000 |
1888 | +++ doc/source/management/innodb_fast_index_creation.rst 1970-01-01 00:00:00 +0000 |
1889 | @@ -1,63 +0,0 @@ |
1890 | -.. _innodb_fast_index_creation: |
1891 | - |
1892 | -===================== |
1893 | - Fast Index Creation |
1894 | -===================== |
1895 | - |
1896 | -Percona has implemented several changes related to |MySQL|'s fast index creation feature. Extended features, besides disabling :variable:`fast_index_creation`, can be enabled with :variable:`expand_fast_index_creation`. |
1897 | - |
1898 | -Disabling Fast Index Creation |
1899 | -============================= |
1900 | - |
1901 | -Fast index creation was implemented in |MySQL| as a way to speed up the process of adding or dropping indexes on tables with many rows. However, cases have been found in which fast index creation creates an inconsistency between |MySQL| and |InnoDB| data dictionaries. |
1902 | - |
1903 | -This feature implements a session variable that disables fast index creation. This causes indexes to be created in the way they were created before fast index creation was implemented. While this is slower, it avoids the problem of data dictionary inconsistency between |MySQL| and |InnoDB|. |
1904 | - |
1905 | - |
1906 | -Tunable buffer size for fast index creation |
1907 | -=========================================== |
1908 | - |
1909 | -|Percona Server| supports tunable buffer size for fast index creation in |InnoDB|. This value was calculated based on the merge block size (which was hardcoded to 1 MB) and the minimum index record size. By adding the session variable :variable:`innodb_merge_sort_block_size` block size that is used in the merge sort can now be adjusted for better performance. |
1910 | - |
1911 | - |
1912 | -Version Specific Information |
1913 | -============================ |
1914 | - |
1915 | - * :rn:`5.5.8-20.0`: |
1916 | - Variable :variable:`fast_index_creation` implemented. |
1917 | - |
1918 | - * :rn:`5.5.11-20.2`: |
1919 | - Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``. |
1920 | - |
1921 | - * :rn:`5.5.27-28.0` |
1922 | - Variable :variable:`innodb_merge_sort_block_size` implemented. |
1923 | - |
1924 | -System Variables |
1925 | -================ |
1926 | - |
1927 | -.. variable:: fast_index_creation |
1928 | - |
1929 | - :cli: Yes |
1930 | - :conf: No |
1931 | - :scope: Local |
1932 | - :dyn: Yes |
1933 | - :vartype: Boolean |
1934 | - :default: ON |
1935 | - :range: ON/OFF |
1936 | - |
1937 | -.. variable:: innodb_merge_sort_block_size |
1938 | - |
1939 | - :cli: Yes |
1940 | - :conf: Yes |
1941 | - :scope: Global |
1942 | - :dyn: Yes |
1943 | - :vartype: ULONG |
1944 | - :default: 1048576 (1M) |
1945 | - :range: 1048576 - 1073741824 (1G) |
1946 | - |
1947 | -Other Reading |
1948 | -============= |
1949 | - |
1950 | - * `Thinking about running OPTIMIZE on your InnoDB Table? Stop! <http://www.mysqlperformanceblog.com/2010/12/09/thinking-about-running-optimize-on-your-innodb-table-stop/>`_ |
1951 | - |
1952 | - * `Building Indexes by Sorting In Innodb <http://www.mysqlperformanceblog.com/2012/06/19/building-indexes-by-sorting-in-innodb-aka-fast-index-creation/>`_ |
1953 | |
1954 | === modified file 'doc/source/management/innodb_kill_idle_trx.rst' |
1955 | --- doc/source/management/innodb_kill_idle_trx.rst 2013-05-26 13:51:37 +0000 |
1956 | +++ doc/source/management/innodb_kill_idle_trx.rst 2013-06-03 10:03:31 +0000 |
1957 | @@ -11,7 +11,7 @@ |
1958 | |
1959 | .. variable:: innodb_kill_idle_transaction |
1960 | |
1961 | - :version 5.5.16-22.0: Introduced |
1962 | + :version 5.6.11-60.3: Introduced |
1963 | :scope: ``GLOBAL`` |
1964 | :config: ``YES`` |
1965 | :dyn: ``YES`` |
1966 | |
1967 | === modified file 'doc/source/management/pam_plugin.rst' |
1968 | --- doc/source/management/pam_plugin.rst 2013-02-06 10:26:45 +0000 |
1969 | +++ doc/source/management/pam_plugin.rst 2013-06-03 10:03:31 +0000 |
1970 | @@ -68,5 +68,5 @@ |
1971 | Version Specific Information |
1972 | ============================ |
1973 | |
1974 | - * :rn:`5.5.24-26.0` |
1975 | + * :rn:`5.6.11-60.3` |
1976 | PAM authentication plugin has been integrated with |Percona Server|. |
1977 | |
1978 | === modified file 'doc/source/management/secure_file_priv_extended.rst' |
1979 | --- doc/source/management/secure_file_priv_extended.rst 2012-09-04 23:24:39 +0000 |
1980 | +++ doc/source/management/secure_file_priv_extended.rst 2013-06-03 10:03:31 +0000 |
1981 | @@ -10,7 +10,7 @@ |
1982 | Version Specific Information |
1983 | ============================ |
1984 | |
1985 | - * :rn:`5.5.25a-27.1` |
1986 | + * :rn:`5.6.11-60.3` |
1987 | Variable :variable:`secure-file-priv` extended behavior implemented. |
1988 | |
1989 | System Variables |
1990 | |
1991 | === removed file 'doc/source/management/udf_maatkit.rst' |
1992 | --- doc/source/management/udf_maatkit.rst 2013-05-10 09:39:17 +0000 |
1993 | +++ doc/source/management/udf_maatkit.rst 1970-01-01 00:00:00 +0000 |
1994 | @@ -1,49 +0,0 @@ |
1995 | -.. _udf_maatkit: |
1996 | - |
1997 | -====================================== |
1998 | - *Percona Toolkit* and *Maatkit* UDFs |
1999 | -====================================== |
2000 | - |
2001 | -Three *Percona Toolkit* and *Maatkit* UDFs that provide faster checksums are provided: |
2002 | - |
2003 | - * ``fnv_udf`` |
2004 | - |
2005 | - * ``fnv1a_udf`` |
2006 | - |
2007 | - * ``murmur_udf`` |
2008 | - |
2009 | -Version Specific Information |
2010 | -============================ |
2011 | - |
2012 | - * 5.1.53-12.4: |
2013 | - Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``. |
2014 | - |
2015 | -Other Information |
2016 | -================= |
2017 | - |
2018 | - * Author / Origin: |
2019 | - Baron Schwartz |
2020 | - |
2021 | -Installation |
2022 | -============ |
2023 | - |
2024 | -Use of the Percona Software Repositories simplifies the installation of *Percona Toolkit*. Once the repository has been set up on your system, *Percona Toolkit* can be installed by executing: :: |
2025 | - |
2026 | - $ yum install percona-toolkit |
2027 | - |
2028 | -This will place the *Percona Toolkit* UDFs onto your system. However, they will not yet be installed into the |MySQL| server. To install one of the UDF``s into the server, execute one of the following commands, depending on which UDF you want to install: :: |
2029 | - |
2030 | - $ mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME ``fnv_udf.so``" |
2031 | - $ mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME ``fnv1a_udf.so``" |
2032 | - $ mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME ``murmur_udf.so``" |
2033 | - |
2034 | -Executing each of these commands will install its respective UDF into the server. |
2035 | - |
2036 | -If you have any difficulty, or require more detailed information, refer to the *Maatkit* `Installing UDFs <http://code.google.com/p/maatkit/wiki/InstallingUdfs>`_ documentation. |
2037 | - |
2038 | - |
2039 | -Other Reading |
2040 | -============= |
2041 | - |
2042 | - * *Percona Toolkit* - http://www.percona.com/doc/percona-toolkit |
2043 | - * *Maatkit* - http://www.maatkit.org/ |
2044 | |
2045 | === added file 'doc/source/management/udf_percona_toolkit.rst' |
2046 | --- doc/source/management/udf_percona_toolkit.rst 1970-01-01 00:00:00 +0000 |
2047 | +++ doc/source/management/udf_percona_toolkit.rst 2013-06-03 10:03:31 +0000 |
2048 | @@ -0,0 +1,54 @@ |
2049 | +.. _udf_percona_toolkit: |
2050 | + |
2051 | +======================== |
2052 | + *Percona Toolkit* UDFs |
2053 | +======================== |
2054 | + |
2055 | +Three *Percona Toolkit* UDFs that provide faster checksums are provided: |
2056 | + |
2057 | + * ``fnv_udf`` |
2058 | + |
2059 | + * ``fnv1a_udf`` |
2060 | + |
2061 | + * ``murmur_udf`` |
2062 | + |
2063 | +Version Specific Information |
2064 | +============================ |
2065 | + |
2066 | + * :rn:`5.6.11-60.3`: |
2067 | + Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``. |
2068 | + |
2069 | +Other Information |
2070 | +================= |
2071 | + |
2072 | + * Author / Origin: |
2073 | + Baron Schwartz |
2074 | + |
2075 | +Installation |
2076 | +============ |
2077 | + |
2078 | +Use of the Percona Software Repositories simplifies the installation of *Percona Toolkit*. Once the repository has been set up on your system, *Percona Toolkit* can be installed by executing: :: |
2079 | + |
2080 | + $ yum install percona-toolkit |
2081 | + |
2082 | +This will place the *Percona Toolkit* UDFs onto your system. However, they will not yet be installed into the |MySQL| server. To install one of the UDF``s into the server, execute one of the following commands, depending on which UDF you want to install: :: |
2083 | + |
2084 | + $ mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME ``fnv_udf.so``" |
2085 | + $ mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME ``fnv1a_udf.so``" |
2086 | + $ mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME ``murmur_udf.so``" |
2087 | + |
2088 | +Executing each of these commands will install its respective UDF into the server. |
2089 | + |
2090 | +Troubleshooting |
2091 | +================ |
2092 | + |
2093 | +If you get the error: :: |
2094 | + |
2095 | + ERROR 1126 (HY000): Can't open shared library 'fnv_udf.so' (errno: 22 fnv_udf.so: cannot open shared object file: No such file or directory) |
2096 | + |
2097 | +Then you may need to copy the .so file to another location in your system. Try both ``/lib`` and ``/usr/lib``. Look at your environment's ``$LD_LIBRARY_PATH`` variable for clues. If none is set, and neither ``/lib`` nor ``/usr/lib`` works, you may need to set ``LD_LIBRARY_PATH`` to ``/lib`` or ``/usr/lib``. |
2098 | + |
2099 | +Other Reading |
2100 | +============= |
2101 | + |
2102 | + * *Percona Toolkit* `documentation <http://www.percona.com/doc/percona-toolkit/>`_ |
2103 | |
2104 | === modified file 'doc/source/management/utility_user.rst' |
2105 | --- doc/source/management/utility_user.rst 2012-09-04 23:24:39 +0000 |
2106 | +++ doc/source/management/utility_user.rst 2013-06-03 10:03:31 +0000 |
2107 | @@ -26,7 +26,7 @@ |
2108 | |
2109 | In order to have the ability for a special type of MySQL user, which will have a very limited and special amount of control over the system and can not be see or modified by any other user including the root user, three new options have been added. |
2110 | |
2111 | -Option :variable:`utility_user` specifies the user which the system will create and recognize as the utility user. The host in the utility user specification follows conventions described in the `MySQL manual <http://dev.mysql.com/doc/refman/5.5/en/connection-access.html>`_, i.e. it allows wildcards and IP masks. Anonymous user names are not permitted to be used for the utility user name. |
2112 | +Option :variable:`utility_user` specifies the user which the system will create and recognize as the utility user. The host in the utility user specification follows conventions described in the `MySQL manual <http://dev.mysql.com/doc/refman/5.6/en/connection-access.html>`_, i.e. it allows wildcards and IP masks. Anonymous user names are not permitted to be used for the utility user name. |
2113 | |
2114 | This user must not be an exact match to any other user that exists in the mysql.user table. If the server detects that the user specified with this option exactly matches any user within the mysql.user table on start up, the server will report an error and shut down gracefully. If host name wildcards are used and a more specific user specification is identified on start up, the server will report a warning and continue. |
2115 | |
2116 | @@ -51,7 +51,7 @@ |
2117 | |
2118 | .. variable:: utility_user |
2119 | |
2120 | - :version 5.5.27-28.0: Implemented |
2121 | + :version 5.6.11-60.3: Implemented |
2122 | :cli: Yes |
2123 | :conf: utility_user=<user@host> |
2124 | :scope: Global |
2125 | @@ -63,7 +63,7 @@ |
2126 | |
2127 | .. variable:: utility_user_password |
2128 | |
2129 | - :version 5.5.27-28.0: Implemented |
2130 | + :version 5.6.11-60.3: Implemented |
2131 | :cli: Yes |
2132 | :conf: utility_user_password=<password> |
2133 | :scope: Global |
2134 | @@ -75,7 +75,7 @@ |
2135 | |
2136 | .. variable:: utility_user_schema_access |
2137 | |
2138 | - :version 5.5.27-28.0: Implemented |
2139 | + :version 5.6.11-60.3: Implemented |
2140 | :cli: Yes |
2141 | :conf: utility_user_schema_access=<schema>,<schema>,<schema> |
2142 | :scope: Global |
2143 | |
2144 | === modified file 'doc/source/performance/innodb_numa_support.rst' |
2145 | --- doc/source/performance/innodb_numa_support.rst 2013-05-12 09:13:00 +0000 |
2146 | +++ doc/source/performance/innodb_numa_support.rst 2013-06-03 10:03:31 +0000 |
2147 | @@ -13,7 +13,7 @@ |
2148 | Version Specific Information |
2149 | ============================ |
2150 | |
2151 | - * :rn:`5.5.28-29.1` |
2152 | + * :rn:`5.6.11-60.3` |
2153 | Improved ``NUMA`` support implemented. This feature was ported from Twitter's |MySQL| patches. |
2154 | |
2155 | System Variables |
2156 | |
2157 | === modified file 'doc/source/performance/query_cache_enhance.rst' |
2158 | --- doc/source/performance/query_cache_enhance.rst 2013-05-26 07:09:29 +0000 |
2159 | +++ doc/source/performance/query_cache_enhance.rst 2013-06-03 10:03:31 +0000 |
2160 | @@ -38,19 +38,19 @@ |
2161 | |
2162 | This features provides a new thread state - ``Waiting on query cache mutex``. It has always been difficult to spot query cache bottlenecks because these bottlenecks usually happen intermittently and are not directly reported by the server. This new thread state appear in the output of SHOW PROCESSLIST, easing diagnostics. |
2163 | |
2164 | -Imagine that we run three queries simultaneously (each one in a separate thread): |
2165 | - |
2166 | - > SELECT number from t where id > 0; |
2167 | - > SELECT number from t where id > 0; |
2168 | - > SELECT number from t where id > 0; |
2169 | - |
2170 | -If we experience query cache contention, the output of SHOW PROCESSLIT will look like this: :: |
2171 | +Imagine that we run three queries simultaneously (each one in a separate thread): :: |
2172 | + |
2173 | + > SELECT number from t where id > 0; |
2174 | + > SELECT number from t where id > 0; |
2175 | + > SELECT number from t where id > 0; |
2176 | + |
2177 | +If we experience query cache contention, the output of ``SHOW PROCESSLIST`` will look like this: :: |
2178 | |
2179 | > SHOW PROCESSLIST; |
2180 | Id User Host db Command Time State Info |
2181 | 2 root localhost test Sleep 2 NULL |
2182 | 3 root localhost test Query 2 Waiting on query cache mutex SELECT number from t where id > 0; |
2183 | - 4 root localhost test Query 1 Waiting on query cache mutex SELECT number from t where id > 0; |
2184 | + 4 root localhost test Query 1 Waiting on query cache mutex SELECT number from t where id > 0; |
2185 | 5 root localhost test Query 0 NULL |
2186 | |
2187 | Ignoring comments |
2188 | @@ -66,36 +66,6 @@ |
2189 | If the option is enabled, the queries are considered identical, so the server will execute and cache the first one and will serve the second one directly from the query cache. |
2190 | |
2191 | |
2192 | -.. Version Specific Information |
2193 | -.. ---------------------------- |
2194 | - |
2195 | -.. Disabling the query cache completely |
2196 | - |
2197 | -.. Percona Server Version Comments |
2198 | -.. 5.1.49-12.0 Full functionality available. |
2199 | -.. Diagnosing contention more easily |
2200 | - |
2201 | -.. Percona Server Version Comments |
2202 | -.. 5.1.49-12.0 Full functionality available. |
2203 | -.. Ignoring comments |
2204 | - |
2205 | -.. Percona Server Version Comments |
2206 | -.. 5.1.47-11.0 Critical bug (see MySQL bug 55032). Release was recalled. |
2207 | -.. 5.1.47-11.1 Fixed critical bug from previous release. MySQL bug 55032 actual. Bug b603618 actual. Bug 603619 actual. |
2208 | -.. 5.1.47-11.2 Full functionality available. |
2209 | -.. 5.1.48-12.0 Full functionality available. |
2210 | - |
2211 | -.. Other Information |
2212 | - |
2213 | -.. Disabling the query cache completely |
2214 | - |
2215 | -.. Author/Origin Percona |
2216 | -.. Bugs fixed LP bug 609027, MySQL bug 38551 |
2217 | -.. Diagnosing contention more easily |
2218 | - |
2219 | -.. Author/Origin Percona |
2220 | -.. Bugs fixed LP bug589484 |
2221 | - |
2222 | System Variables |
2223 | ================ |
2224 | |
2225 | @@ -116,8 +86,4 @@ |
2226 | |
2227 | * `MySQL general thread states <http://dev.mysql.com/doc/refman/5.1/en/general-thread-states.html>`_ |
2228 | |
2229 | - * `RAII <http://en.wikibooks.org/wiki/More_C%2B%2B_Idioms/Resource_Acquisition_Is_Initialization>`_ |
2230 | - |
2231 | - * `Scope guard <http://en.wikibooks.org/wiki/More_C%2B%2B_Idioms/Scope_Guard>`_ |
2232 | - |
2233 | * `Query cache freezes <http://www.mysqlperformanceblog.com/2009/03/19/mysql-random-freezes-could-be-the-query-cache/>`_ |
2234 | |
2235 | === modified file 'doc/source/reliability/error_pad.rst' |
2236 | --- doc/source/reliability/error_pad.rst 2013-05-27 13:59:13 +0000 |
2237 | +++ doc/source/reliability/error_pad.rst 2013-06-03 10:03:31 +0000 |
2238 | @@ -4,17 +4,17 @@ |
2239 | Error Code Compatibility |
2240 | ========================== |
2241 | |
2242 | -|Percona Server| with |XtraDB| has error code incompatibilities with |MySQL| 5.5. It is important to maintain compatibility in the error codes used by the servers. For example, scripts that may be run on both servers could contain references to error codes. |
2243 | +|Percona Server| with |XtraDB| has error code incompatibilities with |MySQL| 5.6. It is important to maintain compatibility in the error codes used by the servers. For example, scripts that may be run on both servers could contain references to error codes. |
2244 | |
2245 | The reasons for the current incompatibilities are: |
2246 | |
2247 | - * |Percona Server| with |XtraDB| contains features that have been backported from MyQL 5.5. Some of the |MySQL| 5.5 features added new error codes. |
2248 | + * |Percona Server| with |XtraDB| contains features that have been backported from MyQL 5.6. Some of the |MySQL| 5.6 features added new error codes. |
2249 | |
2250 | * Some |Percona Server| with |XtraDB| features have added new error codes. |
2251 | |
2252 | -The solution to the first problem is to preserve |MySQL| 5.5 error codes in the |Percona Server|. An example of where this has been done is |Percona Server| feature Query Cache Enhancements. This feature adds error ``ER_QUERY_CACHE_DISABLED`` to the |Percona Server|, which is defined as error code 1651 in |MySQL| 5.5. |
2253 | +The solution to the first problem is to preserve |MySQL| 5.6 error codes in the |Percona Server|. An example of where this has been done is |Percona Server| feature Query Cache Enhancements. This feature adds error ``ER_QUERY_CACHE_DISABLED`` to the |Percona Server|, which is defined as error code 1651 in |MySQL| 5.6. |
2254 | |
2255 | -After migrating |Percona Server| / |XtraDB| to |MySQL| 5.5, users might experience troubles because of this. |
2256 | +After migrating |Percona Server| / |XtraDB| to |MySQL| 5.6, users might experience troubles because of this. |
2257 | |
2258 | The solution to the second problem is to insure that unique error codes are chosen, when adding new ones to |Percona Server|, that will never be duplicated during |MySQL| development. |
2259 | |
2260 | @@ -51,5 +51,5 @@ |
2261 | Version-Specific Information |
2262 | ============================ |
2263 | |
2264 | - * 5.5.8-20.0 |
2265 | - Full functionality available. |
2266 | + * :rn:`5.6.11-60.3` |
2267 | + Feature ported from |Percona Server| 5.5. |
2268 | |
2269 | === modified file 'doc/source/reliability/log_connection_error.rst' |
2270 | --- doc/source/reliability/log_connection_error.rst 2013-05-27 13:59:13 +0000 |
2271 | +++ doc/source/reliability/log_connection_error.rst 2013-06-03 10:03:31 +0000 |
2272 | @@ -10,5 +10,5 @@ |
2273 | Version-Specific Information |
2274 | ============================ |
2275 | |
2276 | - * 5.5.8-20.0: |
2277 | - Full functionality available. |
2278 | + * :rn:`5.6.11-30.3`: |
2279 | + Feature ported from |Percona Server| 5.5. |
2280 | |
2281 | === modified file 'doc/source/reliability/show_slave_status_nolock.rst' |
2282 | --- doc/source/reliability/show_slave_status_nolock.rst 2013-05-06 15:43:51 +0000 |
2283 | +++ doc/source/reliability/show_slave_status_nolock.rst 2013-06-03 10:03:31 +0000 |
2284 | @@ -14,10 +14,12 @@ |
2285 | |
2286 | This will display the slave's status as if there were no lock, allowing the user to detect and understand the situation that is occurring. |
2287 | |
2288 | -**NOTE:** The information given when ``NOLOCK`` is used may be slightly inconsistent with the actual situation while the lock is being held. |
2289 | +.. note:: |
2290 | + |
2291 | + The information given when ``NOLOCK`` is used may be slightly inconsistent with the actual situation while the lock is being held. |
2292 | |
2293 | |
2294 | Version Specific Information |
2295 | ============================ |
2296 | |
2297 | - * 5.5.8-20.0: |
2298 | + * :rn:`5.6.11-60.3`: Feature ported from |Percona Server| 5.5. |
2299 | |
2300 | === added file 'doc/source/scalability/innodb_io.rst' |
2301 | --- doc/source/scalability/innodb_io.rst 1970-01-01 00:00:00 +0000 |
2302 | +++ doc/source/scalability/innodb_io.rst 2013-06-03 10:03:31 +0000 |
2303 | @@ -0,0 +1,71 @@ |
2304 | +.. _innodb_io_page: |
2305 | + |
2306 | +=================================== |
2307 | + Improved |InnoDB| I/O Scalability |
2308 | +=================================== |
2309 | + |
2310 | +Because |InnoDB| is a complex storage engine it must be configured properly in order to perform at its best. Some points are not configurable in standard |InnoDB|. The goal of this feature is to provide a more exhaustive set of options for |XtraDB|, like ability to change the log block size. |
2311 | + |
2312 | +Version Specific Information |
2313 | +============================ |
2314 | + |
2315 | + * :rn:`5.6.11-60.3` |
2316 | + |
2317 | + * Feature ported from |Percona Server| 5.5 |
2318 | + |
2319 | +System Variables |
2320 | +================ |
2321 | + |
2322 | + |
2323 | +.. variable:: innodb_use_global_flush_log_at_trx_commit |
2324 | + |
2325 | + :cli: Yes |
2326 | + :conf: Yes |
2327 | + :scope: Global |
2328 | + :dyn: Yes |
2329 | + :type: Boolean |
2330 | + :default: True |
2331 | + :range: True/False |
2332 | + |
2333 | +This variable is used to control the ability of the user to set the value of the global |MySQL| variable ``innodb_flush_log_at_trx_commit``. |
2334 | + |
2335 | +If ``innodb_use_global_flush_log_at_trx_commit=0`` (False), the client can set the global |MySQL| variable, using: :: |
2336 | + |
2337 | + SET innodb_use_global_flush_log_at_trx_commit=N |
2338 | + |
2339 | +If ``innodb_use_global_flush_log_at_trx_commit=1`` (True), the user session will use the current value of ``innodb_flush_log_at_trx_commit``, and the user cannot reset the value of the global variable using a ``SET`` command. |
2340 | + |
2341 | +.. variable:: innodb_log_block_size |
2342 | + |
2343 | + :cli: Yes |
2344 | + :conf: Yes |
2345 | + :scope: Global |
2346 | + :dyn: No |
2347 | + :vartype: Numeric |
2348 | + :default: 512 |
2349 | + :units: Bytes |
2350 | + |
2351 | +This variable changes the size of transaction log records. The default size of 512 bytes is good in most situations. However, setting it to 4096 may be a good optimization with SSD cards. While settings other than 512 and 4096 are possible, as a practical matter these are really the only two that it makes sense to use. Clean restart and removal of the old logs is needed for the variable :variable:`innodb_log_block_size` to be changed. |
2352 | + |
2353 | +Status Variables |
2354 | +---------------- |
2355 | + |
2356 | +The following information has been added to ``SHOW ENGINE INNODB STATUS`` to confirm the checkpointing activity: :: |
2357 | + |
2358 | + The max checkpoint age |
2359 | + The current checkpoint age target |
2360 | + The current age of the oldest page modification which has not been flushed to disk yet. |
2361 | + The current age of the last checkpoint |
2362 | + ... |
2363 | + --- |
2364 | + LOG |
2365 | + --- |
2366 | + Log sequence number 0 1059494372 |
2367 | + Log flushed up to 0 1059494372 |
2368 | + Last checkpoint at 0 1055251010 |
2369 | + Max checkpoint age 162361775 |
2370 | + Checkpoint age target 104630090 |
2371 | + Modified age 4092465 |
2372 | + Checkpoint age 4243362 |
2373 | + 0 pending log writes, 0 pending chkp writes |
2374 | + ... |
- Please rebase on the latest trunk that has the file-id fixes. They have touched docs as well.
- Please also use https:/ /code.launchpad .net/~laurynas- biveinis/ percona- server/ 5.6-merge- 4 as a prerequisite branch. It merges more 5.5 revisions, including doc ones.