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

Proposed by Oleg Tsarev on 2011-06-23
Status: Merged
Approved by: Stewart Smith on 2011-06-23
Approved revision: 240
Merged at revision: 245
Proposed branch: lp:~tsarev/percona-server/5.1_percona_server_variables_fix_bug_785566
Merge into: lp:percona-server/5.1
Diff against target: 1087 lines (+702/-350)
7 files modified
mysql-test/have_nodebug.inc (+4/-0)
mysql-test/have_nodebug.require (+2/-0)
mysql-test/percona_server_variables.inc (+3/-0)
mysql-test/percona_server_variables_debug.result (+346/-343)
mysql-test/percona_server_variables_debug.test (+1/-7)
mysql-test/percona_server_variables_release.result (+344/-0)
mysql-test/percona_server_variables_release.test (+2/-0)
To merge this branch: bzr merge lp:~tsarev/percona-server/5.1_percona_server_variables_fix_bug_785566
Reviewer Review Type Date Requested Status
Alexey Kopytov 2011-06-23 Pending
Valentine Gostev qa 2011-06-23 Pending
Review via email: mp+65607@code.launchpad.net

This proposal supersedes a proposal from 2011-06-22.

Description of the change

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).

To post a comment you must log in.
Alexey Kopytov (akopytov) : Posted in a previous version of this proposal
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'mysql-test/have_nodebug.inc'
2--- mysql-test/have_nodebug.inc 1970-01-01 00:00:00 +0000
3+++ mysql-test/have_nodebug.inc 2011-06-23 02:23:22 +0000
4@@ -0,0 +1,4 @@
5+-- require r/have_nodebug.require
6+disable_query_log;
7+select (version() like '%debug%') as debug;
8+enable_query_log;
9
10=== added file 'mysql-test/have_nodebug.require'
11--- mysql-test/have_nodebug.require 1970-01-01 00:00:00 +0000
12+++ mysql-test/have_nodebug.require 2011-06-23 02:23:22 +0000
13@@ -0,0 +1,2 @@
14+debug
15+0
16
17=== added file 'mysql-test/percona_server_variables.inc'
18--- mysql-test/percona_server_variables.inc 1970-01-01 00:00:00 +0000
19+++ mysql-test/percona_server_variables.inc 2011-06-23 02:23:22 +0000
20@@ -0,0 +1,3 @@
21+--source include/have_response_time_distribution.inc
22+--source include/have_innodb.inc
23+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
24
25=== renamed file 'mysql-test/percona_server_variables.result' => 'mysql-test/percona_server_variables_debug.result'
26--- mysql-test/percona_server_variables.result 2010-12-14 20:03:02 +0000
27+++ mysql-test/percona_server_variables_debug.result 2011-06-23 02:23:22 +0000
28@@ -1,343 +1,346 @@
29-show variables;
30-Variable_name Value
31-auto_increment_increment Value
32-auto_increment_offset Value
33-autocommit Value
34-automatic_sp_privileges Value
35-back_log Value
36-basedir Value
37-big_tables Value
38-binlog_cache_size Value
39-binlog_direct_non_transactional_updates Value
40-binlog_format Value
41-bulk_insert_buffer_size Value
42-character_set_client Value
43-character_set_connection Value
44-character_set_database Value
45-character_set_filesystem Value
46-character_set_results Value
47-character_set_server Value
48-character_set_system Value
49-character_sets_dir Value
50-collation_connection Value
51-collation_database Value
52-collation_server Value
53-completion_type Value
54-concurrent_insert Value
55-connect_timeout Value
56-datadir Value
57-date_format Value
58-datetime_format Value
59-debug Value
60-debug_sync Value
61-default_week_format Value
62-delay_key_write Value
63-delayed_insert_limit Value
64-delayed_insert_timeout Value
65-delayed_queue_size Value
66-div_precision_increment Value
67-enable_query_response_time_stats Value
68-engine_condition_pushdown Value
69-error_count Value
70-event_scheduler Value
71-expire_logs_days Value
72-fast_index_creation Value
73-flush Value
74-flush_time Value
75-foreign_key_checks Value
76-ft_boolean_syntax Value
77-ft_max_word_len Value
78-ft_min_word_len Value
79-ft_query_expansion_limit Value
80-ft_stopword_file Value
81-general_log Value
82-general_log_file Value
83-group_concat_max_len Value
84-have_community_features Value
85-have_compress Value
86-have_crypt Value
87-have_csv Value
88-have_dynamic_loading Value
89-have_geometry Value
90-have_innodb Value
91-have_ndbcluster Value
92-have_openssl Value
93-have_partitioning Value
94-have_query_cache Value
95-have_response_time_distribution Value
96-have_rtree_keys Value
97-have_ssl Value
98-have_symlink Value
99-hostname Value
100-identity Value
101-ignore_builtin_innodb Value
102-init_connect Value
103-init_file Value
104-init_slave Value
105-innodb_adaptive_checkpoint Value
106-innodb_adaptive_flushing Value
107-innodb_adaptive_hash_index Value
108-innodb_additional_mem_pool_size Value
109-innodb_auto_lru_dump Value
110-innodb_autoextend_increment Value
111-innodb_autoinc_lock_mode Value
112-innodb_buffer_pool_shm_checksum Value
113-innodb_buffer_pool_shm_key Value
114-innodb_buffer_pool_size Value
115-innodb_change_buffering Value
116-innodb_checkpoint_age_target Value
117-innodb_checksums Value
118-innodb_commit_concurrency Value
119-innodb_concurrency_tickets Value
120-innodb_data_file_path Value
121-innodb_data_home_dir Value
122-innodb_dict_size_limit Value
123-innodb_doublewrite Value
124-innodb_doublewrite_file Value
125-innodb_enable_unsafe_group_commit Value
126-innodb_expand_import Value
127-innodb_extra_rsegments Value
128-innodb_extra_undoslots Value
129-innodb_fast_checksum Value
130-innodb_fast_recovery Value
131-innodb_fast_shutdown Value
132-innodb_file_format Value
133-innodb_file_format_check Value
134-innodb_file_per_table Value
135-innodb_flush_log_at_trx_commit Value
136-innodb_flush_log_at_trx_commit_session Value
137-innodb_flush_method Value
138-innodb_flush_neighbor_pages Value
139-innodb_force_recovery Value
140-innodb_ibuf_accel_rate Value
141-innodb_ibuf_active_contract Value
142-innodb_ibuf_max_size Value
143-innodb_io_capacity Value
144-innodb_lock_wait_timeout Value
145-innodb_locks_unsafe_for_binlog Value
146-innodb_log_buffer_size Value
147-innodb_log_file_size Value
148-innodb_log_files_in_group Value
149-innodb_log_group_home_dir Value
150-innodb_max_dirty_pages_pct Value
151-innodb_max_purge_lag Value
152-innodb_mirrored_log_groups Value
153-innodb_old_blocks_pct Value
154-innodb_old_blocks_time Value
155-innodb_open_files Value
156-innodb_overwrite_relay_log_info Value
157-innodb_page_size Value
158-innodb_pass_corrupt_table Value
159-innodb_read_ahead Value
160-innodb_read_ahead_threshold Value
161-innodb_read_io_threads Value
162-innodb_recovery_stats Value
163-innodb_replication_delay Value
164-innodb_rollback_on_timeout Value
165-innodb_show_locks_held Value
166-innodb_show_verbose_locks Value
167-innodb_spin_wait_delay Value
168-innodb_stats_auto_update Value
169-innodb_stats_method Value
170-innodb_stats_on_metadata Value
171-innodb_stats_sample_pages Value
172-innodb_stats_update_need_lock Value
173-innodb_strict_mode Value
174-innodb_support_xa Value
175-innodb_sync_spin_loops Value
176-innodb_table_locks Value
177-innodb_thread_concurrency Value
178-innodb_thread_concurrency_timer_based Value
179-innodb_thread_sleep_delay Value
180-innodb_use_purge_thread Value
181-innodb_use_sys_malloc Value
182-innodb_use_sys_stats_table Value
183-innodb_version Value
184-innodb_write_io_threads Value
185-insert_id Value
186-interactive_timeout Value
187-join_buffer_size Value
188-keep_files_on_create Value
189-key_buffer_size Value
190-key_cache_age_threshold Value
191-key_cache_block_size Value
192-key_cache_division_limit Value
193-language Value
194-large_files_support Value
195-large_page_size Value
196-large_pages Value
197-last_insert_id Value
198-lc_time_names Value
199-license Value
200-local_infile Value
201-locked_in_memory Value
202-log Value
203-log_bin Value
204-log_bin_trust_function_creators Value
205-log_bin_trust_routine_creators Value
206-log_error Value
207-log_output Value
208-log_queries_not_using_indexes Value
209-log_slave_updates Value
210-log_slow_filter Value
211-log_slow_queries Value
212-log_slow_rate_limit Value
213-log_slow_slave_statements Value
214-log_slow_sp_statements Value
215-log_slow_timestamp_every Value
216-log_slow_verbosity Value
217-log_warnings Value
218-long_query_time Value
219-low_priority_updates Value
220-lower_case_file_system Value
221-lower_case_table_names Value
222-max_allowed_packet Value
223-max_binlog_cache_size Value
224-max_binlog_size Value
225-max_connect_errors Value
226-max_connections Value
227-max_delayed_threads Value
228-max_error_count Value
229-max_heap_table_size Value
230-max_insert_delayed_threads Value
231-max_join_size Value
232-max_length_for_sort_data Value
233-max_prepared_stmt_count Value
234-max_relay_log_size Value
235-max_seeks_for_key Value
236-max_sort_length Value
237-max_sp_recursion_depth Value
238-max_tmp_tables Value
239-max_user_connections Value
240-max_write_lock_count Value
241-min_examined_row_limit Value
242-multi_range_count Value
243-myisam_data_pointer_size Value
244-myisam_max_sort_file_size Value
245-myisam_mmap_size Value
246-myisam_recover_options Value
247-myisam_repair_threads Value
248-myisam_sort_buffer_size Value
249-myisam_stats_method Value
250-myisam_use_mmap Value
251-net_buffer_length Value
252-net_read_timeout Value
253-net_retry_count Value
254-net_write_timeout Value
255-new Value
256-old Value
257-old_alter_table Value
258-old_passwords Value
259-open_files_limit Value
260-optimizer_fix Value
261-optimizer_prune_level Value
262-optimizer_search_depth Value
263-optimizer_switch Value
264-pid_file Value
265-plugin_dir Value
266-port Value
267-preload_buffer_size Value
268-profiling Value
269-profiling_history_size Value
270-profiling_server Value
271-profiling_use_getrusage Value
272-protocol_version Value
273-pseudo_thread_id Value
274-query_alloc_block_size Value
275-query_cache_limit Value
276-query_cache_min_res_unit Value
277-query_cache_size Value
278-query_cache_strip_comments Value
279-query_cache_type Value
280-query_cache_wlock_invalidate Value
281-query_prealloc_size Value
282-query_response_time_range_base Value
283-rand_seed1 Value
284-rand_seed2 Value
285-range_alloc_block_size Value
286-read_buffer_size Value
287-read_only Value
288-read_rnd_buffer_size Value
289-relay_log Value
290-relay_log_index Value
291-relay_log_info_file Value
292-relay_log_purge Value
293-relay_log_space_limit Value
294-report_host Value
295-report_password Value
296-report_port Value
297-report_user Value
298-rpl_recovery_rank Value
299-secure_auth Value
300-secure_file_priv Value
301-server_id Value
302-skip_external_locking Value
303-skip_name_resolve Value
304-skip_networking Value
305-skip_show_database Value
306-slave_compressed_protocol Value
307-slave_exec_mode Value
308-slave_load_tmpdir Value
309-slave_net_timeout Value
310-slave_skip_errors Value
311-slave_transaction_retries Value
312-slow_launch_time Value
313-slow_query_log Value
314-slow_query_log_file Value
315-slow_query_log_microseconds_timestamp Value
316-socket Value
317-sort_buffer_size Value
318-sql_auto_is_null Value
319-sql_big_selects Value
320-sql_big_tables Value
321-sql_buffer_result Value
322-sql_log_bin Value
323-sql_log_off Value
324-sql_log_update Value
325-sql_low_priority_updates Value
326-sql_max_join_size Value
327-sql_mode Value
328-sql_notes Value
329-sql_quote_show_create Value
330-sql_safe_updates Value
331-sql_select_limit Value
332-sql_slave_skip_counter Value
333-sql_warnings Value
334-ssl_ca Value
335-ssl_capath Value
336-ssl_cert Value
337-ssl_cipher Value
338-ssl_key Value
339-storage_engine Value
340-suppress_log_warning_1592 Value
341-sync_binlog Value
342-sync_frm Value
343-system_time_zone Value
344-table_definition_cache Value
345-table_lock_wait_timeout Value
346-table_open_cache Value
347-table_type Value
348-thread_cache_size Value
349-thread_handling Value
350-thread_stack Value
351-thread_statistics Value
352-time_format Value
353-time_zone Value
354-timed_mutexes Value
355-timestamp Value
356-tmp_table_size Value
357-tmpdir Value
358-transaction_alloc_block_size Value
359-transaction_prealloc_size Value
360-tx_isolation Value
361-unique_checks Value
362-updatable_views_with_limit Value
363-use_global_log_slow_control Value
364-use_global_long_query_time Value
365-userstat_running Value
366-version Value
367-version_comment Value
368-version_compile_machine Value
369-version_compile_os Value
370-wait_timeout Value
371-warning_count Value
372+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
373+Variable_name
374+AUTOCOMMIT
375+AUTOMATIC_SP_PRIVILEGES
376+AUTO_INCREMENT_INCREMENT
377+AUTO_INCREMENT_OFFSET
378+BACK_LOG
379+BASEDIR
380+BIG_TABLES
381+BINLOG_CACHE_SIZE
382+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
383+BINLOG_FORMAT
384+BULK_INSERT_BUFFER_SIZE
385+CHARACTER_SETS_DIR
386+CHARACTER_SET_CLIENT
387+CHARACTER_SET_CONNECTION
388+CHARACTER_SET_DATABASE
389+CHARACTER_SET_FILESYSTEM
390+CHARACTER_SET_RESULTS
391+CHARACTER_SET_SERVER
392+CHARACTER_SET_SYSTEM
393+COLLATION_CONNECTION
394+COLLATION_DATABASE
395+COLLATION_SERVER
396+COMPLETION_TYPE
397+CONCURRENT_INSERT
398+CONNECT_TIMEOUT
399+DATADIR
400+DATETIME_FORMAT
401+DATE_FORMAT
402+DEBUG
403+DEBUG_SYNC
404+DEFAULT_WEEK_FORMAT
405+DELAYED_INSERT_LIMIT
406+DELAYED_INSERT_TIMEOUT
407+DELAYED_QUEUE_SIZE
408+DELAY_KEY_WRITE
409+DIV_PRECISION_INCREMENT
410+ENABLE_QUERY_RESPONSE_TIME_STATS
411+ENGINE_CONDITION_PUSHDOWN
412+ERROR_COUNT
413+EVENT_SCHEDULER
414+EXPIRE_LOGS_DAYS
415+FAST_INDEX_CREATION
416+FLUSH
417+FLUSH_TIME
418+FOREIGN_KEY_CHECKS
419+FT_BOOLEAN_SYNTAX
420+FT_MAX_WORD_LEN
421+FT_MIN_WORD_LEN
422+FT_QUERY_EXPANSION_LIMIT
423+FT_STOPWORD_FILE
424+GENERAL_LOG
425+GENERAL_LOG_FILE
426+GROUP_CONCAT_MAX_LEN
427+HAVE_COMMUNITY_FEATURES
428+HAVE_COMPRESS
429+HAVE_CRYPT
430+HAVE_CSV
431+HAVE_DYNAMIC_LOADING
432+HAVE_GEOMETRY
433+HAVE_INNODB
434+HAVE_NDBCLUSTER
435+HAVE_OPENSSL
436+HAVE_PARTITIONING
437+HAVE_QUERY_CACHE
438+HAVE_RESPONSE_TIME_DISTRIBUTION
439+HAVE_RTREE_KEYS
440+HAVE_SSL
441+HAVE_SYMLINK
442+HOSTNAME
443+IDENTITY
444+IGNORE_BUILTIN_INNODB
445+INIT_CONNECT
446+INIT_FILE
447+INIT_SLAVE
448+INNODB_ADAPTIVE_CHECKPOINT
449+INNODB_ADAPTIVE_FLUSHING
450+INNODB_ADAPTIVE_HASH_INDEX
451+INNODB_ADDITIONAL_MEM_POOL_SIZE
452+INNODB_AUTOEXTEND_INCREMENT
453+INNODB_AUTOINC_LOCK_MODE
454+INNODB_AUTO_LRU_DUMP
455+INNODB_BUFFER_POOL_SHM_CHECKSUM
456+INNODB_BUFFER_POOL_SHM_KEY
457+INNODB_BUFFER_POOL_SIZE
458+INNODB_CHANGE_BUFFERING
459+INNODB_CHECKPOINT_AGE_TARGET
460+INNODB_CHECKSUMS
461+INNODB_COMMIT_CONCURRENCY
462+INNODB_CONCURRENCY_TICKETS
463+INNODB_DATA_FILE_PATH
464+INNODB_DATA_HOME_DIR
465+INNODB_DICT_SIZE_LIMIT
466+INNODB_DOUBLEWRITE
467+INNODB_DOUBLEWRITE_FILE
468+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
469+INNODB_EXPAND_IMPORT
470+INNODB_EXTRA_RSEGMENTS
471+INNODB_EXTRA_UNDOSLOTS
472+INNODB_FAST_CHECKSUM
473+INNODB_FAST_RECOVERY
474+INNODB_FAST_SHUTDOWN
475+INNODB_FILE_FORMAT
476+INNODB_FILE_FORMAT_CHECK
477+INNODB_FILE_PER_TABLE
478+INNODB_FLUSH_LOG_AT_TRX_COMMIT
479+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
480+INNODB_FLUSH_METHOD
481+INNODB_FLUSH_NEIGHBOR_PAGES
482+INNODB_FORCE_RECOVERY
483+INNODB_IBUF_ACCEL_RATE
484+INNODB_IBUF_ACTIVE_CONTRACT
485+INNODB_IBUF_MAX_SIZE
486+INNODB_IO_CAPACITY
487+INNODB_LAZY_DROP_TABLE
488+INNODB_LOCKS_UNSAFE_FOR_BINLOG
489+INNODB_LOCK_WAIT_TIMEOUT
490+INNODB_LOG_BLOCK_SIZE
491+INNODB_LOG_BUFFER_SIZE
492+INNODB_LOG_FILES_IN_GROUP
493+INNODB_LOG_FILE_SIZE
494+INNODB_LOG_GROUP_HOME_DIR
495+INNODB_MAX_DIRTY_PAGES_PCT
496+INNODB_MAX_PURGE_LAG
497+INNODB_MIRRORED_LOG_GROUPS
498+INNODB_OLD_BLOCKS_PCT
499+INNODB_OLD_BLOCKS_TIME
500+INNODB_OPEN_FILES
501+INNODB_OVERWRITE_RELAY_LOG_INFO
502+INNODB_PAGE_SIZE
503+INNODB_PASS_CORRUPT_TABLE
504+INNODB_READ_AHEAD
505+INNODB_READ_AHEAD_THRESHOLD
506+INNODB_READ_IO_THREADS
507+INNODB_RECOVERY_STATS
508+INNODB_REPLICATION_DELAY
509+INNODB_ROLLBACK_ON_TIMEOUT
510+INNODB_SHOW_LOCKS_HELD
511+INNODB_SHOW_VERBOSE_LOCKS
512+INNODB_SPIN_WAIT_DELAY
513+INNODB_STATS_AUTO_UPDATE
514+INNODB_STATS_METHOD
515+INNODB_STATS_ON_METADATA
516+INNODB_STATS_SAMPLE_PAGES
517+INNODB_STATS_UPDATE_NEED_LOCK
518+INNODB_STRICT_MODE
519+INNODB_SUPPORT_XA
520+INNODB_SYNC_SPIN_LOOPS
521+INNODB_TABLE_LOCKS
522+INNODB_THREAD_CONCURRENCY
523+INNODB_THREAD_CONCURRENCY_TIMER_BASED
524+INNODB_THREAD_SLEEP_DELAY
525+INNODB_USE_PURGE_THREAD
526+INNODB_USE_SYS_MALLOC
527+INNODB_USE_SYS_STATS_TABLE
528+INNODB_VERSION
529+INNODB_WRITE_IO_THREADS
530+INSERT_ID
531+INTERACTIVE_TIMEOUT
532+JOIN_BUFFER_SIZE
533+KEEP_FILES_ON_CREATE
534+KEY_BUFFER_SIZE
535+KEY_CACHE_AGE_THRESHOLD
536+KEY_CACHE_BLOCK_SIZE
537+KEY_CACHE_DIVISION_LIMIT
538+LANGUAGE
539+LARGE_FILES_SUPPORT
540+LARGE_PAGES
541+LARGE_PAGE_SIZE
542+LAST_INSERT_ID
543+LC_TIME_NAMES
544+LICENSE
545+LOCAL_INFILE
546+LOCKED_IN_MEMORY
547+LOG
548+LOG_BIN
549+LOG_BIN_TRUST_FUNCTION_CREATORS
550+LOG_BIN_TRUST_ROUTINE_CREATORS
551+LOG_ERROR
552+LOG_OUTPUT
553+LOG_QUERIES_NOT_USING_INDEXES
554+LOG_SLAVE_UPDATES
555+LOG_SLOW_FILTER
556+LOG_SLOW_QUERIES
557+LOG_SLOW_RATE_LIMIT
558+LOG_SLOW_SLAVE_STATEMENTS
559+LOG_SLOW_SP_STATEMENTS
560+LOG_SLOW_TIMESTAMP_EVERY
561+LOG_SLOW_VERBOSITY
562+LOG_WARNINGS
563+LONG_QUERY_TIME
564+LOWER_CASE_FILE_SYSTEM
565+LOWER_CASE_TABLE_NAMES
566+LOW_PRIORITY_UPDATES
567+MAX_ALLOWED_PACKET
568+MAX_BINLOG_CACHE_SIZE
569+MAX_BINLOG_SIZE
570+MAX_CONNECTIONS
571+MAX_CONNECT_ERRORS
572+MAX_DELAYED_THREADS
573+MAX_ERROR_COUNT
574+MAX_HEAP_TABLE_SIZE
575+MAX_INSERT_DELAYED_THREADS
576+MAX_JOIN_SIZE
577+MAX_LENGTH_FOR_SORT_DATA
578+MAX_LONG_DATA_SIZE
579+MAX_PREPARED_STMT_COUNT
580+MAX_RELAY_LOG_SIZE
581+MAX_SEEKS_FOR_KEY
582+MAX_SORT_LENGTH
583+MAX_SP_RECURSION_DEPTH
584+MAX_TMP_TABLES
585+MAX_USER_CONNECTIONS
586+MAX_WRITE_LOCK_COUNT
587+MIN_EXAMINED_ROW_LIMIT
588+MULTI_RANGE_COUNT
589+MYISAM_DATA_POINTER_SIZE
590+MYISAM_MAX_SORT_FILE_SIZE
591+MYISAM_MMAP_SIZE
592+MYISAM_RECOVER_OPTIONS
593+MYISAM_REPAIR_THREADS
594+MYISAM_SORT_BUFFER_SIZE
595+MYISAM_STATS_METHOD
596+MYISAM_USE_MMAP
597+NET_BUFFER_LENGTH
598+NET_READ_TIMEOUT
599+NET_RETRY_COUNT
600+NET_WRITE_TIMEOUT
601+NEW
602+OLD
603+OLD_ALTER_TABLE
604+OLD_PASSWORDS
605+OPEN_FILES_LIMIT
606+OPTIMIZER_FIX
607+OPTIMIZER_PRUNE_LEVEL
608+OPTIMIZER_SEARCH_DEPTH
609+OPTIMIZER_SWITCH
610+PID_FILE
611+PLUGIN_DIR
612+PORT
613+PRELOAD_BUFFER_SIZE
614+PROFILING
615+PROFILING_HISTORY_SIZE
616+PROFILING_SERVER
617+PROFILING_USE_GETRUSAGE
618+PROTOCOL_VERSION
619+PSEUDO_THREAD_ID
620+QUERY_ALLOC_BLOCK_SIZE
621+QUERY_CACHE_LIMIT
622+QUERY_CACHE_MIN_RES_UNIT
623+QUERY_CACHE_SIZE
624+QUERY_CACHE_STRIP_COMMENTS
625+QUERY_CACHE_TYPE
626+QUERY_CACHE_WLOCK_INVALIDATE
627+QUERY_PREALLOC_SIZE
628+QUERY_RESPONSE_TIME_RANGE_BASE
629+RAND_SEED1
630+RAND_SEED2
631+RANGE_ALLOC_BLOCK_SIZE
632+READ_BUFFER_SIZE
633+READ_ONLY
634+READ_RND_BUFFER_SIZE
635+RELAY_LOG
636+RELAY_LOG_INDEX
637+RELAY_LOG_INFO_FILE
638+RELAY_LOG_PURGE
639+RELAY_LOG_SPACE_LIMIT
640+REPORT_HOST
641+REPORT_PASSWORD
642+REPORT_PORT
643+REPORT_USER
644+RPL_RECOVERY_RANK
645+SECURE_AUTH
646+SECURE_FILE_PRIV
647+SERVER_ID
648+SKIP_EXTERNAL_LOCKING
649+SKIP_NAME_RESOLVE
650+SKIP_NETWORKING
651+SKIP_SHOW_DATABASE
652+SLAVE_COMPRESSED_PROTOCOL
653+SLAVE_EXEC_MODE
654+SLAVE_LOAD_TMPDIR
655+SLAVE_NET_TIMEOUT
656+SLAVE_SKIP_ERRORS
657+SLAVE_TRANSACTION_RETRIES
658+SLOW_LAUNCH_TIME
659+SLOW_QUERY_LOG
660+SLOW_QUERY_LOG_FILE
661+SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
662+SOCKET
663+SORT_BUFFER_SIZE
664+SQL_AUTO_IS_NULL
665+SQL_BIG_SELECTS
666+SQL_BIG_TABLES
667+SQL_BUFFER_RESULT
668+SQL_LOG_BIN
669+SQL_LOG_OFF
670+SQL_LOG_UPDATE
671+SQL_LOW_PRIORITY_UPDATES
672+SQL_MAX_JOIN_SIZE
673+SQL_MODE
674+SQL_NOTES
675+SQL_QUOTE_SHOW_CREATE
676+SQL_SAFE_UPDATES
677+SQL_SELECT_LIMIT
678+SQL_SLAVE_SKIP_COUNTER
679+SQL_WARNINGS
680+SSL_CA
681+SSL_CAPATH
682+SSL_CERT
683+SSL_CIPHER
684+SSL_KEY
685+STORAGE_ENGINE
686+SUPPRESS_LOG_WARNING_1592
687+SYNC_BINLOG
688+SYNC_FRM
689+SYSTEM_TIME_ZONE
690+TABLE_DEFINITION_CACHE
691+TABLE_LOCK_WAIT_TIMEOUT
692+TABLE_OPEN_CACHE
693+TABLE_TYPE
694+THREAD_CACHE_SIZE
695+THREAD_HANDLING
696+THREAD_STACK
697+THREAD_STATISTICS
698+TIMED_MUTEXES
699+TIMESTAMP
700+TIME_FORMAT
701+TIME_ZONE
702+TMPDIR
703+TMP_TABLE_SIZE
704+TRANSACTION_ALLOC_BLOCK_SIZE
705+TRANSACTION_PREALLOC_SIZE
706+TX_ISOLATION
707+UNIQUE_CHECKS
708+UPDATABLE_VIEWS_WITH_LIMIT
709+USERSTAT_RUNNING
710+USE_GLOBAL_LOG_SLOW_CONTROL
711+USE_GLOBAL_LONG_QUERY_TIME
712+VERSION
713+VERSION_COMMENT
714+VERSION_COMPILE_MACHINE
715+VERSION_COMPILE_OS
716+WAIT_TIMEOUT
717+WARNING_COUNT
718
719=== renamed file 'mysql-test/percona_server_variables.test' => 'mysql-test/percona_server_variables_debug.test'
720--- mysql-test/percona_server_variables.test 2010-12-14 20:03:02 +0000
721+++ mysql-test/percona_server_variables_debug.test 2011-06-23 02:23:22 +0000
722@@ -1,8 +1,2 @@
723---source include/have_response_time_distribution.inc
724---source include/have_innodb.inc
725 --source include/have_debug.inc
726-
727-#check the list of variable names
728---replace_column 2 Value
729-show variables;
730-
731+--source include/percona_server_variables.inc
732
733=== added file 'mysql-test/percona_server_variables_release.result'
734--- mysql-test/percona_server_variables_release.result 1970-01-01 00:00:00 +0000
735+++ mysql-test/percona_server_variables_release.result 2011-06-23 02:23:22 +0000
736@@ -0,0 +1,344 @@
737+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
738+Variable_name
739+AUTOCOMMIT
740+AUTOMATIC_SP_PRIVILEGES
741+AUTO_INCREMENT_INCREMENT
742+AUTO_INCREMENT_OFFSET
743+BACK_LOG
744+BASEDIR
745+BIG_TABLES
746+BINLOG_CACHE_SIZE
747+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
748+BINLOG_FORMAT
749+BULK_INSERT_BUFFER_SIZE
750+CHARACTER_SETS_DIR
751+CHARACTER_SET_CLIENT
752+CHARACTER_SET_CONNECTION
753+CHARACTER_SET_DATABASE
754+CHARACTER_SET_FILESYSTEM
755+CHARACTER_SET_RESULTS
756+CHARACTER_SET_SERVER
757+CHARACTER_SET_SYSTEM
758+COLLATION_CONNECTION
759+COLLATION_DATABASE
760+COLLATION_SERVER
761+COMPLETION_TYPE
762+CONCURRENT_INSERT
763+CONNECT_TIMEOUT
764+DATADIR
765+DATETIME_FORMAT
766+DATE_FORMAT
767+DEFAULT_WEEK_FORMAT
768+DELAYED_INSERT_LIMIT
769+DELAYED_INSERT_TIMEOUT
770+DELAYED_QUEUE_SIZE
771+DELAY_KEY_WRITE
772+DIV_PRECISION_INCREMENT
773+ENABLE_QUERY_RESPONSE_TIME_STATS
774+ENGINE_CONDITION_PUSHDOWN
775+ERROR_COUNT
776+EVENT_SCHEDULER
777+EXPIRE_LOGS_DAYS
778+FAST_INDEX_CREATION
779+FLUSH
780+FLUSH_TIME
781+FOREIGN_KEY_CHECKS
782+FT_BOOLEAN_SYNTAX
783+FT_MAX_WORD_LEN
784+FT_MIN_WORD_LEN
785+FT_QUERY_EXPANSION_LIMIT
786+FT_STOPWORD_FILE
787+GENERAL_LOG
788+GENERAL_LOG_FILE
789+GROUP_CONCAT_MAX_LEN
790+HAVE_COMMUNITY_FEATURES
791+HAVE_COMPRESS
792+HAVE_CRYPT
793+HAVE_CSV
794+HAVE_DYNAMIC_LOADING
795+HAVE_GEOMETRY
796+HAVE_INNODB
797+HAVE_NDBCLUSTER
798+HAVE_OPENSSL
799+HAVE_PARTITIONING
800+HAVE_QUERY_CACHE
801+HAVE_RESPONSE_TIME_DISTRIBUTION
802+HAVE_RTREE_KEYS
803+HAVE_SSL
804+HAVE_SYMLINK
805+HOSTNAME
806+IDENTITY
807+IGNORE_BUILTIN_INNODB
808+INIT_CONNECT
809+INIT_FILE
810+INIT_SLAVE
811+INNODB_ADAPTIVE_CHECKPOINT
812+INNODB_ADAPTIVE_FLUSHING
813+INNODB_ADAPTIVE_HASH_INDEX
814+INNODB_ADDITIONAL_MEM_POOL_SIZE
815+INNODB_AUTOEXTEND_INCREMENT
816+INNODB_AUTOINC_LOCK_MODE
817+INNODB_AUTO_LRU_DUMP
818+INNODB_BUFFER_POOL_SHM_CHECKSUM
819+INNODB_BUFFER_POOL_SHM_KEY
820+INNODB_BUFFER_POOL_SIZE
821+INNODB_CHANGE_BUFFERING
822+INNODB_CHECKPOINT_AGE_TARGET
823+INNODB_CHECKSUMS
824+INNODB_COMMIT_CONCURRENCY
825+INNODB_CONCURRENCY_TICKETS
826+INNODB_DATA_FILE_PATH
827+INNODB_DATA_HOME_DIR
828+INNODB_DICT_SIZE_LIMIT
829+INNODB_DOUBLEWRITE
830+INNODB_DOUBLEWRITE_FILE
831+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
832+INNODB_EXPAND_IMPORT
833+INNODB_EXTRA_RSEGMENTS
834+INNODB_EXTRA_UNDOSLOTS
835+INNODB_FAST_CHECKSUM
836+INNODB_FAST_RECOVERY
837+INNODB_FAST_SHUTDOWN
838+INNODB_FILE_FORMAT
839+INNODB_FILE_FORMAT_CHECK
840+INNODB_FILE_PER_TABLE
841+INNODB_FLUSH_LOG_AT_TRX_COMMIT
842+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
843+INNODB_FLUSH_METHOD
844+INNODB_FLUSH_NEIGHBOR_PAGES
845+INNODB_FORCE_RECOVERY
846+INNODB_IBUF_ACCEL_RATE
847+INNODB_IBUF_ACTIVE_CONTRACT
848+INNODB_IBUF_MAX_SIZE
849+INNODB_IO_CAPACITY
850+INNODB_LAZY_DROP_TABLE
851+INNODB_LOCKS_UNSAFE_FOR_BINLOG
852+INNODB_LOCK_WAIT_TIMEOUT
853+INNODB_LOG_BLOCK_SIZE
854+INNODB_LOG_BUFFER_SIZE
855+INNODB_LOG_FILES_IN_GROUP
856+INNODB_LOG_FILE_SIZE
857+INNODB_LOG_GROUP_HOME_DIR
858+INNODB_MAX_DIRTY_PAGES_PCT
859+INNODB_MAX_PURGE_LAG
860+INNODB_MIRRORED_LOG_GROUPS
861+INNODB_OLD_BLOCKS_PCT
862+INNODB_OLD_BLOCKS_TIME
863+INNODB_OPEN_FILES
864+INNODB_OVERWRITE_RELAY_LOG_INFO
865+INNODB_PAGE_SIZE
866+INNODB_PASS_CORRUPT_TABLE
867+INNODB_READ_AHEAD
868+INNODB_READ_AHEAD_THRESHOLD
869+INNODB_READ_IO_THREADS
870+INNODB_RECOVERY_STATS
871+INNODB_REPLICATION_DELAY
872+INNODB_ROLLBACK_ON_TIMEOUT
873+INNODB_SHOW_LOCKS_HELD
874+INNODB_SHOW_VERBOSE_LOCKS
875+INNODB_SPIN_WAIT_DELAY
876+INNODB_STATS_AUTO_UPDATE
877+INNODB_STATS_METHOD
878+INNODB_STATS_ON_METADATA
879+INNODB_STATS_SAMPLE_PAGES
880+INNODB_STATS_UPDATE_NEED_LOCK
881+INNODB_STRICT_MODE
882+INNODB_SUPPORT_XA
883+INNODB_SYNC_SPIN_LOOPS
884+INNODB_TABLE_LOCKS
885+INNODB_THREAD_CONCURRENCY
886+INNODB_THREAD_CONCURRENCY_TIMER_BASED
887+INNODB_THREAD_SLEEP_DELAY
888+INNODB_USE_PURGE_THREAD
889+INNODB_USE_SYS_MALLOC
890+INNODB_USE_SYS_STATS_TABLE
891+INNODB_VERSION
892+INNODB_WRITE_IO_THREADS
893+INSERT_ID
894+INTERACTIVE_TIMEOUT
895+JOIN_BUFFER_SIZE
896+KEEP_FILES_ON_CREATE
897+KEY_BUFFER_SIZE
898+KEY_CACHE_AGE_THRESHOLD
899+KEY_CACHE_BLOCK_SIZE
900+KEY_CACHE_DIVISION_LIMIT
901+LANGUAGE
902+LARGE_FILES_SUPPORT
903+LARGE_PAGES
904+LARGE_PAGE_SIZE
905+LAST_INSERT_ID
906+LC_TIME_NAMES
907+LICENSE
908+LOCAL_INFILE
909+LOCKED_IN_MEMORY
910+LOG
911+LOG_BIN
912+LOG_BIN_TRUST_FUNCTION_CREATORS
913+LOG_BIN_TRUST_ROUTINE_CREATORS
914+LOG_ERROR
915+LOG_OUTPUT
916+LOG_QUERIES_NOT_USING_INDEXES
917+LOG_SLAVE_UPDATES
918+LOG_SLOW_FILTER
919+LOG_SLOW_QUERIES
920+LOG_SLOW_RATE_LIMIT
921+LOG_SLOW_SLAVE_STATEMENTS
922+LOG_SLOW_SP_STATEMENTS
923+LOG_SLOW_TIMESTAMP_EVERY
924+LOG_SLOW_VERBOSITY
925+LOG_WARNINGS
926+LONG_QUERY_TIME
927+LOWER_CASE_FILE_SYSTEM
928+LOWER_CASE_TABLE_NAMES
929+LOW_PRIORITY_UPDATES
930+MAX_ALLOWED_PACKET
931+MAX_BINLOG_CACHE_SIZE
932+MAX_BINLOG_SIZE
933+MAX_CONNECTIONS
934+MAX_CONNECT_ERRORS
935+MAX_DELAYED_THREADS
936+MAX_ERROR_COUNT
937+MAX_HEAP_TABLE_SIZE
938+MAX_INSERT_DELAYED_THREADS
939+MAX_JOIN_SIZE
940+MAX_LENGTH_FOR_SORT_DATA
941+MAX_LONG_DATA_SIZE
942+MAX_PREPARED_STMT_COUNT
943+MAX_RELAY_LOG_SIZE
944+MAX_SEEKS_FOR_KEY
945+MAX_SORT_LENGTH
946+MAX_SP_RECURSION_DEPTH
947+MAX_TMP_TABLES
948+MAX_USER_CONNECTIONS
949+MAX_WRITE_LOCK_COUNT
950+MIN_EXAMINED_ROW_LIMIT
951+MULTI_RANGE_COUNT
952+MYISAM_DATA_POINTER_SIZE
953+MYISAM_MAX_SORT_FILE_SIZE
954+MYISAM_MMAP_SIZE
955+MYISAM_RECOVER_OPTIONS
956+MYISAM_REPAIR_THREADS
957+MYISAM_SORT_BUFFER_SIZE
958+MYISAM_STATS_METHOD
959+MYISAM_USE_MMAP
960+NET_BUFFER_LENGTH
961+NET_READ_TIMEOUT
962+NET_RETRY_COUNT
963+NET_WRITE_TIMEOUT
964+NEW
965+OLD
966+OLD_ALTER_TABLE
967+OLD_PASSWORDS
968+OPEN_FILES_LIMIT
969+OPTIMIZER_FIX
970+OPTIMIZER_PRUNE_LEVEL
971+OPTIMIZER_SEARCH_DEPTH
972+OPTIMIZER_SWITCH
973+PID_FILE
974+PLUGIN_DIR
975+PORT
976+PRELOAD_BUFFER_SIZE
977+PROFILING
978+PROFILING_HISTORY_SIZE
979+PROFILING_SERVER
980+PROFILING_USE_GETRUSAGE
981+PROTOCOL_VERSION
982+PSEUDO_THREAD_ID
983+QUERY_ALLOC_BLOCK_SIZE
984+QUERY_CACHE_LIMIT
985+QUERY_CACHE_MIN_RES_UNIT
986+QUERY_CACHE_SIZE
987+QUERY_CACHE_STRIP_COMMENTS
988+QUERY_CACHE_TYPE
989+QUERY_CACHE_WLOCK_INVALIDATE
990+QUERY_PREALLOC_SIZE
991+QUERY_RESPONSE_TIME_RANGE_BASE
992+RAND_SEED1
993+RAND_SEED2
994+RANGE_ALLOC_BLOCK_SIZE
995+READ_BUFFER_SIZE
996+READ_ONLY
997+READ_RND_BUFFER_SIZE
998+RELAY_LOG
999+RELAY_LOG_INDEX
1000+RELAY_LOG_INFO_FILE
1001+RELAY_LOG_PURGE
1002+RELAY_LOG_SPACE_LIMIT
1003+REPORT_HOST
1004+REPORT_PASSWORD
1005+REPORT_PORT
1006+REPORT_USER
1007+RPL_RECOVERY_RANK
1008+SECURE_AUTH
1009+SECURE_FILE_PRIV
1010+SERVER_ID
1011+SKIP_EXTERNAL_LOCKING
1012+SKIP_NAME_RESOLVE
1013+SKIP_NETWORKING
1014+SKIP_SHOW_DATABASE
1015+SLAVE_COMPRESSED_PROTOCOL
1016+SLAVE_EXEC_MODE
1017+SLAVE_LOAD_TMPDIR
1018+SLAVE_NET_TIMEOUT
1019+SLAVE_SKIP_ERRORS
1020+SLAVE_TRANSACTION_RETRIES
1021+SLOW_LAUNCH_TIME
1022+SLOW_QUERY_LOG
1023+SLOW_QUERY_LOG_FILE
1024+SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
1025+SOCKET
1026+SORT_BUFFER_SIZE
1027+SQL_AUTO_IS_NULL
1028+SQL_BIG_SELECTS
1029+SQL_BIG_TABLES
1030+SQL_BUFFER_RESULT
1031+SQL_LOG_BIN
1032+SQL_LOG_OFF
1033+SQL_LOG_UPDATE
1034+SQL_LOW_PRIORITY_UPDATES
1035+SQL_MAX_JOIN_SIZE
1036+SQL_MODE
1037+SQL_NOTES
1038+SQL_QUOTE_SHOW_CREATE
1039+SQL_SAFE_UPDATES
1040+SQL_SELECT_LIMIT
1041+SQL_SLAVE_SKIP_COUNTER
1042+SQL_WARNINGS
1043+SSL_CA
1044+SSL_CAPATH
1045+SSL_CERT
1046+SSL_CIPHER
1047+SSL_KEY
1048+STORAGE_ENGINE
1049+SUPPRESS_LOG_WARNING_1592
1050+SYNC_BINLOG
1051+SYNC_FRM
1052+SYSTEM_TIME_ZONE
1053+TABLE_DEFINITION_CACHE
1054+TABLE_LOCK_WAIT_TIMEOUT
1055+TABLE_OPEN_CACHE
1056+TABLE_TYPE
1057+THREAD_CACHE_SIZE
1058+THREAD_HANDLING
1059+THREAD_STACK
1060+THREAD_STATISTICS
1061+TIMED_MUTEXES
1062+TIMESTAMP
1063+TIME_FORMAT
1064+TIME_ZONE
1065+TMPDIR
1066+TMP_TABLE_SIZE
1067+TRANSACTION_ALLOC_BLOCK_SIZE
1068+TRANSACTION_PREALLOC_SIZE
1069+TX_ISOLATION
1070+UNIQUE_CHECKS
1071+UPDATABLE_VIEWS_WITH_LIMIT
1072+USERSTAT_RUNNING
1073+USE_GLOBAL_LOG_SLOW_CONTROL
1074+USE_GLOBAL_LONG_QUERY_TIME
1075+VERSION
1076+VERSION_COMMENT
1077+VERSION_COMPILE_MACHINE
1078+VERSION_COMPILE_OS
1079+WAIT_TIMEOUT
1080+WARNING_COUNT
1081
1082=== added file 'mysql-test/percona_server_variables_release.test'
1083--- mysql-test/percona_server_variables_release.test 1970-01-01 00:00:00 +0000
1084+++ mysql-test/percona_server_variables_release.test 2011-06-23 02:23:22 +0000
1085@@ -0,0 +1,2 @@
1086+--source include/have_nodebug.inc
1087+--source include/percona_server_variables.inc

Subscribers

People subscribed via source and target branches