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

[Hrvoje Matijakovic]

[Laurynas Biveinis (laurynas-biveinis)]

extra_max_connections: maybe it's easier just to say this this a maximum allowed number of connections on the extra port.

Diff line 877 redundant or required?

review: Needs Fixing

[Laurynas Biveinis (laurynas-biveinis)]

review: Approve

[Alexey Kopytov (akopytov)]

On Fri, 12 Jul 2013 04:55:30 -0000, Laurynas Biveinis wrote:
>
> extra_max_connections: maybe it's easier just to say this this a maximum allowed number of connections on the extra port.
>

That's not entirely correct either. Reported bug #1201381 and bug #1201377.

=== modified file '.bzrignore'
--- .bzrignore	2012-09-04 23:24:39 +0000
+++ .bzrignore	2013-07-12 08:08:27 +0000
@@ -1,3 +1,4 @@
 build
 .pc
 Makefile.in
+doc/source/ext/psdom.pyc

=== modified file 'doc/source/diagnostics/innodb_deadlock_count.rst'
--- doc/source/diagnostics/innodb_deadlock_count.rst	2013-05-27 13:46:13 +0000
+++ doc/source/diagnostics/innodb_deadlock_count.rst	2013-07-12 08:08:27 +0000
@@ -44,7 +44,7 @@
 
 One new status variable was introduced by this feature.
 
-.. variable:: innodb_deadlocks
+.. variable:: Innodb_deadlocks
 
      :vartype: LONG
      :scope: Global

=== modified file 'doc/source/diagnostics/innodb_show_status.rst'
--- doc/source/diagnostics/innodb_show_status.rst	2013-05-24 11:15:16 +0000
+++ doc/source/diagnostics/innodb_show_status.rst	2013-07-12 08:08:27 +0000
@@ -83,37 +83,37 @@
 
  Insert an example of BACKGROUND THREAD section output here.
 
-.. variable:: innodb_master_thread_1_second_loops
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_master_thread_10_second_loops
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_master_thread_background_loops
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_master_thread_main_flush_loops
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_master_thread_sleeps
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_background_log_sync
+.. variable:: Innodb_master_thread_1_second_loops
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_master_thread_10_second_loops
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_master_thread_background_loops
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_master_thread_main_flush_loops
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_master_thread_sleeps
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_background_log_sync
 
      :version 5.5.8-20.0: Introduced.
      :vartype: Numeric
@@ -132,55 +132,55 @@
   RW-shared spins 5155, OS waits 1678; RW-excl spins 5632, OS waits 2592
   Spin rounds per wait: 10.87 mutex, 15.01 RW-shared, 27.19 RW-excl
 
-.. variable:: innodb_mutex_os_waits
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_mutex_spin_rounds
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_mutex_spin_waits
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_s_lock_os_waits
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_s_lock_spin_rounds
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_s_lock_spin_waits
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_x_lock_os_waits
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_x_lock_spin_rounds
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_x_lock_spin_waits
+.. variable:: Innodb_mutex_os_waits
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_mutex_spin_rounds
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_mutex_spin_waits
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_s_lock_os_waits
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_s_lock_spin_rounds
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_s_lock_spin_waits
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_x_lock_os_waits
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_x_lock_spin_rounds
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_x_lock_spin_waits
 
      :version 5.5.8-20.0: Introduced.
      :vartype: Numeric
@@ -199,85 +199,85 @@
   Hash table size 276707, node heap has 1 buffer(s)
   0.00 hash searches/s, 0.00 non-hash searches/s
 
-.. variable:: innodb_ibuf_discarded_delete_marks
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_discarded_deletes
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_discarded_inserts
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_free_list
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_merged_delete_marks
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_merged_deletes
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_merged_inserts
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_merges
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_segment_size
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_ibuf_size
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_adaptive_hash_cells
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_adaptive_hash_heap_buffers
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_adaptive_hash_hash_searches
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_adaptive_hash_non_hash_searches
+.. variable:: Innodb_ibuf_discarded_delete_marks
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_discarded_deletes
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_discarded_inserts
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_free_list
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_merged_delete_marks
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_merged_deletes
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_merged_inserts
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_merges
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_segment_size
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_ibuf_size
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_adaptive_hash_cells
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_adaptive_hash_heap_buffers
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_adaptive_hash_hash_searches
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_adaptive_hash_non_hash_searches
 
      :version 5.5.8-20.0: Introduced.
      :vartype: Numeric
