List of variables introduced in Percona Server 5.5

System Variables

Name Cmd-Line Option File Var Scope Dynamic
csv_mode Yes Yes Both Yes
enforce_storage_engine No Yes Global No
expand_fast_index_creation Yes No Both Yes
extra_max_connections Yes Yes Global Yes
extra_port Yes Yes Global No
fast_index_creation Yes No Session Yes
have_flashcache No No Global No
have_response_time_distribution No No Global No
innodb_adaptive_flushing_method Yes Yes Global Yes
innodb_adaptive_hash_index_partitions Yes Yes Global No
innodb_blocking_buffer_pool_restore Yes Yes Global No
innodb_buffer_pool_populate Yes Yes Global No
innodb_buffer_pool_restore_at_startup Yes Yes Global Yes
innodb_buffer_pool_shm_checksum Yes Yes Global No
innodb_buffer_pool_shm_key Yes Yes Global No
innodb_checkpoint_age_target Yes Yes Global Yes
innodb_corrupt_table_action Yes Yes Global Yes
innodb_dict_size_limit Yes Yes Global Yes
innodb_doublewrite_file Yes Yes Global No
innodb_fake_changes Yes Yes Both Yes
innodb_fast_checksum Yes Yes Global No
innodb_flush_neighbor_pages Yes Yes Global Yes
innodb_ibuf_accel_rate Yes Yes Global Yes
innodb_ibuf_active_contract Yes Yes Global Yes
innodb_ibuf_max_size Yes Yes Global No
innodb_import_table_from_xtrabackup Yes Yes Global Yes
innodb_kill_idle_transaction Yes Yes Global Yes
innodb_lazy_drop_table Yes Yes Global Yes
innodb_locking_fake_changes Yes Yes Both Yes
innodb_log_block_size Yes Yes Global No
innodb_max_bitmap_file_size Yes Yes Global Yes
innodb_max_changed_pages Yes Yes Global Yes
innodb_merge_sort_block_size Yes Yes Global Yes
innodb_page_size Yes Yes Global No
innodb_read_ahead Yes Yes Global Yes
innodb_recovery_stats No Yes Global No
innodb_recovery_update_relay_log Yes Yes Global No
innodb_show_locks_held Yes Yes Global Yes
innodb_show_verbose_locks Yes Yes Global Yes
innodb_stats_auto_update Yes Yes Global Yes
innodb_stats_update_need_lock Yes Yes Global Yes
innodb_thread_concurrency_timer_based Yes Yes Global No
innodb_track_changed_pages Yes Yes Global No
innodb_use_atomic_writes Yes Yes Global No
innodb_use_global_flush_log_at_trx_commit Yes Yes Global Yes
innodb_use_sys_stats_table Yes Yes Global No
log_slow_admin_statements Yes Yes Global Yes
log_slow_filter Yes Yes Both Yes
log_slow_rate_limit Yes Yes Both Yes
log_slow_rate_type Yes Yes Global Yes
log_slow_slave_statements Yes Yes Both Yes
log_slow_sp_statements Yes Yes Global Yes
log_slow_verbosity Yes Yes Both Yes
log_warnings_suppress Yes Yes Global Yes
max_binlog_files Yes Yes Global Yes
max_slowlog_files Yes Yes Global Yes
max_slowlog_size Yes Yes Global Yes
optimizer_fix N/A N/A N/A N/A
query_cache_strip_comments Yes Yes Global Yes
query_response_time_range_base Yes Yes Global Yes
query_response_time_stats Yes Yes Global Yes
slow_query_log_always_write_time Yes Yes Global Yes
slow_query_log_timestamp_always Yes Yes Global Yes
slow_query_log_timestamp_precision Yes Yes Global Yes
slow_query_log_use_global_control Yes Yes Global Yes
thread_pool_high_prio_mode Yes Yes Both Yes
thread_pool_high_prio_tickets Yes Yes Both Yes
thread_pool_idle_timeout Yes Yes Global Yes
thread_pool_max_threads Yes Yes Global Yes
thread_pool_oversubscribe Yes Yes Global Yes
thread_pool_size Yes Yes Global Yes
thread_pool_stall_limit Yes Yes Global No
thread_statistics Yes Yes Global Yes
userstat Yes Yes Global Yes

Status Variables

Name Var Type Var Scope
Com_show_client_statistics Numeric Both
Com_show_index_statistics Numeric Both
Com_show_slave_status_nolock Numeric Both
Com_show_table_statistics Numeric Both
Com_show_temporary_tables Numeric Both
Com_show_thread_statistics Numeric Both
Com_show_user_statistics Numeric Both
Flashcache_enabled Boolean Global
Innodb_adaptive_hash_cells Numeric Global
Innodb_adaptive_hash_heap_buffers Numeric Global
Innodb_adaptive_hash_hash_searches Numeric Global
Innodb_adaptive_hash_non_hash_searches Numeric Global
Innodb_background_log_sync Numeric Global
Innodb_buffer_pool_pages_LRU_flushed Numeric Global
Innodb_buffer_pool_pages_made_not_young Numeric Global
Innodb_buffer_pool_pages_made_young Numeric Global
Innodb_buffer_pool_pages_old Numeric Global
Innodb_checkpoint_age Numeric Global
Innodb_checkpoint_max_age Numeric Global
Innodb_checkpoint_target_age Numeric Global
Innodb_deadlocks Numeric Global
Innodb_dict_tables Numeric Global
Innodb_history_list_length Numeric Global
Innodb_ibuf_discarded_delete_marks Numeric Global
Innodb_ibuf_discarded_deletes Numeric Global
Innodb_ibuf_discarded_inserts Numeric Global
Innodb_ibuf_free_list Numeric Global
Innodb_ibuf_merged_delete_marks Numeric Global
Innodb_ibuf_merged_deletes Numeric Global
Innodb_ibuf_merged_inserts Numeric Global
Innodb_ibuf_merges Numeric Global
Innodb_ibuf_segment_size Numeric Global
Innodb_ibuf_size Numeric Global
Innodb_lsn_current Numeric Global
Innodb_lsn_flushed Numeric Global
Innodb_lsn_last_checkpoint Numeric Global
Innodb_master_thread_1_second_loops Numeric Global
Innodb_master_thread_10_second_loops Numeric Global
Innodb_master_thread_background_loops Numeric Global
Innodb_master_thread_main_flush_loops Numeric Global
Innodb_master_thread_sleeps Numeric Global
Innodb_max_trx_id Numeric Global
Innodb_mem_adaptive_hash Numeric Global
Innodb_mem_dictionary Numeric Global
Innodb_mem_total Numeric Global
Innodb_mutex_os_waits Numeric Global
Innodb_mutex_spin_rounds Numeric Global
Innodb_mutex_spin_waits Numeric Global
Innodb_oldest_view_low_limit_trx_id Numeric Global
Innodb_purge_trx_id Numeric Global
Innodb_purge_undo_no Numeric Global
Innodb_current_row_locks Numeric Global
Innodb_read_views_memory Numeric Global
Innodb_descriptors_memory Numeric Global
Innodb_s_lock_os_waits Numeric Global
Innodb_s_lock_spin_rounds Numeric Global
Innodb_s_lock_spin_waits Numeric Global
Innodb_x_lock_os_waits Numeric Global
Innodb_x_lock_spin_rounds Numeric Global
Innodb_x_lock_spin_waits Numeric Global
Threadpool_idle_threads Numeric Global
Threadpool_threads Numeric Global
binlog_commits Numeric Session
binlog_group_commits Numeric Session

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.