Merge lp:~tsarev/percona-server/5.1_percona_server_variables_fix_bug_785566 into lp:percona-server/5.1

[Oleg Tsarev]

percona_server_variables splited to
     * percona_server_variables_release
     * percona_server_variables_debug
Now I use SELECT Variables_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES (SHOW VARIABLES is alias for SHOW SESSION VARIABLES).
I also add have_nodebug check (backported from 5.5).

[Alexey Kopytov (akopytov)]

review: Approve

=== added file 'mysql-test/have_nodebug.inc'
--- mysql-test/have_nodebug.inc	1970-01-01 00:00:00 +0000
+++ mysql-test/have_nodebug.inc	2011-06-23 02:23:22 +0000
@@ -0,0 +1,4 @@
+-- require r/have_nodebug.require
+disable_query_log;
+select (version() like '%debug%') as debug;
+enable_query_log;
 
=== added file 'mysql-test/have_nodebug.require'
--- mysql-test/have_nodebug.require	1970-01-01 00:00:00 +0000
+++ mysql-test/have_nodebug.require	2011-06-23 02:23:22 +0000
@@ -0,0 +1,2 @@
+debug
+0
 
=== added file 'mysql-test/percona_server_variables.inc'
--- mysql-test/percona_server_variables.inc	1970-01-01 00:00:00 +0000
+++ mysql-test/percona_server_variables.inc	2011-06-23 02:23:22 +0000
@@ -0,0 +1,3 @@
+--source include/have_response_time_distribution.inc
+--source include/have_innodb.inc
+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
 