@@ -301,37 +301,37 @@
   0 pending log writes, 0 pending chkp writes
   8570 log i/o's done, 2000.00 log i/o's/second
 
-.. variable:: innodb_lsn_current
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_lsn_flushed
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_lsn_last_checkpoint
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_checkpoint_age
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_checkpoint_max_age
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_checkpoint_target_age
+.. variable:: Innodb_lsn_current
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_lsn_flushed
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_lsn_last_checkpoint
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_checkpoint_age
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_checkpoint_max_age
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_checkpoint_target_age
 
      :version 5.5.8-20.0: Introduced.
      :vartype: Numeric
@@ -372,49 +372,49 @@
   Pages read ahead 0.00/s, evicted without access 15000.00/s
 
 
-.. variable:: innodb_mem_adaptive_hash
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_mem_dictionary
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_mem_total
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_buffer_pool_pages_LRU_flushed
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_buffer_pool_pages_made_not_young
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_buffer_pool_pages_made_young
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_buffer_pool_pages_old
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_descriptors_memory
+.. variable:: Innodb_mem_adaptive_hash
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_mem_dictionary
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_mem_total
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_buffer_pool_pages_LRU_flushed
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_buffer_pool_pages_made_not_young
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_buffer_pool_pages_made_young
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_buffer_pool_pages_old
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_descriptors_memory
 
      :version 5.5.31-30.3: Introduced.
      :vartype: Numeric
@@ -422,7 +422,7 @@
 
 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.
 
-.. variable:: innodb_read_views_memory
+.. variable:: Innodb_read_views_memory
 
      :version 5.5.31-30.3: Introduced.
      :vartype: Numeric
@@ -465,37 +465,37 @@
   ---TRANSACTION F561FC, ACTIVE 29 sec, process no 993, OS thread id 140213152769808 updating or deleting
   mysql tables in use 1, locked 1
 
-.. variable:: innodb_history_list_length
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_max_trx_id
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_oldest_view_low_limit_trx_id
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_purge_trx_id
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_purge_undo_no
-
-     :version 5.5.8-20.0: Introduced.
-     :vartype: Numeric
-     :scope: Global
-
-.. variable:: innodb_current_row_locks
+.. variable:: Innodb_history_list_length
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_max_trx_id
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_oldest_view_low_limit_trx_id
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_purge_trx_id
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_purge_undo_no
+
+     :version 5.5.8-20.0: Introduced.
+     :vartype: Numeric
+     :scope: Global
+
+.. variable:: Innodb_current_row_locks
 
      :version 5.5.8-20.0: Introduced.
      :version 5.5.10-20.1: Renamed.

=== modified file 'doc/source/diagnostics/user_stats.rst'
--- doc/source/diagnostics/user_stats.rst	2013-05-27 13:46:13 +0000
+++ doc/source/diagnostics/user_stats.rst	2013-07-12 08:08:27 +0000
@@ -26,9 +26,9 @@
 System Variables
 ================
 
-.. variable:: userstat_running
+.. variable:: userstat
 
-     :version 5.5.10-20.1: Renamed to :variable:`userstat`
+     :version 5.5.10-20.1: Renamed from :variable:`userstat_running`
      :cli: Yes
      :conf: Yes
      :scope: Global
@@ -39,6 +39,22 @@
 
 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.
 
