Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~hrvojem/percona-server/doc-8-5.6-gca into lp:percona-server/5.6

  1. doc-8-5.6-gca
  2. Merge into 5.6
Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Laurynas Biveinis
Approved revision: no longer in the source branch.
Merged at revision: 405
Proposed branch: lp:~hrvojem/percona-server/doc-8-5.6-gca
Merge into: lp:percona-server/5.6
Diff against target: 709 lines (+371/-218)
8 files modified
doc/source/diagnostics/innodb_deadlock_count.rst (+1/-1)
doc/source/diagnostics/innodb_show_status.rst (+221/-216)
doc/source/diagnostics/user_stats.rst (+12/-0)
doc/source/index.rst (+1/-0)
doc/source/performance/atomic_fio.rst (+1/-1)
doc/source/performance/threadpool.rst (+25/-0)
doc/source/ps-variables.rst (+105/-0)
doc/source/scalability/innodb_io.rst (+5/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/doc-8-5.6-gca
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Approve
Review via email: mp+174195@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Same comments as for 5.5 MP + is the change on 547/548 required?

review: Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/diagnostics/innodb_deadlock_count.rst'
2--- doc/source/diagnostics/innodb_deadlock_count.rst 2013-06-03 10:14:58 +0000
3+++ doc/source/diagnostics/innodb_deadlock_count.rst 2013-07-12 08:50:42 +0000
4@@ -44,7 +44,7 @@
5
6 One new status variable was introduced by this feature.
7
8-.. variable:: innodb_deadlocks
9+.. variable:: Innodb_deadlocks
10
11 :vartype: LONG
12 :scope: Global
13
14=== modified file 'doc/source/diagnostics/innodb_show_status.rst'
15--- doc/source/diagnostics/innodb_show_status.rst 2013-06-25 13:13:06 +0000
16+++ doc/source/diagnostics/innodb_show_status.rst 2013-07-12 08:50:42 +0000
17@@ -81,18 +81,23 @@
18 srv_master_thread log flush and writes: 11844
19
20
21-.. variable:: innodb_master_thread_active_loops
22-
23- :version 5.6.11-60.3: Introduced.
24- :vartype: Numeric
25- :scope: Global
26-
27-.. variable:: innodb_master_thread_idle_loops
28-
29- :version 5.6.11-60.3: Introduced.
30- :vartype: Numeric
31- :scope: Global
32-
33+.. variable:: Innodb_master_thread_active_loops
34+
35+ :version 5.6.11-60.3: Introduced.
36+ :vartype: Numeric
37+ :scope: Global
38+
39+.. variable:: Innodb_master_thread_idle_loops
40+
41+ :version 5.6.11-60.3: Introduced.
42+ :vartype: Numeric
43+ :scope: Global
44+
45+.. variable:: Innodb_background_log_sync
46+
47+ :version 5.6.11-60.3: Introduced.
48+ :vartype: Numeric
49+ :scope: Global
50
51 SEMAPHORES
52 ----------
53@@ -107,55 +112,55 @@
54 RW-shared spins 5155, OS waits 1678; RW-excl spins 5632, OS waits 2592
55 Spin rounds per wait: 10.87 mutex, 15.01 RW-shared, 27.19 RW-excl
56
57-.. variable:: innodb_mutex_os_waits
58-
59- :version 5.6.11-60.3: Introduced.
60- :vartype: Numeric
61- :scope: Global
62-
63-.. variable:: innodb_mutex_spin_rounds
64-
65- :version 5.6.11-60.3: Introduced.
66- :vartype: Numeric
67- :scope: Global
68-
69-.. variable:: innodb_mutex_spin_waits
70-
71- :version 5.6.11-60.3: Introduced.
72- :vartype: Numeric
73- :scope: Global
74-
75-.. variable:: innodb_s_lock_os_waits
76-
77- :version 5.6.11-60.3: Introduced.
78- :vartype: Numeric
79- :scope: Global
80-
81-.. variable:: innodb_s_lock_spin_rounds
82-
83- :version 5.6.11-60.3: Introduced.
84- :vartype: Numeric
85- :scope: Global
86-
87-.. variable:: innodb_s_lock_spin_waits
88-
89- :version 5.6.11-60.3: Introduced.
90- :vartype: Numeric
91- :scope: Global
92-
93-.. variable:: innodb_x_lock_os_waits
94-
95- :version 5.6.11-60.3: Introduced.
96- :vartype: Numeric
97- :scope: Global
98-
99-.. variable:: innodb_x_lock_spin_rounds
100-
101- :version 5.6.11-60.3: Introduced.
102- :vartype: Numeric
103- :scope: Global
104-
105-.. variable:: innodb_x_lock_spin_waits
106+.. variable:: Innodb_mutex_os_waits
107+
108+ :version 5.6.11-60.3: Introduced.
109+ :vartype: Numeric
110+ :scope: Global
111+
112+.. variable:: Innodb_mutex_spin_rounds
113+
114+ :version 5.6.11-60.3: Introduced.
115+ :vartype: Numeric
116+ :scope: Global
117+
118+.. variable:: Innodb_mutex_spin_waits
119+
120+ :version 5.6.11-60.3: Introduced.
121+ :vartype: Numeric
122+ :scope: Global
123+
124+.. variable:: Innodb_s_lock_os_waits
125+
126+ :version 5.6.11-60.3: Introduced.
127+ :vartype: Numeric
128+ :scope: Global
129+
130+.. variable:: Innodb_s_lock_spin_rounds
131+
132+ :version 5.6.11-60.3: Introduced.
133+ :vartype: Numeric
134+ :scope: Global
135+
136+.. variable:: Innodb_s_lock_spin_waits
137+
138+ :version 5.6.11-60.3: Introduced.
139+ :vartype: Numeric
140+ :scope: Global
141+
142+.. variable:: Innodb_x_lock_os_waits
143+
144+ :version 5.6.11-60.3: Introduced.
145+ :vartype: Numeric
146+ :scope: Global
147+
148+.. variable:: Innodb_x_lock_spin_rounds
149+
150+ :version 5.6.11-60.3: Introduced.
151+ :vartype: Numeric
152+ :scope: Global
153+
154+.. variable:: Innodb_x_lock_spin_waits
155
156 :version 5.6.11-60.3: Introduced.
157 :vartype: Numeric
158@@ -173,61 +178,61 @@
159 44497 inserts, 44497 merged recs, 8734 merges
160 0.00 hash searches/s, 0.00 non-hash searches/s
161
162-.. variable:: innodb_ibuf_discarded_delete_marks
163-
164- :version 5.6.11-60.3: Introduced.
165- :vartype: Numeric
166- :scope: Global
167-
168-.. variable:: innodb_ibuf_discarded_deletes
169-
170- :version 5.6.11-60.3: Introduced.
171- :vartype: Numeric
172- :scope: Global
173-
174-.. variable:: innodb_ibuf_discarded_inserts
175-
176- :version 5.6.11-60.3: Introduced.
177- :vartype: Numeric
178- :scope: Global
179-
180-.. variable:: innodb_ibuf_free_list
181-
182- :version 5.6.11-60.3: Introduced.
183- :vartype: Numeric
184- :scope: Global
185-
186-.. variable:: innodb_ibuf_merged_delete_marks
187-
188- :version 5.6.11-60.3: Introduced.
189- :vartype: Numeric
190- :scope: Global
191-
192-.. variable:: innodb_ibuf_merged_deletes
193-
194- :version 5.6.11-60.3: Introduced.
195- :vartype: Numeric
196- :scope: Global
197-
198-.. variable:: innodb_ibuf_merged_inserts
199-
200- :version 5.6.11-60.3: Introduced.
201- :vartype: Numeric
202- :scope: Global
203-
204-.. variable:: innodb_ibuf_merges
205-
206- :version 5.6.11-60.3: Introduced.
207- :vartype: Numeric
208- :scope: Global
209-
210-.. variable:: innodb_ibuf_segment_size
211-
212- :version 5.6.11-60.3: Introduced.
213- :vartype: Numeric
214- :scope: Global
215-
216-.. variable:: innodb_ibuf_size
217+.. variable:: Innodb_ibuf_discarded_delete_marks
218+
219+ :version 5.6.11-60.3: Introduced.
220+ :vartype: Numeric
221+ :scope: Global
222+
223+.. variable:: Innodb_ibuf_discarded_deletes
224+
225+ :version 5.6.11-60.3: Introduced.
226+ :vartype: Numeric
227+ :scope: Global
228+
229+.. variable:: Innodb_ibuf_discarded_inserts
230+
231+ :version 5.6.11-60.3: Introduced.
232+ :vartype: Numeric
233+ :scope: Global
234+
235+.. variable:: Innodb_ibuf_free_list
236+
237+ :version 5.6.11-60.3: Introduced.
238+ :vartype: Numeric
239+ :scope: Global
240+
241+.. variable:: Innodb_ibuf_merged_delete_marks
242+
243+ :version 5.6.11-60.3: Introduced.
244+ :vartype: Numeric
245+ :scope: Global
246+
247+.. variable:: Innodb_ibuf_merged_deletes
248+
249+ :version 5.6.11-60.3: Introduced.
250+ :vartype: Numeric
251+ :scope: Global
252+
253+.. variable:: Innodb_ibuf_merged_inserts
254+
255+ :version 5.6.11-60.3: Introduced.
256+ :vartype: Numeric
257+ :scope: Global
258+
259+.. variable:: Innodb_ibuf_merges
260+
261+ :version 5.6.11-60.3: Introduced.
262+ :vartype: Numeric
263+ :scope: Global
264+
265+.. variable:: Innodb_ibuf_segment_size
266+
267+ :version 5.6.11-60.3: Introduced.
268+ :vartype: Numeric
269+ :scope: Global
270+
271+.. variable:: Innodb_ibuf_size
272
273 :version 5.6.11-60.3: Introduced.
274 :vartype: Numeric
275@@ -254,31 +259,31 @@
276 Log tracked up to 10145937666
277 Max tracked LSN age 80826164
278
279-.. variable:: innodb_lsn_current
280-
281- :version 5.6.11-60.3: Introduced.
282- :vartype: Numeric
283- :scope: Global
284-
285-.. variable:: innodb_lsn_flushed
286-
287- :version 5.6.11-60.3: Introduced.
288- :vartype: Numeric
289- :scope: Global
290-
291-.. variable:: innodb_lsn_last_checkpoint
292-
293- :version 5.6.11-60.3: Introduced.
294- :vartype: Numeric
295- :scope: Global
296-
297-.. variable:: innodb_checkpoint_age
298-
299- :version 5.6.11-60.3: Introduced.
300- :vartype: Numeric
301- :scope: Global
302-
303-.. variable:: innodb_checkpoint_max_age
304+.. variable:: Innodb_lsn_current
305+
306+ :version 5.6.11-60.3: Introduced.
307+ :vartype: Numeric
308+ :scope: Global
309+
310+.. variable:: Innodb_lsn_flushed
311+
312+ :version 5.6.11-60.3: Introduced.
313+ :vartype: Numeric
314+ :scope: Global
315+
316+.. variable:: Innodb_lsn_last_checkpoint
317+
318+ :version 5.6.11-60.3: Introduced.
319+ :vartype: Numeric
320+ :scope: Global
321+
322+.. variable:: Innodb_checkpoint_age
323+
324+ :version 5.6.11-60.3: Introduced.
325+ :vartype: Numeric
326+ :scope: Global
327+
328+.. variable:: Innodb_checkpoint_max_age
329
330 :version 5.6.11-60.3: Introduced.
331 :vartype: Numeric
332@@ -319,49 +324,49 @@
333 LRU len: 707, unzip_LRU len: 0
334
335
336-.. variable:: innodb_mem_adaptive_hash
337-
338- :version 5.6.11-60.3: Introduced.
339- :vartype: Numeric
340- :scope: Global
341-
342-.. variable:: innodb_mem_dictionary
343-
344- :version 5.6.11-60.3: Introduced.
345- :vartype: Numeric
346- :scope: Global
347-
348-.. variable:: innodb_mem_total
349-
350- :version 5.6.11-60.3: Introduced.
351- :vartype: Numeric
352- :scope: Global
353-
354-.. variable:: innodb_buffer_pool_pages_LRU_flushed
355-
356- :version 5.6.11-60.3: Introduced.
357- :vartype: Numeric
358- :scope: Global
359-
360-.. variable:: innodb_buffer_pool_pages_made_not_young
361-
362- :version 5.6.11-60.3: Introduced.
363- :vartype: Numeric
364- :scope: Global
365-
366-.. variable:: innodb_buffer_pool_pages_made_young
367-
368- :version 5.6.11-60.3: Introduced.
369- :vartype: Numeric
370- :scope: Global
371-
372-.. variable:: innodb_buffer_pool_pages_old
373-
374- :version 5.6.11-60.3: Introduced.
375- :vartype: Numeric
376- :scope: Global
377-
378-.. variable:: innodb_descriptors_memory
379+.. variable:: Innodb_mem_adaptive_hash
380+
381+ :version 5.6.11-60.3: Introduced.
382+ :vartype: Numeric
383+ :scope: Global
384+
385+.. variable:: Innodb_mem_dictionary
386+
387+ :version 5.6.11-60.3: Introduced.
388+ :vartype: Numeric
389+ :scope: Global
390+
391+.. variable:: Innodb_mem_total
392+
393+ :version 5.6.11-60.3: Introduced.
394+ :vartype: Numeric
395+ :scope: Global
396+
397+.. variable:: Innodb_buffer_pool_pages_LRU_flushed
398+
399+ :version 5.6.11-60.3: Introduced.
400+ :vartype: Numeric
401+ :scope: Global
402+
403+.. variable:: Innodb_buffer_pool_pages_made_not_young
404+
405+ :version 5.6.11-60.3: Introduced.
406+ :vartype: Numeric
407+ :scope: Global
408+
409+.. variable:: Innodb_buffer_pool_pages_made_young
410+
411+ :version 5.6.11-60.3: Introduced.
412+ :vartype: Numeric
413+ :scope: Global
414+
415+.. variable:: Innodb_buffer_pool_pages_old
416+
417+ :version 5.6.11-60.3: Introduced.
418+ :vartype: Numeric
419+ :scope: Global
420+
421+.. variable:: Innodb_descriptors_memory
422
423 :version 5.6.11-60.3: Introduced.
424 :vartype: Numeric
425@@ -369,7 +374,7 @@
426
427 This status variable shows the current size of the descriptors array (in bytes). The descriptor array is an |XtraDB| data structure that contains the information on currently running transactions.
428
429-.. variable:: innodb_read_views_memory
430+.. variable:: Innodb_read_views_memory
431
432 :version 5.6.11-60.3: Introduced.
433 :vartype: Numeric
434@@ -396,37 +401,37 @@
435 mysql tables in use 1, locked 1
436
437
438-.. variable:: innodb_history_list_length
439-
440- :version 5.6.11-60.3: Introduced.
441- :vartype: Numeric
442- :scope: Global
443-
444-.. variable:: innodb_max_trx_id
445-
446- :version 5.6.11-60.3: Introduced.
447- :vartype: Numeric
448- :scope: Global
449-
450-.. variable:: innodb_oldest_view_low_limit_trx_id
451-
452- :version 5.6.11-60.3: Introduced.
453- :vartype: Numeric
454- :scope: Global
455-
456-.. variable:: innodb_purge_trx_id
457-
458- :version 5.6.11-60.3: Introduced.
459- :vartype: Numeric
460- :scope: Global
461-
462-.. variable:: innodb_purge_undo_no
463-
464- :version 5.6.11-60.3: Introduced.
465- :vartype: Numeric
466- :scope: Global
467-
468-.. variable:: innodb_current_row_locks
469+.. variable:: Innodb_history_list_length
470+
471+ :version 5.6.11-60.3: Introduced.
472+ :vartype: Numeric
473+ :scope: Global
474+
475+.. variable:: Innodb_max_trx_id
476+
477+ :version 5.6.11-60.3: Introduced.
478+ :vartype: Numeric
479+ :scope: Global
480+
481+.. variable:: Innodb_oldest_view_low_limit_trx_id
482+
483+ :version 5.6.11-60.3: Introduced.
484+ :vartype: Numeric
485+ :scope: Global
486+
487+.. variable:: Innodb_purge_trx_id
488+
489+ :version 5.6.11-60.3: Introduced.
490+ :vartype: Numeric
491+ :scope: Global
492+
493+.. variable:: Innodb_purge_undo_no
494+
495+ :version 5.6.11-60.3: Introduced.
496+ :vartype: Numeric
497+ :scope: Global
498+
499+.. variable:: Innodb_current_row_locks
500
501 :version 5.6.11-60.3: Introduced.
502 :vartype: Numeric
503
504=== modified file 'doc/source/diagnostics/user_stats.rst'
505--- doc/source/diagnostics/user_stats.rst 2013-06-03 10:14:58 +0000
506+++ doc/source/diagnostics/user_stats.rst 2013-07-12 08:50:42 +0000
507@@ -37,6 +37,18 @@
508
509 Enables or disables collection of statistics. The default is ``OFF``, meaning no statistics are gathered. This is to ensure that the statistics collection doesn't cause any extra load on the server unless desired.
510
511+.. variable:: thread_statistics
512+
513+ :version 5.6.11-60.3: Feature ported from |Percona Server| 5.5
514+ :cli: Yes
515+ :conf: Yes
516+ :scope: Global
517+ :dyn: Yes
518+ :vartype: BOOLEAN
519+ :default: OFF
520+ :range: ON/OFF
521+
522+Enables or disables collection of thread statistics. The default is ``OFF``, meaning no thread statistics are gathered. This is to ensure that the statistics collection doesn't cause any extra load on the server unless desired. Variable :variable:`userstat` needs to be enabled as well in order for thread statistics to be collected.
523
524 INFORMATION_SCHEMA Tables
525 =========================
526
527=== modified file 'doc/source/index.rst'
528--- doc/source/index.rst 2013-06-25 13:13:06 +0000
529+++ doc/source/index.rst 2013-07-12 08:50:42 +0000
530@@ -141,6 +141,7 @@
531 :glob:
532
533 upstream-bug-fixes
534+ ps-variables
535 development
536 trademark-policy
537 index_info_schema_tables
538
539=== modified file 'doc/source/performance/atomic_fio.rst'
540--- doc/source/performance/atomic_fio.rst 2013-06-25 13:13:06 +0000
541+++ doc/source/performance/atomic_fio.rst 2013-07-12 08:50:42 +0000
542@@ -37,7 +37,7 @@
543
544 Other Reading
545 =============
546-
547+
548 * For general |InnoDB| tuning :ref:`innodb_io_page` documentation is available.
549
550 * `FusionIO DirectFS atomic write support in *MariaDB* <https://kb.askmonty.org/en/fusionio-directfs-atomic-write-support/>`_
551
552=== modified file 'doc/source/performance/threadpool.rst'
553--- doc/source/performance/threadpool.rst 2013-05-27 03:01:29 +0000
554+++ doc/source/performance/threadpool.rst 2013-07-12 08:50:42 +0000
555@@ -121,6 +121,31 @@
556
557 The number of milliseconds before a running thread is considered stalled. When this limit is reached thread pool will wake up or create another thread. This is being used to prevent a long-running query from monopolizing the pool.
558
559+.. variable:: extra_port
560+
561+ :cli: Yes
562+ :conf: Yes
563+ :scope: Global
564+ :dyn: No
565+ :vartype: Numeric
566+ :default: 0
567+
568+This variable can be used to specify additional port |Percona Server| will listen on. This can be used in case no new connections can be established due to all worker threads being busy or being locked when ``pool-of-threads`` feature is enabled. To connect to the extra port following command can be used: ::
569+
570+ mysql --port='extra-port-number' --protocol=tcp
571+
572+
573+.. variable:: extra_max_connections
574+
575+ :cli: Yes
576+ :conf: Yes
577+ :scope: Global
578+ :dyn: Yes
579+ :vartype: Numeric
580+ :default: 1
581+
582+This variable can be used to specify the maximum allowed number of connections on the extra port. This can be used with the :variable:`extra_port` variable to access the server in case no new connections can be established due to all worker threads being busy or being locked when ``pool-of-threads`` feature is enabled.
583+
584 Status Variables
585 =====================
586
587
588=== added file 'doc/source/ps-variables.rst'
589--- doc/source/ps-variables.rst 1970-01-01 00:00:00 +0000
590+++ doc/source/ps-variables.rst 2013-07-12 08:50:42 +0000
591@@ -0,0 +1,105 @@
592+.. _ps_variables:
593+
594+====================================================
595+ List of variables introduced in Percona Server 5.5
596+====================================================
597+
598+System Variables
599+================
600+
601+* :variable:`enforce_storage_engine`
602+* :variable:`expand_fast_index_creation`
603+* :variable:`extra_max_connections`
604+* :variable:`extra_port`
605+* :variable:`innodb_buffer_pool_populate`
606+* :variable:`innodb_corrupt_table_action`
607+* :variable:`innodb_fake_changes`
608+* :variable:`innodb_kill_idle_transaction`
609+* :variable:`innodb_locking_fake_changes`
610+* :variable:`innodb_log_arch_dir`
611+* :variable:`innodb_log_arch_expire_sec`
612+* :variable:`innodb_log_archive`
613+* :variable:`innodb_log_block_size`
614+* :variable:`innodb_max_bitmap_file_size`
615+* :variable:`innodb_max_changed_pages`
616+* :variable:`innodb_show_locks_held`
617+* :variable:`innodb_show_verbose_locks`
618+* :variable:`innodb_track_changed_pages`
619+* :variable:`innodb_use_atomic_writes`
620+* :variable:`innodb_use_global_flush_log_at_trx_commit`
621+* :variable:`log_slow_filter`
622+* :variable:`log_slow_rate_limit`
623+* :variable:`log_slow_rate_type`
624+* :variable:`log_slow_sp_statements`
625+* :variable:`log_slow_verbosity`
626+* :variable:`log_warnings_suppress`
627+* :variable:`max_binlog_files`
628+* :variable:`query_cache_strip_comments`
629+* :variable:`slow_query_log_timestamp_always`
630+* :variable:`slow_query_log_timestamp_precision`
631+* :variable:`slow_query_log_use_global_control`
632+* :variable:`thread_pool_high_prio_tickets`
633+* :variable:`thread_pool_idle_timeout`
634+* :variable:`thread_pool_max_threads`
635+* :variable:`thread_pool_oversubscribe`
636+* :variable:`thread_pool_size`
637+* :variable:`thread_pool_stall_limit`
638+* :variable:`thread_statistics`
639+* :variable:`userstat`
640+
641+Status Variables
642+================
643+
644+* :variable:`Com_purge_archived`
645+* :variable:`Com_purge_archived_before_date`
646+* :variable:`Com_show_client_statistics`
647+* :variable:`Com_show_index_statistics`
648+* :variable:`Com_show_slave_status_nolock`
649+* :variable:`Com_show_table_statistics`
650+* :variable:`Com_show_thread_statistics`
651+* :variable:`Com_show_user_statistics`
652+* :variable:`Innodb_background_log_sync`
653+* :variable:`Innodb_buffer_pool_pages_LRU_flushed`
654+* :variable:`Innodb_buffer_pool_pages_made_not_young`
655+* :variable:`Innodb_buffer_pool_pages_made_young`
656+* :variable:`Innodb_buffer_pool_pages_old`
657+* :variable:`Innodb_checkpoint_age`
658+* :variable:`Innodb_checkpoint_max_age`
659+* :variable:`Innodb_deadlocks`
660+* :variable:`Innodb_history_list_length`
661+* :variable:`Innodb_ibuf_discarded_delete_marks`
662+* :variable:`Innodb_ibuf_discarded_deletes`
663+* :variable:`Innodb_ibuf_discarded_inserts`
664+* :variable:`Innodb_ibuf_free_list`
665+* :variable:`Innodb_ibuf_merged_delete_marks`
666+* :variable:`Innodb_ibuf_merged_deletes`
667+* :variable:`Innodb_ibuf_merged_inserts`
668+* :variable:`Innodb_ibuf_merges`
669+* :variable:`Innodb_ibuf_segment_size`
670+* :variable:`Innodb_ibuf_size`
671+* :variable:`Innodb_lsn_current`
672+* :variable:`Innodb_lsn_flushed`
673+* :variable:`Innodb_lsn_last_checkpoint`
674+* :variable:`Innodb_master_thread_active_loops`
675+* :variable:`Innodb_master_thread_idle_loops`
676+* :variable:`Innodb_max_trx_id`
677+* :variable:`Innodb_mem_adaptive_hash`
678+* :variable:`Innodb_mem_dictionary`
679+* :variable:`Innodb_mem_total`
680+* :variable:`Innodb_mutex_os_waits`
681+* :variable:`Innodb_mutex_spin_rounds`
682+* :variable:`Innodb_mutex_spin_waits`
683+* :variable:`Innodb_oldest_view_low_limit_trx_id`
684+* :variable:`Innodb_purge_trx_id`
685+* :variable:`Innodb_purge_undo_no`
686+* :variable:`Innodb_current_row_locks`
687+* :variable:`Innodb_read_views_memory`
688+* :variable:`Innodb_descriptors_memory`
689+* :variable:`Innodb_s_lock_os_waits`
690+* :variable:`Innodb_s_lock_spin_rounds`
691+* :variable:`Innodb_s_lock_spin_waits`
692+* :variable:`Innodb_x_lock_os_waits`
693+* :variable:`Innodb_x_lock_spin_rounds`
694+* :variable:`Innodb_x_lock_spin_waits`
695+* :variable:`Threadpool_idle_threads`
696+* :variable:`Threadpool_threads`
697
698=== modified file 'doc/source/scalability/innodb_io.rst'
699--- doc/source/scalability/innodb_io.rst 2013-06-03 10:01:08 +0000
700+++ doc/source/scalability/innodb_io.rst 2013-07-12 08:50:42 +0000
701@@ -69,3 +69,8 @@
702 Checkpoint age 4243362
703 0 pending log writes, 0 pending chkp writes
704 ...
705+
706+Other Reading
707+=============
708+
709+ * For Fusion-IO devices-specific tuning, see :ref:`atomic_fio` documentation.

Subscribers

People subscribed via source and target branches