=== renamed file 'mysql-test/percona_server_variables.result' => 'mysql-test/percona_server_variables_debug.result'
--- mysql-test/percona_server_variables.result	2010-12-14 20:03:02 +0000
+++ mysql-test/percona_server_variables_debug.result	2011-06-23 02:23:22 +0000
@@ -1,343 +1,346 @@
-show variables;
-Variable_name	Value
-auto_increment_increment	Value
-auto_increment_offset	Value
-autocommit	Value
-automatic_sp_privileges	Value
-back_log	Value
-basedir	Value
-big_tables	Value
-binlog_cache_size	Value
-binlog_direct_non_transactional_updates	Value
-binlog_format	Value
-bulk_insert_buffer_size	Value
-character_set_client	Value
-character_set_connection	Value
-character_set_database	Value
-character_set_filesystem	Value
-character_set_results	Value
-character_set_server	Value
-character_set_system	Value
-character_sets_dir	Value
-collation_connection	Value
-collation_database	Value
-collation_server	Value
-completion_type	Value
-concurrent_insert	Value
-connect_timeout	Value
-datadir	Value
-date_format	Value
-datetime_format	Value
-debug	Value
-debug_sync	Value
-default_week_format	Value
-delay_key_write	Value
-delayed_insert_limit	Value
-delayed_insert_timeout	Value
-delayed_queue_size	Value
-div_precision_increment	Value
-enable_query_response_time_stats	Value
-engine_condition_pushdown	Value
-error_count	Value
-event_scheduler	Value
-expire_logs_days	Value
-fast_index_creation	Value
-flush	Value
-flush_time	Value
-foreign_key_checks	Value
-ft_boolean_syntax	Value
-ft_max_word_len	Value
-ft_min_word_len	Value
-ft_query_expansion_limit	Value
-ft_stopword_file	Value
-general_log	Value
-general_log_file	Value
-group_concat_max_len	Value
-have_community_features	Value
-have_compress	Value
-have_crypt	Value
-have_csv	Value
-have_dynamic_loading	Value
-have_geometry	Value
-have_innodb	Value
-have_ndbcluster	Value
-have_openssl	Value
-have_partitioning	Value
-have_query_cache	Value
-have_response_time_distribution	Value
-have_rtree_keys	Value
-have_ssl	Value
-have_symlink	Value
-hostname	Value
-identity	Value
-ignore_builtin_innodb	Value
-init_connect	Value
-init_file	Value
-init_slave	Value
-innodb_adaptive_checkpoint	Value
-innodb_adaptive_flushing	Value
-innodb_adaptive_hash_index	Value
-innodb_additional_mem_pool_size	Value
-innodb_auto_lru_dump	Value
-innodb_autoextend_increment	Value
-innodb_autoinc_lock_mode	Value
-innodb_buffer_pool_shm_checksum	Value
-innodb_buffer_pool_shm_key	Value
-innodb_buffer_pool_size	Value
-innodb_change_buffering	Value
-innodb_checkpoint_age_target	Value
-innodb_checksums	Value
-innodb_commit_concurrency	Value
-innodb_concurrency_tickets	Value
-innodb_data_file_path	Value
-innodb_data_home_dir	Value
-innodb_dict_size_limit	Value
-innodb_doublewrite	Value
-innodb_doublewrite_file	Value
-innodb_enable_unsafe_group_commit	Value
-innodb_expand_import	Value
-innodb_extra_rsegments	Value
-innodb_extra_undoslots	Value
-innodb_fast_checksum	Value
-innodb_fast_recovery	Value
-innodb_fast_shutdown	Value
-innodb_file_format	Value
-innodb_file_format_check	Value
-innodb_file_per_table	Value
-innodb_flush_log_at_trx_commit	Value
-innodb_flush_log_at_trx_commit_session	Value
-innodb_flush_method	Value
-innodb_flush_neighbor_pages	Value
-innodb_force_recovery	Value
-innodb_ibuf_accel_rate	Value
-innodb_ibuf_active_contract	Value
-innodb_ibuf_max_size	Value
-innodb_io_capacity	Value
-innodb_lock_wait_timeout	Value
-innodb_locks_unsafe_for_binlog	Value
-innodb_log_buffer_size	Value
-innodb_log_file_size	Value
-innodb_log_files_in_group	Value
-innodb_log_group_home_dir	Value
-innodb_max_dirty_pages_pct	Value
-innodb_max_purge_lag	Value
-innodb_mirrored_log_groups	Value
-innodb_old_blocks_pct	Value
-innodb_old_blocks_time	Value
-innodb_open_files	Value
-innodb_overwrite_relay_log_info	Value
-innodb_page_size	Value
-innodb_pass_corrupt_table	Value
-innodb_read_ahead	Value
-innodb_read_ahead_threshold	Value
-innodb_read_io_threads	Value
-innodb_recovery_stats	Value
-innodb_replication_delay	Value
-innodb_rollback_on_timeout	Value
-innodb_show_locks_held	Value
-innodb_show_verbose_locks	Value
-innodb_spin_wait_delay	Value
-innodb_stats_auto_update	Value
-innodb_stats_method	Value
-innodb_stats_on_metadata	Value
-innodb_stats_sample_pages	Value
-innodb_stats_update_need_lock	Value
-innodb_strict_mode	Value
-innodb_support_xa	Value
-innodb_sync_spin_loops	Value
-innodb_table_locks	Value
-innodb_thread_concurrency	Value
-innodb_thread_concurrency_timer_based	Value
-innodb_thread_sleep_delay	Value
-innodb_use_purge_thread	Value
-innodb_use_sys_malloc	Value
-innodb_use_sys_stats_table	Value
-innodb_version	Value
-innodb_write_io_threads	Value
-insert_id	Value
-interactive_timeout	Value
-join_buffer_size	Value
-keep_files_on_create	Value
-key_buffer_size	Value
-key_cache_age_threshold	Value
-key_cache_block_size	Value
-key_cache_division_limit	Value
-language	Value
-large_files_support	Value
-large_page_size	Value
-large_pages	Value
-last_insert_id	Value
-lc_time_names	Value
-license	Value
-local_infile	Value
-locked_in_memory	Value
-log	Value
-log_bin	Value
-log_bin_trust_function_creators	Value
-log_bin_trust_routine_creators	Value
-log_error	Value
-log_output	Value
-log_queries_not_using_indexes	Value
-log_slave_updates	Value
-log_slow_filter	Value
-log_slow_queries	Value
-log_slow_rate_limit	Value
-log_slow_slave_statements	Value
-log_slow_sp_statements	Value
-log_slow_timestamp_every	Value
-log_slow_verbosity	Value
-log_warnings	Value
-long_query_time	Value
-low_priority_updates	Value
-lower_case_file_system	Value
-lower_case_table_names	Value
-max_allowed_packet	Value
-max_binlog_cache_size	Value
-max_binlog_size	Value
-max_connect_errors	Value
-max_connections	Value
-max_delayed_threads	Value
-max_error_count	Value
-max_heap_table_size	Value
-max_insert_delayed_threads	Value
-max_join_size	Value
-max_length_for_sort_data	Value
-max_prepared_stmt_count	Value
-max_relay_log_size	Value
-max_seeks_for_key	Value
-max_sort_length	Value
-max_sp_recursion_depth	Value
-max_tmp_tables	Value
-max_user_connections	Value
-max_write_lock_count	Value
-min_examined_row_limit	Value
-multi_range_count	Value
-myisam_data_pointer_size	Value
-myisam_max_sort_file_size	Value
-myisam_mmap_size	Value
-myisam_recover_options	Value
-myisam_repair_threads	Value
-myisam_sort_buffer_size	Value
-myisam_stats_method	Value
-myisam_use_mmap	Value
-net_buffer_length	Value
-net_read_timeout	Value
-net_retry_count	Value
-net_write_timeout	Value
-new	Value
-old	Value
-old_alter_table	Value
-old_passwords	Value
-open_files_limit	Value
-optimizer_fix	Value
-optimizer_prune_level	Value
-optimizer_search_depth	Value
-optimizer_switch	Value
-pid_file	Value
-plugin_dir	Value
-port	Value
-preload_buffer_size	Value
-profiling	Value
-profiling_history_size	Value
-profiling_server	Value
-profiling_use_getrusage	Value
-protocol_version	Value
-pseudo_thread_id	Value
-query_alloc_block_size	Value
-query_cache_limit	Value
-query_cache_min_res_unit	Value
-query_cache_size	Value
-query_cache_strip_comments	Value
-query_cache_type	Value
-query_cache_wlock_invalidate	Value
-query_prealloc_size	Value
-query_response_time_range_base	Value
-rand_seed1	Value
-rand_seed2	Value
-range_alloc_block_size	Value
-read_buffer_size	Value
-read_only	Value
-read_rnd_buffer_size	Value
-relay_log	Value
-relay_log_index	Value
-relay_log_info_file	Value
-relay_log_purge	Value
-relay_log_space_limit	Value
-report_host	Value
-report_password	Value
-report_port	Value
-report_user	Value
-rpl_recovery_rank	Value
-secure_auth	Value
-secure_file_priv	Value
-server_id	Value
-skip_external_locking	Value
-skip_name_resolve	Value
-skip_networking	Value
-skip_show_database	Value
-slave_compressed_protocol	Value
-slave_exec_mode	Value
-slave_load_tmpdir	Value
-slave_net_timeout	Value
-slave_skip_errors	Value
-slave_transaction_retries	Value
-slow_launch_time	Value
-slow_query_log	Value
-slow_query_log_file	Value
-slow_query_log_microseconds_timestamp	Value
-socket	Value
-sort_buffer_size	Value
-sql_auto_is_null	Value
-sql_big_selects	Value
-sql_big_tables	Value
-sql_buffer_result	Value
-sql_log_bin	Value
-sql_log_off	Value
-sql_log_update	Value
-sql_low_priority_updates	Value
-sql_max_join_size	Value
-sql_mode	Value
-sql_notes	Value
-sql_quote_show_create	Value
-sql_safe_updates	Value
-sql_select_limit	Value
-sql_slave_skip_counter	Value
-sql_warnings	Value
-ssl_ca	Value
-ssl_capath	Value
-ssl_cert	Value
-ssl_cipher	Value
-ssl_key	Value
-storage_engine	Value
-suppress_log_warning_1592	Value
-sync_binlog	Value
-sync_frm	Value
-system_time_zone	Value
-table_definition_cache	Value
-table_lock_wait_timeout	Value
-table_open_cache	Value
-table_type	Value
-thread_cache_size	Value
-thread_handling	Value
-thread_stack	Value
-thread_statistics	Value
-time_format	Value
-time_zone	Value
-timed_mutexes	Value
-timestamp	Value
-tmp_table_size	Value
-tmpdir	Value
-transaction_alloc_block_size	Value
-transaction_prealloc_size	Value
-tx_isolation	Value
-unique_checks	Value
-updatable_views_with_limit	Value
-use_global_log_slow_control	Value
-use_global_long_query_time	Value
-userstat_running	Value
-version	Value
-version_comment	Value
-version_compile_machine	Value
-version_compile_os	Value
-wait_timeout	Value
-warning_count	Value
+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
+Variable_name
+AUTOCOMMIT
+AUTOMATIC_SP_PRIVILEGES
+AUTO_INCREMENT_INCREMENT
+AUTO_INCREMENT_OFFSET
+BACK_LOG
+BASEDIR
+BIG_TABLES
+BINLOG_CACHE_SIZE
+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
+BINLOG_FORMAT
+BULK_INSERT_BUFFER_SIZE
+CHARACTER_SETS_DIR
+CHARACTER_SET_CLIENT
+CHARACTER_SET_CONNECTION
+CHARACTER_SET_DATABASE
+CHARACTER_SET_FILESYSTEM
+CHARACTER_SET_RESULTS
+CHARACTER_SET_SERVER
+CHARACTER_SET_SYSTEM
+COLLATION_CONNECTION
+COLLATION_DATABASE
+COLLATION_SERVER
+COMPLETION_TYPE
+CONCURRENT_INSERT
+CONNECT_TIMEOUT
+DATADIR
+DATETIME_FORMAT
+DATE_FORMAT
+DEBUG
+DEBUG_SYNC
+DEFAULT_WEEK_FORMAT
+DELAYED_INSERT_LIMIT
+DELAYED_INSERT_TIMEOUT
+DELAYED_QUEUE_SIZE
+DELAY_KEY_WRITE
+DIV_PRECISION_INCREMENT
+ENABLE_QUERY_RESPONSE_TIME_STATS
+ENGINE_CONDITION_PUSHDOWN
+ERROR_COUNT
+EVENT_SCHEDULER
+EXPIRE_LOGS_DAYS
+FAST_INDEX_CREATION
+FLUSH
+FLUSH_TIME
+FOREIGN_KEY_CHECKS
+FT_BOOLEAN_SYNTAX
+FT_MAX_WORD_LEN
+FT_MIN_WORD_LEN
+FT_QUERY_EXPANSION_LIMIT
+FT_STOPWORD_FILE
+GENERAL_LOG
+GENERAL_LOG_FILE
+GROUP_CONCAT_MAX_LEN
+HAVE_COMMUNITY_FEATURES
+HAVE_COMPRESS
+HAVE_CRYPT
+HAVE_CSV
+HAVE_DYNAMIC_LOADING
+HAVE_GEOMETRY
+HAVE_INNODB
+HAVE_NDBCLUSTER
+HAVE_OPENSSL
+HAVE_PARTITIONING
+HAVE_QUERY_CACHE
+HAVE_RESPONSE_TIME_DISTRIBUTION
+HAVE_RTREE_KEYS
+HAVE_SSL
+HAVE_SYMLINK
+HOSTNAME
+IDENTITY
+IGNORE_BUILTIN_INNODB
+INIT_CONNECT
+INIT_FILE
+INIT_SLAVE
+INNODB_ADAPTIVE_CHECKPOINT
+INNODB_ADAPTIVE_FLUSHING
+INNODB_ADAPTIVE_HASH_INDEX
+INNODB_ADDITIONAL_MEM_POOL_SIZE
+INNODB_AUTOEXTEND_INCREMENT
+INNODB_AUTOINC_LOCK_MODE
+INNODB_AUTO_LRU_DUMP
+INNODB_BUFFER_POOL_SHM_CHECKSUM
+INNODB_BUFFER_POOL_SHM_KEY
+INNODB_BUFFER_POOL_SIZE
+INNODB_CHANGE_BUFFERING
+INNODB_CHECKPOINT_AGE_TARGET
+INNODB_CHECKSUMS
+INNODB_COMMIT_CONCURRENCY
+INNODB_CONCURRENCY_TICKETS
+INNODB_DATA_FILE_PATH
+INNODB_DATA_HOME_DIR
+INNODB_DICT_SIZE_LIMIT
+INNODB_DOUBLEWRITE
+INNODB_DOUBLEWRITE_FILE
+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
+INNODB_EXPAND_IMPORT
+INNODB_EXTRA_RSEGMENTS
+INNODB_EXTRA_UNDOSLOTS
+INNODB_FAST_CHECKSUM
+INNODB_FAST_RECOVERY
+INNODB_FAST_SHUTDOWN
+INNODB_FILE_FORMAT
+INNODB_FILE_FORMAT_CHECK
+INNODB_FILE_PER_TABLE
+INNODB_FLUSH_LOG_AT_TRX_COMMIT
+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
+INNODB_FLUSH_METHOD
+INNODB_FLUSH_NEIGHBOR_PAGES
+INNODB_FORCE_RECOVERY
+INNODB_IBUF_ACCEL_RATE
+INNODB_IBUF_ACTIVE_CONTRACT
+INNODB_IBUF_MAX_SIZE
+INNODB_IO_CAPACITY
+INNODB_LAZY_DROP_TABLE
+INNODB_LOCKS_UNSAFE_FOR_BINLOG
+INNODB_LOCK_WAIT_TIMEOUT
+INNODB_LOG_BLOCK_SIZE
+INNODB_LOG_BUFFER_SIZE
+INNODB_LOG_FILES_IN_GROUP
+INNODB_LOG_FILE_SIZE
+INNODB_LOG_GROUP_HOME_DIR
+INNODB_MAX_DIRTY_PAGES_PCT
+INNODB_MAX_PURGE_LAG
+INNODB_MIRRORED_LOG_GROUPS
+INNODB_OLD_BLOCKS_PCT
+INNODB_OLD_BLOCKS_TIME
+INNODB_OPEN_FILES
+INNODB_OVERWRITE_RELAY_LOG_INFO
+INNODB_PAGE_SIZE
+INNODB_PASS_CORRUPT_TABLE
+INNODB_READ_AHEAD
+INNODB_READ_AHEAD_THRESHOLD
+INNODB_READ_IO_THREADS
+INNODB_RECOVERY_STATS
+INNODB_REPLICATION_DELAY
+INNODB_ROLLBACK_ON_TIMEOUT
+INNODB_SHOW_LOCKS_HELD
+INNODB_SHOW_VERBOSE_LOCKS
+INNODB_SPIN_WAIT_DELAY
+INNODB_STATS_AUTO_UPDATE
+INNODB_STATS_METHOD
+INNODB_STATS_ON_METADATA
+INNODB_STATS_SAMPLE_PAGES
+INNODB_STATS_UPDATE_NEED_LOCK
+INNODB_STRICT_MODE
+INNODB_SUPPORT_XA
+INNODB_SYNC_SPIN_LOOPS
+INNODB_TABLE_LOCKS
+INNODB_THREAD_CONCURRENCY
+INNODB_THREAD_CONCURRENCY_TIMER_BASED
+INNODB_THREAD_SLEEP_DELAY
+INNODB_USE_PURGE_THREAD
+INNODB_USE_SYS_MALLOC
+INNODB_USE_SYS_STATS_TABLE
+INNODB_VERSION
+INNODB_WRITE_IO_THREADS
+INSERT_ID
+INTERACTIVE_TIMEOUT
+JOIN_BUFFER_SIZE
+KEEP_FILES_ON_CREATE
+KEY_BUFFER_SIZE
+KEY_CACHE_AGE_THRESHOLD
+KEY_CACHE_BLOCK_SIZE
+KEY_CACHE_DIVISION_LIMIT
+LANGUAGE
+LARGE_FILES_SUPPORT
+LARGE_PAGES
+LARGE_PAGE_SIZE
+LAST_INSERT_ID
+LC_TIME_NAMES
+LICENSE
+LOCAL_INFILE
+LOCKED_IN_MEMORY
+LOG
+LOG_BIN
+LOG_BIN_TRUST_FUNCTION_CREATORS
+LOG_BIN_TRUST_ROUTINE_CREATORS
+LOG_ERROR
+LOG_OUTPUT
+LOG_QUERIES_NOT_USING_INDEXES
+LOG_SLAVE_UPDATES
+LOG_SLOW_FILTER
+LOG_SLOW_QUERIES
+LOG_SLOW_RATE_LIMIT
+LOG_SLOW_SLAVE_STATEMENTS
+LOG_SLOW_SP_STATEMENTS
+LOG_SLOW_TIMESTAMP_EVERY
+LOG_SLOW_VERBOSITY
+LOG_WARNINGS
+LONG_QUERY_TIME
+LOWER_CASE_FILE_SYSTEM
+LOWER_CASE_TABLE_NAMES
+LOW_PRIORITY_UPDATES
+MAX_ALLOWED_PACKET
+MAX_BINLOG_CACHE_SIZE
+MAX_BINLOG_SIZE
+MAX_CONNECTIONS
+MAX_CONNECT_ERRORS
+MAX_DELAYED_THREADS
+MAX_ERROR_COUNT
+MAX_HEAP_TABLE_SIZE
+MAX_INSERT_DELAYED_THREADS
+MAX_JOIN_SIZE
+MAX_LENGTH_FOR_SORT_DATA
+MAX_LONG_DATA_SIZE
+MAX_PREPARED_STMT_COUNT
+MAX_RELAY_LOG_SIZE
+MAX_SEEKS_FOR_KEY
+MAX_SORT_LENGTH
+MAX_SP_RECURSION_DEPTH
+MAX_TMP_TABLES
+MAX_USER_CONNECTIONS
+MAX_WRITE_LOCK_COUNT
+MIN_EXAMINED_ROW_LIMIT
+MULTI_RANGE_COUNT
+MYISAM_DATA_POINTER_SIZE
+MYISAM_MAX_SORT_FILE_SIZE
+MYISAM_MMAP_SIZE
+MYISAM_RECOVER_OPTIONS
+MYISAM_REPAIR_THREADS
+MYISAM_SORT_BUFFER_SIZE
+MYISAM_STATS_METHOD
+MYISAM_USE_MMAP
+NET_BUFFER_LENGTH
+NET_READ_TIMEOUT
+NET_RETRY_COUNT
+NET_WRITE_TIMEOUT
+NEW
+OLD
+OLD_ALTER_TABLE
+OLD_PASSWORDS
+OPEN_FILES_LIMIT
+OPTIMIZER_FIX
+OPTIMIZER_PRUNE_LEVEL
+OPTIMIZER_SEARCH_DEPTH
+OPTIMIZER_SWITCH
+PID_FILE
+PLUGIN_DIR
+PORT
+PRELOAD_BUFFER_SIZE
+PROFILING
+PROFILING_HISTORY_SIZE
+PROFILING_SERVER
+PROFILING_USE_GETRUSAGE
+PROTOCOL_VERSION
+PSEUDO_THREAD_ID
+QUERY_ALLOC_BLOCK_SIZE
+QUERY_CACHE_LIMIT
+QUERY_CACHE_MIN_RES_UNIT
+QUERY_CACHE_SIZE
+QUERY_CACHE_STRIP_COMMENTS
+QUERY_CACHE_TYPE
+QUERY_CACHE_WLOCK_INVALIDATE
+QUERY_PREALLOC_SIZE
+QUERY_RESPONSE_TIME_RANGE_BASE
+RAND_SEED1
+RAND_SEED2
+RANGE_ALLOC_BLOCK_SIZE
+READ_BUFFER_SIZE
+READ_ONLY
+READ_RND_BUFFER_SIZE
+RELAY_LOG
+RELAY_LOG_INDEX
+RELAY_LOG_INFO_FILE
+RELAY_LOG_PURGE
+RELAY_LOG_SPACE_LIMIT
+REPORT_HOST
+REPORT_PASSWORD
+REPORT_PORT
+REPORT_USER
+RPL_RECOVERY_RANK
+SECURE_AUTH
+SECURE_FILE_PRIV
+SERVER_ID
+SKIP_EXTERNAL_LOCKING
+SKIP_NAME_RESOLVE
+SKIP_NETWORKING
+SKIP_SHOW_DATABASE
+SLAVE_COMPRESSED_PROTOCOL
+SLAVE_EXEC_MODE
+SLAVE_LOAD_TMPDIR
+SLAVE_NET_TIMEOUT
+SLAVE_SKIP_ERRORS
+SLAVE_TRANSACTION_RETRIES
+SLOW_LAUNCH_TIME
+SLOW_QUERY_LOG
+SLOW_QUERY_LOG_FILE
+SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
+SOCKET
+SORT_BUFFER_SIZE
+SQL_AUTO_IS_NULL
+SQL_BIG_SELECTS
+SQL_BIG_TABLES
+SQL_BUFFER_RESULT
+SQL_LOG_BIN
+SQL_LOG_OFF
+SQL_LOG_UPDATE
+SQL_LOW_PRIORITY_UPDATES
+SQL_MAX_JOIN_SIZE
+SQL_MODE
+SQL_NOTES
+SQL_QUOTE_SHOW_CREATE
+SQL_SAFE_UPDATES
+SQL_SELECT_LIMIT
+SQL_SLAVE_SKIP_COUNTER
+SQL_WARNINGS
+SSL_CA
+SSL_CAPATH
+SSL_CERT
+SSL_CIPHER
+SSL_KEY
+STORAGE_ENGINE
+SUPPRESS_LOG_WARNING_1592
+SYNC_BINLOG
+SYNC_FRM
+SYSTEM_TIME_ZONE
+TABLE_DEFINITION_CACHE
+TABLE_LOCK_WAIT_TIMEOUT
+TABLE_OPEN_CACHE
+TABLE_TYPE
+THREAD_CACHE_SIZE
+THREAD_HANDLING
+THREAD_STACK
+THREAD_STATISTICS
+TIMED_MUTEXES
+TIMESTAMP
+TIME_FORMAT
+TIME_ZONE
+TMPDIR
+TMP_TABLE_SIZE
+TRANSACTION_ALLOC_BLOCK_SIZE
+TRANSACTION_PREALLOC_SIZE
+TX_ISOLATION
+UNIQUE_CHECKS
+UPDATABLE_VIEWS_WITH_LIMIT
+USERSTAT_RUNNING
+USE_GLOBAL_LOG_SLOW_CONTROL
+USE_GLOBAL_LONG_QUERY_TIME
+VERSION
+VERSION_COMMENT
+VERSION_COMPILE_MACHINE
+VERSION_COMPILE_OS
+WAIT_TIMEOUT
+WARNING_COUNT
 