+.. variable:: thread_statistics
+
+     :version 5.5.8-20.0: Feature ported from |Percona Server| 5.1
+     :cli: Yes
+     :conf: Yes
+     :scope: Global
+     :dyn: Yes
+     :vartype: BOOLEAN
+     :default: OFF
+     :range: ON/OFF
+
+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.
+
+.. note::
+
+ In Percona Server 5.5 :variable:`thread_statistics` is a reserved word. Which means you have to quote it when using the system variable with the same name: ``mysql> set global `thread_statistics`=1;``
 
 INFORMATION_SCHEMA Tables
 =========================

=== modified file 'doc/source/index.rst'
--- doc/source/index.rst	2013-06-13 05:08:08 +0000
+++ doc/source/index.rst	2013-07-12 08:08:27 +0000
@@ -172,6 +172,7 @@
    development
    trademark-policy
    upstream-bug-fixes
+   ps-variables
    index_info_schema_tables
    faq
    copyright

=== modified file 'doc/source/management/innodb_dict_size_limit.rst'
--- doc/source/management/innodb_dict_size_limit.rst	2013-05-27 13:46:13 +0000
+++ doc/source/management/innodb_dict_size_limit.rst	2013-07-12 08:08:27 +0000
@@ -42,7 +42,7 @@
 The following status variable was introduced by this feature:
 
 
-.. variable:: innodb_dict_tables
+.. variable:: Innodb_dict_tables
 
      :vartype: LONG
      :scope: Global

=== modified file 'doc/source/performance/atomic_fio.rst'
--- doc/source/performance/atomic_fio.rst	2013-05-24 11:15:16 +0000
+++ doc/source/performance/atomic_fio.rst	2013-07-12 08:08:27 +0000
@@ -37,6 +37,8 @@
 
 Other Reading
 =============
+ 
+ * For general |InnoDB| tuning :ref:`innodb_io_page` documentation is available.
 
  * `FusionIO DirectFS atomic write support in *MariaDB* <https://kb.askmonty.org/en/fusionio-directfs-atomic-write-support/>`_
 

=== modified file 'doc/source/performance/threadpool.rst'
--- doc/source/performance/threadpool.rst	2013-04-10 13:06:55 +0000
+++ doc/source/performance/threadpool.rst	2013-07-12 08:08:27 +0000
@@ -121,6 +121,31 @@
 
 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.
 
+.. variable:: extra_port
+      
+     :cli: Yes
+     :conf: Yes
+     :scope: Global
+     :dyn: No
+     :vartype: Numeric
+     :default: 0
+
+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: ::
+
+  mysql --port='extra-port-number' --protocol=tcp
+
+
+.. variable:: extra_max_connections
+      
+     :cli: Yes
+     :conf: Yes
+     :scope: Global
+     :dyn: Yes
+     :vartype: Numeric
+     :default: 1
+     
+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.
+
 Status Variables
 =====================
 

=== added file 'doc/source/ps-variables.rst'
--- doc/source/ps-variables.rst	1970-01-01 00:00:00 +0000
+++ doc/source/ps-variables.rst	2013-07-12 08:08:27 +0000
@@ -0,0 +1,146 @@
+.. _ps_variables:
+
+====================================================
+ List of variables introduced in Percona Server 5.5
+====================================================
+
+System Variables
+================
+
+* :variable:`enforce_storage_engine`
+* :variable:`expand_fast_index_creation`
+* :variable:`extra_max_connections`
+* :variable:`extra_port`
+* :variable:`fast_index_creation`
+* :variable:`have_flashcache`
+* :variable:`have_response_time_distribution`
+* :variable:`innodb_adaptive_flushing_method`
+* :variable:`innodb_adaptive_hash_index_partitions`
+* :variable:`innodb_blocking_buffer_pool_restore`
+* :variable:`innodb_buffer_pool_populate`
+* :variable:`innodb_buffer_pool_restore_at_startup`
+* :variable:`innodb_buffer_pool_shm_checksum`
+* :variable:`innodb_buffer_pool_shm_key`
+* :variable:`innodb_checkpoint_age_target`
+* :variable:`innodb_corrupt_table_action`
+* :variable:`innodb_dict_size_limit`
+* :variable:`innodb_doublewrite_file`
+* :variable:`innodb_fake_changes`
+* :variable:`innodb_fast_checksum`
+* :variable:`innodb_flush_neighbor_pages`
+* :variable:`innodb_ibuf_accel_rate`
+* :variable:`innodb_ibuf_active_contract`
+* :variable:`innodb_ibuf_max_size`
+* :variable:`innodb_import_table_from_xtrabackup`
+* :variable:`innodb_kill_idle_transaction`
+* :variable:`innodb_lazy_drop_table`
+* :variable:`innodb_locking_fake_changes`
+* :variable:`innodb_log_block_size`
+* :variable:`innodb_max_bitmap_file_size`
+* :variable:`innodb_max_changed_pages`
+* :variable:`innodb_merge_sort_block_size`
+* :variable:`innodb_page_size`
+* :variable:`innodb_read_ahead`
+* :variable:`innodb_recovery_stats`
+* :variable:`innodb_recovery_update_relay_log`
+* :variable:`innodb_show_locks_held`
+* :variable:`innodb_show_verbose_locks`
+* :variable:`innodb_stats_auto_update`
+* :variable:`innodb_stats_update_need_lock`
+* :variable:`innodb_thread_concurrency_timer_based`
+* :variable:`innodb_track_changed_pages`
+* :variable:`innodb_use_atomic_writes`
+* :variable:`innodb_use_global_flush_log_at_trx_commit`
+* :variable:`innodb_use_sys_stats_table`
+* :variable:`log_slow_admin_statements`
+* :variable:`log_slow_filter`
+* :variable:`log_slow_rate_limit`
+* :variable:`log_slow_rate_type`
+* :variable:`log_slow_slave_statements`
+* :variable:`log_slow_sp_statements`
+* :variable:`log_slow_verbosity`
+* :variable:`log_warnings_suppress`
+* :variable:`max_binlog_files`
+* :variable:`optimizer_fix`
+* :variable:`query_cache_strip_comments`
+* :variable:`query_response_time_range_base`
+* :variable:`query_response_time_stats`
+* :variable:`slow_query_log_timestamp_always`
+* :variable:`slow_query_log_timestamp_precision`
+* :variable:`slow_query_log_use_global_control`
+* :variable:`thread_pool_high_prio_tickets`
+* :variable:`thread_pool_idle_timeout`
+* :variable:`thread_pool_max_threads`
+* :variable:`thread_pool_oversubscribe`
+* :variable:`thread_pool_size`
+* :variable:`thread_pool_stall_limit`
+* :variable:`thread_statistics`
+* :variable:`userstat`
+
+Status Variables
+================
+
+* :variable:`Com_show_client_statistics`
+* :variable:`Com_show_index_statistics`
+* :variable:`Com_show_slave_status_nolock`
+* :variable:`Com_show_table_statistics`
+* :variable:`Com_show_temporary_tables`
+* :variable:`Com_show_thread_statistics`
+* :variable:`Com_show_user_statistics`
+* :variable:`Flashcache_enabled`
+* :variable:`Innodb_adaptive_hash_cells`
+* :variable:`Innodb_adaptive_hash_heap_buffers`
+* :variable:`Innodb_adaptive_hash_hash_searches`
+* :variable:`Innodb_adaptive_hash_non_hash_searches`
+* :variable:`Innodb_background_log_sync`
+* :variable:`Innodb_buffer_pool_pages_LRU_flushed`
+* :variable:`Innodb_buffer_pool_pages_made_not_young`
+* :variable:`Innodb_buffer_pool_pages_made_young`
+* :variable:`Innodb_buffer_pool_pages_old`
+* :variable:`Innodb_checkpoint_age`
+* :variable:`Innodb_checkpoint_max_age`
+* :variable:`Innodb_checkpoint_target_age`
+* :variable:`Innodb_deadlocks`
+* :variable:`Innodb_dict_tables`
+* :variable:`Innodb_history_list_length`
+* :variable:`Innodb_ibuf_discarded_delete_marks`
+* :variable:`Innodb_ibuf_discarded_deletes`
+* :variable:`Innodb_ibuf_discarded_inserts`
+* :variable:`Innodb_ibuf_free_list`
+* :variable:`Innodb_ibuf_merged_delete_marks`
+* :variable:`Innodb_ibuf_merged_deletes`
+* :variable:`Innodb_ibuf_merged_inserts`
+* :variable:`Innodb_ibuf_merges`
+* :variable:`Innodb_ibuf_segment_size`
+* :variable:`Innodb_ibuf_size`
+* :variable:`Innodb_lsn_current`
+* :variable:`Innodb_lsn_flushed`
+* :variable:`Innodb_lsn_last_checkpoint`
+* :variable:`Innodb_master_thread_1_second_loops`
+* :variable:`Innodb_master_thread_10_second_loops`
+* :variable:`Innodb_master_thread_background_loops`
+* :variable:`Innodb_master_thread_main_flush_loops`
+* :variable:`Innodb_master_thread_sleeps`
+* :variable:`Innodb_max_trx_id`
+* :variable:`Innodb_mem_adaptive_hash`
+* :variable:`Innodb_mem_dictionary`
+* :variable:`Innodb_mem_total`
+* :variable:`Innodb_mutex_os_waits`
+* :variable:`Innodb_mutex_spin_rounds`
+* :variable:`Innodb_mutex_spin_waits`
+* :variable:`Innodb_oldest_view_low_limit_trx_id`
+* :variable:`Innodb_purge_trx_id`
+* :variable:`Innodb_purge_undo_no`
+* :variable:`Innodb_current_row_locks`
+* :variable:`Innodb_read_views_memory`
+* :variable:`Innodb_descriptors_memory`
+* :variable:`Innodb_s_lock_os_waits`
+* :variable:`Innodb_s_lock_spin_rounds`
+* :variable:`Innodb_s_lock_spin_waits`
+* :variable:`Innodb_x_lock_os_waits`
+* :variable:`Innodb_x_lock_spin_rounds`
+* :variable:`Innodb_x_lock_spin_waits`
+* :variable:`Threadpool_idle_threads`
+* :variable:`Threadpool_threads`
+* :variable:`binlog_commits`
+* :variable:`binlog_group_commits`