=== renamed file 'mysql-test/percona_server_variables.test' => 'mysql-test/percona_server_variables_debug.test'
--- mysql-test/percona_server_variables.test	2010-12-14 20:03:02 +0000
+++ mysql-test/percona_server_variables_debug.test	2011-06-23 02:23:22 +0000
@@ -1,8 +1,2 @@
---source include/have_response_time_distribution.inc
---source include/have_innodb.inc
 --source include/have_debug.inc
-
-#check the list of variable names
---replace_column 2 Value
-show variables;
-
+--source include/percona_server_variables.inc
 
=== added file 'mysql-test/percona_server_variables_release.result'
--- mysql-test/percona_server_variables_release.result	1970-01-01 00:00:00 +0000
+++ mysql-test/percona_server_variables_release.result	2011-06-23 02:23:22 +0000
@@ -0,0 +1,344 @@
+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
+Variable_name
+AUTOCOMMIT
+AUTOMATIC_SP_PRIVILEGES
+AUTO_INCREMENT_INCREMENT
+AUTO_INCREMENT_OFFSET
+BACK_LOG
+BASEDIR
+BIG_TABLES
+BINLOG_CACHE_SIZE
+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
+BINLOG_FORMAT
+BULK_INSERT_BUFFER_SIZE
+CHARACTER_SETS_DIR
+CHARACTER_SET_CLIENT
+CHARACTER_SET_CONNECTION
+CHARACTER_SET_DATABASE
+CHARACTER_SET_FILESYSTEM
+CHARACTER_SET_RESULTS
+CHARACTER_SET_SERVER
+CHARACTER_SET_SYSTEM
+COLLATION_CONNECTION
+COLLATION_DATABASE
+COLLATION_SERVER
+COMPLETION_TYPE
+CONCURRENT_INSERT
+CONNECT_TIMEOUT
+DATADIR
+DATETIME_FORMAT
+DATE_FORMAT
+DEFAULT_WEEK_FORMAT
+DELAYED_INSERT_LIMIT
+DELAYED_INSERT_TIMEOUT
+DELAYED_QUEUE_SIZE
+DELAY_KEY_WRITE
+DIV_PRECISION_INCREMENT
+ENABLE_QUERY_RESPONSE_TIME_STATS
+ENGINE_CONDITION_PUSHDOWN
+ERROR_COUNT
+EVENT_SCHEDULER
+EXPIRE_LOGS_DAYS
+FAST_INDEX_CREATION
+FLUSH
+FLUSH_TIME
+FOREIGN_KEY_CHECKS
+FT_BOOLEAN_SYNTAX
+FT_MAX_WORD_LEN
+FT_MIN_WORD_LEN
+FT_QUERY_EXPANSION_LIMIT
+FT_STOPWORD_FILE
+GENERAL_LOG
+GENERAL_LOG_FILE
+GROUP_CONCAT_MAX_LEN
+HAVE_COMMUNITY_FEATURES
+HAVE_COMPRESS
+HAVE_CRYPT
+HAVE_CSV
+HAVE_DYNAMIC_LOADING
+HAVE_GEOMETRY
+HAVE_INNODB
+HAVE_NDBCLUSTER
+HAVE_OPENSSL
+HAVE_PARTITIONING
+HAVE_QUERY_CACHE
+HAVE_RESPONSE_TIME_DISTRIBUTION
+HAVE_RTREE_KEYS
+HAVE_SSL
+HAVE_SYMLINK
+HOSTNAME
+IDENTITY
+IGNORE_BUILTIN_INNODB
+INIT_CONNECT
+INIT_FILE
+INIT_SLAVE
+INNODB_ADAPTIVE_CHECKPOINT
+INNODB_ADAPTIVE_FLUSHING
+INNODB_ADAPTIVE_HASH_INDEX
+INNODB_ADDITIONAL_MEM_POOL_SIZE
+INNODB_AUTOEXTEND_INCREMENT
+INNODB_AUTOINC_LOCK_MODE
+INNODB_AUTO_LRU_DUMP
+INNODB_BUFFER_POOL_SHM_CHECKSUM
+INNODB_BUFFER_POOL_SHM_KEY
+INNODB_BUFFER_POOL_SIZE
+INNODB_CHANGE_BUFFERING
+INNODB_CHECKPOINT_AGE_TARGET
+INNODB_CHECKSUMS
+INNODB_COMMIT_CONCURRENCY
+INNODB_CONCURRENCY_TICKETS
+INNODB_DATA_FILE_PATH
+INNODB_DATA_HOME_DIR
+INNODB_DICT_SIZE_LIMIT
+INNODB_DOUBLEWRITE
+INNODB_DOUBLEWRITE_FILE
+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
+INNODB_EXPAND_IMPORT
+INNODB_EXTRA_RSEGMENTS
+INNODB_EXTRA_UNDOSLOTS
+INNODB_FAST_CHECKSUM
+INNODB_FAST_RECOVERY
+INNODB_FAST_SHUTDOWN
+INNODB_FILE_FORMAT
+INNODB_FILE_FORMAT_CHECK
+INNODB_FILE_PER_TABLE
+INNODB_FLUSH_LOG_AT_TRX_COMMIT
+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
+INNODB_FLUSH_METHOD
+INNODB_FLUSH_NEIGHBOR_PAGES
+INNODB_FORCE_RECOVERY
+INNODB_IBUF_ACCEL_RATE
+INNODB_IBUF_ACTIVE_CONTRACT
+INNODB_IBUF_MAX_SIZE
+INNODB_IO_CAPACITY
+INNODB_LAZY_DROP_TABLE
+INNODB_LOCKS_UNSAFE_FOR_BINLOG
+INNODB_LOCK_WAIT_TIMEOUT
+INNODB_LOG_BLOCK_SIZE
+INNODB_LOG_BUFFER_SIZE
+INNODB_LOG_FILES_IN_GROUP
+INNODB_LOG_FILE_SIZE
+INNODB_LOG_GROUP_HOME_DIR
+INNODB_MAX_DIRTY_PAGES_PCT
+INNODB_MAX_PURGE_LAG
+INNODB_MIRRORED_LOG_GROUPS
+INNODB_OLD_BLOCKS_PCT
+INNODB_OLD_BLOCKS_TIME
+INNODB_OPEN_FILES
+INNODB_OVERWRITE_RELAY_LOG_INFO
+INNODB_PAGE_SIZE
+INNODB_PASS_CORRUPT_TABLE
+INNODB_READ_AHEAD
+INNODB_READ_AHEAD_THRESHOLD
+INNODB_READ_IO_THREADS
+INNODB_RECOVERY_STATS
+INNODB_REPLICATION_DELAY
+INNODB_ROLLBACK_ON_TIMEOUT
+INNODB_SHOW_LOCKS_HELD
+INNODB_SHOW_VERBOSE_LOCKS
+INNODB_SPIN_WAIT_DELAY
+INNODB_STATS_AUTO_UPDATE
+INNODB_STATS_METHOD
+INNODB_STATS_ON_METADATA
+INNODB_STATS_SAMPLE_PAGES
+INNODB_STATS_UPDATE_NEED_LOCK
+INNODB_STRICT_MODE
+INNODB_SUPPORT_XA
+INNODB_SYNC_SPIN_LOOPS
+INNODB_TABLE_LOCKS
+INNODB_THREAD_CONCURRENCY
+INNODB_THREAD_CONCURRENCY_TIMER_BASED
+INNODB_THREAD_SLEEP_DELAY
+INNODB_USE_PURGE_THREAD
+INNODB_USE_SYS_MALLOC
+INNODB_USE_SYS_STATS_TABLE
+INNODB_VERSION
+INNODB_WRITE_IO_THREADS
+INSERT_ID
+INTERACTIVE_TIMEOUT
+JOIN_BUFFER_SIZE
+KEEP_FILES_ON_CREATE
+KEY_BUFFER_SIZE
+KEY_CACHE_AGE_THRESHOLD
+KEY_CACHE_BLOCK_SIZE
+KEY_CACHE_DIVISION_LIMIT
+LANGUAGE
+LARGE_FILES_SUPPORT
+LARGE_PAGES
+LARGE_PAGE_SIZE
+LAST_INSERT_ID
+LC_TIME_NAMES
+LICENSE
+LOCAL_INFILE
+LOCKED_IN_MEMORY
+LOG
+LOG_BIN
+LOG_BIN_TRUST_FUNCTION_CREATORS
+LOG_BIN_TRUST_ROUTINE_CREATORS
+LOG_ERROR
+LOG_OUTPUT
+LOG_QUERIES_NOT_USING_INDEXES
+LOG_SLAVE_UPDATES
+LOG_SLOW_FILTER
+LOG_SLOW_QUERIES
+LOG_SLOW_RATE_LIMIT
+LOG_SLOW_SLAVE_STATEMENTS
+LOG_SLOW_SP_STATEMENTS
+LOG_SLOW_TIMESTAMP_EVERY
+LOG_SLOW_VERBOSITY
+LOG_WARNINGS
+LONG_QUERY_TIME
+LOWER_CASE_FILE_SYSTEM
+LOWER_CASE_TABLE_NAMES
+LOW_PRIORITY_UPDATES
+MAX_ALLOWED_PACKET
+MAX_BINLOG_CACHE_SIZE
+MAX_BINLOG_SIZE
+MAX_CONNECTIONS
+MAX_CONNECT_ERRORS
+MAX_DELAYED_THREADS
+MAX_ERROR_COUNT
+MAX_HEAP_TABLE_SIZE
+MAX_INSERT_DELAYED_THREADS
+MAX_JOIN_SIZE
+MAX_LENGTH_FOR_SORT_DATA
+MAX_LONG_DATA_SIZE
+MAX_PREPARED_STMT_COUNT
+MAX_RELAY_LOG_SIZE
+MAX_SEEKS_FOR_KEY
+MAX_SORT_LENGTH
+MAX_SP_RECURSION_DEPTH
+MAX_TMP_TABLES
+MAX_USER_CONNECTIONS
+MAX_WRITE_LOCK_COUNT
+MIN_EXAMINED_ROW_LIMIT
+MULTI_RANGE_COUNT
+MYISAM_DATA_POINTER_SIZE
+MYISAM_MAX_SORT_FILE_SIZE
+MYISAM_MMAP_SIZE
+MYISAM_RECOVER_OPTIONS
+MYISAM_REPAIR_THREADS
+MYISAM_SORT_BUFFER_SIZE
+MYISAM_STATS_METHOD
+MYISAM_USE_MMAP
+NET_BUFFER_LENGTH
+NET_READ_TIMEOUT
+NET_RETRY_COUNT
+NET_WRITE_TIMEOUT
+NEW
+OLD
+OLD_ALTER_TABLE
+OLD_PASSWORDS
+OPEN_FILES_LIMIT
+OPTIMIZER_FIX
+OPTIMIZER_PRUNE_LEVEL
+OPTIMIZER_SEARCH_DEPTH
+OPTIMIZER_SWITCH
+PID_FILE
+PLUGIN_DIR
+PORT
+PRELOAD_BUFFER_SIZE
+PROFILING
+PROFILING_HISTORY_SIZE
+PROFILING_SERVER
+PROFILING_USE_GETRUSAGE
+PROTOCOL_VERSION
+PSEUDO_THREAD_ID
+QUERY_ALLOC_BLOCK_SIZE
+QUERY_CACHE_LIMIT
+QUERY_CACHE_MIN_RES_UNIT
+QUERY_CACHE_SIZE
+QUERY_CACHE_STRIP_COMMENTS
+QUERY_CACHE_TYPE
+QUERY_CACHE_WLOCK_INVALIDATE
+QUERY_PREALLOC_SIZE
+QUERY_RESPONSE_TIME_RANGE_BASE
+RAND_SEED1
+RAND_SEED2
+RANGE_ALLOC_BLOCK_SIZE
+READ_BUFFER_SIZE
+READ_ONLY
+READ_RND_BUFFER_SIZE
+RELAY_LOG
+RELAY_LOG_INDEX
+RELAY_LOG_INFO_FILE
+RELAY_LOG_PURGE
+RELAY_LOG_SPACE_LIMIT
+REPORT_HOST
+REPORT_PASSWORD
+REPORT_PORT
+REPORT_USER
+RPL_RECOVERY_RANK
+SECURE_AUTH
+SECURE_FILE_PRIV
+SERVER_ID
+SKIP_EXTERNAL_LOCKING
+SKIP_NAME_RESOLVE
+SKIP_NETWORKING
+SKIP_SHOW_DATABASE
+SLAVE_COMPRESSED_PROTOCOL
+SLAVE_EXEC_MODE
+SLAVE_LOAD_TMPDIR
+SLAVE_NET_TIMEOUT
+SLAVE_SKIP_ERRORS
+SLAVE_TRANSACTION_RETRIES
+SLOW_LAUNCH_TIME
+SLOW_QUERY_LOG
+SLOW_QUERY_LOG_FILE
+SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
+SOCKET
+SORT_BUFFER_SIZE
+SQL_AUTO_IS_NULL
+SQL_BIG_SELECTS
+SQL_BIG_TABLES
+SQL_BUFFER_RESULT
+SQL_LOG_BIN
+SQL_LOG_OFF
+SQL_LOG_UPDATE
+SQL_LOW_PRIORITY_UPDATES
+SQL_MAX_JOIN_SIZE
+SQL_MODE
+SQL_NOTES
+SQL_QUOTE_SHOW_CREATE
+SQL_SAFE_UPDATES
+SQL_SELECT_LIMIT
+SQL_SLAVE_SKIP_COUNTER
+SQL_WARNINGS
+SSL_CA
+SSL_CAPATH
+SSL_CERT
+SSL_CIPHER
+SSL_KEY
+STORAGE_ENGINE
+SUPPRESS_LOG_WARNING_1592
+SYNC_BINLOG
+SYNC_FRM
+SYSTEM_TIME_ZONE
+TABLE_DEFINITION_CACHE
+TABLE_LOCK_WAIT_TIMEOUT
+TABLE_OPEN_CACHE
+TABLE_TYPE
+THREAD_CACHE_SIZE
+THREAD_HANDLING
+THREAD_STACK
+THREAD_STATISTICS
+TIMED_MUTEXES
+TIMESTAMP
+TIME_FORMAT
+TIME_ZONE
+TMPDIR
+TMP_TABLE_SIZE
+TRANSACTION_ALLOC_BLOCK_SIZE
+TRANSACTION_PREALLOC_SIZE
+TX_ISOLATION
+UNIQUE_CHECKS
+UPDATABLE_VIEWS_WITH_LIMIT
+USERSTAT_RUNNING
+USE_GLOBAL_LOG_SLOW_CONTROL
+USE_GLOBAL_LONG_QUERY_TIME
+VERSION
+VERSION_COMMENT
+VERSION_COMPILE_MACHINE
+VERSION_COMPILE_OS
+WAIT_TIMEOUT
+WARNING_COUNT
 
=== added file 'mysql-test/percona_server_variables_release.test'
--- mysql-test/percona_server_variables_release.test	1970-01-01 00:00:00 +0000
+++ mysql-test/percona_server_variables_release.test	2011-06-23 02:23:22 +0000
@@ -0,0 +1,2 @@
+--source include/have_nodebug.inc
+--source include/percona_server_variables.inc