=== modified file 'doc/source/scalability/innodb_io_55.rst'
--- doc/source/scalability/innodb_io_55.rst	2013-03-08 12:42:38 +0000
+++ doc/source/scalability/innodb_io_55.rst	2013-07-12 08:08:27 +0000
@@ -96,26 +96,6 @@
 It is not needed to shrink ``innodb_log_file_size`` to tune recovery time.
 
 
-.. variable:: innodb_enable_unsafe_group_commit
-
-   This variable is not needed after |XtraDB| 1.0.5.
-
-   :cli: Yes
-   :conf: Yes
-   :scope: Global
-   :dyn: Yes
-   :vartype: Numeric
-   :default: 0
-   :range: 0 - 1
-
-This variable allows you to change the default behavior of |InnoDB| concerning the synchronization between the transaction logs and the binary logs at commit time. The following values are available:
-
-  * 0 (default): 
-    |InnoDB| keeps transactions in the same order between the transaction logs and the binary logs. This is the safer value but also the slower.
-
-  * 1: 
-    transactions can be group-committed but the order between transactions will not be guaranteed to be kept anymore. Thus there is a slight risk of desynchronization between transaction logs and binary logs. However for servers that perform write-intensive workloads (and have RAID without BBU), you may expect a significant improvement in performance. (See Implementation Details if you need to understand the goal of this feature.)
-
 .. variable:: innodb_flush_method
 
    :cli: Yes
@@ -284,3 +264,8 @@
   Checkpoint age      4243362
   0 pending log writes, 0 pending chkp writes
   ...
+
+Other Reading
+=============
+
+ * For Fusion-IO devices-specific tuning, see :ref:`atomic_fio` documentation.