← Back to branch summary

~percona-toolkit-dev/percona-toolkit/mysql-5.6-test-fixes

« back to all changes in this revision

Viewing changes to t/lib/samples/show-variables/vars-baron-002.txt

  • Committer: Daniel Nichter
  • Date: 2011-06-24 17:22:06 UTC
  • Revision ID: daniel@percona.com-20110624172206-c7q4s4ad6r260zz6
Add lib/, t/lib/, and sandbox/.  All modules are updated and passing on MySQL 5.1.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/lib/samples/show-variables/vars-baron-002.txt
 
1
Variable_name   Value
 
2
auto_increment_increment        4
 
3
auto_increment_offset   2
 
4
autocommit      ON
 
5
automatic_sp_privileges ON
 
6
back_log        50
 
7
basedir /usr/
 
8
big_tables      OFF
 
9
binlog_cache_size       32768
 
10
binlog_format   MIXED
 
11
bulk_insert_buffer_size 8388608
 
12
character_set_client    latin1
 
13
character_set_connection        latin1
 
14
character_set_database  latin1
 
15
character_set_filesystem        binary
 
16
character_set_results   latin1
 
17
character_set_server    latin1
 
18
character_set_system    utf8
 
19
character_sets_dir      /usr/share/mysql/charsets/
 
20
collation_connection    latin1_swedish_ci
 
21
collation_database      latin1_swedish_ci
 
22
collation_server        latin1_swedish_ci
 
23
completion_type 0
 
24
concurrent_insert       2
 
25
connect_timeout 10
 
26
datadir /mnt/data-store/mysql/data/
 
27
date_format     %Y-%m-%d
 
28
datetime_format %Y-%m-%d %H:%i:%s
 
29
default_week_format     0
 
30
delay_key_write ON
 
31
delayed_insert_limit    100
 
32
delayed_insert_timeout  300
 
33
delayed_queue_size      1000
 
34
div_precision_increment 4
 
35
engine_condition_pushdown       ON
 
36
error_count     0
 
37
event_scheduler OFF
 
38
expire_logs_days        3
 
39
flush   OFF
 
40
flush_time      0
 
41
foreign_key_checks      ON
 
42
ft_boolean_syntax       + -><()~*:""&|
 
43
ft_max_word_len 84
 
44
ft_min_word_len 4
 
45
ft_query_expansion_limit        20
 
46
ft_stopword_file        (built-in)
 
47
general_log     OFF
 
48
general_log_file        /mnt/mysql/general.log
 
49
group_concat_max_len    1024
 
50
have_community_features YES
 
51
have_compress   YES
 
52
have_crypt      YES
 
53
have_csv        YES
 
54
have_dynamic_loading    YES
 
55
have_geometry   YES
 
56
have_innodb     YES
 
57
have_ndbcluster NO
 
58
have_openssl    DISABLED
 
59
have_partitioning       YES
 
60
have_query_cache        YES
 
61
have_rtree_keys YES
 
62
have_ssl        DISABLED
 
63
have_symlink    YES
 
64
hostname        db1.production.company.com
 
65
identity        0
 
66
ignore_builtin_innodb   OFF
 
67
init_connect    
 
68
init_file       
 
69
init_slave      
 
70
innodb_adaptive_checkpoint      estimate
 
71
innodb_adaptive_flushing        OFF
 
72
innodb_adaptive_hash_index      OFF
 
73
innodb_additional_mem_pool_size 524288000
 
74
innodb_autoextend_increment     8
 
75
innodb_autoinc_lock_mode        0
 
76
innodb_buffer_pool_size 46170898432
 
77
innodb_change_buffering inserts
 
78
innodb_checkpoint_age_target    0
 
79
innodb_checksums        ON
 
80
innodb_commit_concurrency       0
 
81
innodb_concurrency_tickets      500
 
82
innodb_data_file_path   ibdata1:10M:autoextend
 
83
innodb_data_home_dir    /mnt/data-store/mysql/data
 
84
innodb_dict_size_limit  0
 
85
innodb_doublewrite      ON
 
86
innodb_enable_unsafe_group_commit       0
 
87
innodb_expand_import    0
 
88
innodb_extra_rsegments  0
 
89
innodb_extra_undoslots  OFF
 
90
innodb_fast_recovery    ON
 
91
innodb_fast_shutdown    1
 
92
innodb_file_format      Antelope
 
93
innodb_file_format_check        Barracuda
 
94
innodb_file_per_table   ON
 
95
innodb_flush_log_at_trx_commit  2
 
96
innodb_flush_method     
 
97
innodb_flush_neighbor_pages     1
 
98
innodb_force_recovery   0
 
99
innodb_ibuf_accel_rate  100
 
100
innodb_ibuf_active_contract     1
 
101
innodb_ibuf_max_size    23085432832
 
102
innodb_io_capacity      200
 
103
innodb_lock_wait_timeout        50
 
104
innodb_locks_unsafe_for_binlog  OFF
 
105
innodb_log_buffer_size  10485760
 
106
innodb_log_file_size    2097152000
 
107
innodb_log_files_in_group       2
 
108
innodb_log_group_home_dir       /mnt/data-store/mysql/data
 
109
innodb_max_dirty_pages_pct      75
 
110
innodb_max_purge_lag    0
 
111
innodb_mirrored_log_groups      1
 
112
innodb_old_blocks_pct   37
 
113
innodb_old_blocks_time  0
 
114
innodb_open_files       300
 
115
innodb_overwrite_relay_log_info OFF
 
116
innodb_read_ahead       linear
 
117
innodb_read_ahead_threshold     56
 
118
innodb_read_io_threads  4
 
119
innodb_recovery_stats   OFF
 
120
innodb_relax_table_creation     0
 
121
innodb_replication_delay        0
 
122
innodb_rollback_on_timeout      OFF
 
123
innodb_show_locks_held  10
 
124
innodb_show_verbose_locks       0
 
125
innodb_spin_wait_delay  6
 
126
innodb_stats_auto_update        1
 
127
innodb_stats_method     nulls_equal
 
128
innodb_stats_on_metadata        ON
 
129
innodb_stats_sample_pages       8
 
130
innodb_stats_update_need_lock   1
 
131
innodb_strict_mode      OFF
 
132
innodb_support_xa       OFF
 
133
innodb_sync_spin_loops  30
 
134
innodb_table_locks      ON
 
135
innodb_thread_concurrency       16
 
136
innodb_thread_concurrency_timer_based   OFF
 
137
innodb_thread_sleep_delay       10000
 
138
innodb_use_purge_thread 1
 
139
innodb_use_sys_malloc   ON
 
140
innodb_version  1.0.6-unknown
 
141
innodb_write_io_threads 4
 
142
insert_id       0
 
143
interactive_timeout     28800
 
144
join_buffer_size        131072
 
145
keep_files_on_create    OFF
 
146
key_buffer_size 157286400
 
147
key_cache_age_threshold 300
 
148
key_cache_block_size    1024
 
149
key_cache_division_limit        100
 
150
language        /usr/share/mysql/english/
 
151
large_files_support     ON
 
152
large_page_size 0
 
153
large_pages     OFF
 
154
last_insert_id  0
 
155
lc_time_names   en_US
 
156
license GPL
 
157
local_infile    ON
 
158
locked_in_memory        OFF
 
159
log     OFF
 
160
log_bin ON
 
161
log_bin_trust_function_creators OFF
 
162
log_bin_trust_routine_creators  OFF
 
163
log_error       /mnt/data-store/mysql/mysql.err
 
164
log_output      FILE
 
165
log_queries_not_using_indexes   ON
 
166
log_slave_updates       ON
 
167
log_slow_queries        ON
 
168
log_warnings    1
 
169
long_query_time 0.500000
 
170
low_priority_updates    OFF
 
171
lower_case_file_system  OFF
 
172
lower_case_table_names  0
 
173
max_allowed_packet      104857600
 
174
max_binlog_cache_size   18446744073709547520
 
175
max_binlog_size 524288000
 
176
max_connect_errors      10
 
177
max_connections 1500
 
178
max_delayed_threads     20
 
179
max_error_count 64
 
180
max_heap_table_size     822083584
 
181
max_insert_delayed_threads      20
 
182
max_join_size   18446744073709551615
 
183
max_length_for_sort_data        1024
 
184
max_prepared_stmt_count 16382
 
185
max_relay_log_size      0
 
186
max_seeks_for_key       18446744073709551615
 
187
max_sort_length 1024
 
188
max_sp_recursion_depth  0
 
189
max_tmp_tables  32
 
190
max_user_connections    0
 
191
max_write_lock_count    18446744073709551615
 
192
min_examined_row_limit  10000
 
193
multi_range_count       256
 
194
myisam_data_pointer_size        6
 
195
myisam_max_sort_file_size       9223372036853727232
 
196
myisam_mmap_size        18446744073709551615
 
197
myisam_recover_options  OFF
 
198
myisam_repair_threads   1
 
199
myisam_sort_buffer_size 67108864
 
200
myisam_stats_method     nulls_unequal
 
201
myisam_use_mmap OFF
 
202
net_buffer_length       16384
 
203
net_read_timeout        30
 
204
net_retry_count 10
 
205
net_write_timeout       120
 
206
new     OFF
 
207
old     OFF
 
208
old_alter_table OFF
 
209
old_passwords   OFF
 
210
open_files_limit        7500
 
211
optimizer_prune_level   1
 
212
optimizer_search_depth  62
 
213
optimizer_switch        index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on
 
214
pid_file        /mnt/data-store/mysql/data/mysql.pid
 
215
plugin_dir      /usr/lib/mysql/plugin
 
216
port    3306
 
217
preload_buffer_size     32768
 
218
profiling       OFF
 
219
profiling_history_size  15
 
220
protocol_version        10
 
221
pseudo_thread_id        0
 
222
query_alloc_block_size  8192
 
223
query_cache_limit       1048576
 
224
query_cache_min_res_unit        4096
 
225
query_cache_size        0
 
226
query_cache_type        OFF
 
227
query_cache_wlock_invalidate    OFF
 
228
query_prealloc_size     8192
 
229
rand_seed1      
 
230
rand_seed2      
 
231
range_alloc_block_size  4096
 
232
read_buffer_size        16777216
 
233
read_only       OFF
 
234
read_rnd_buffer_size    16777216
 
235
relay_log       /mnt/data-store/mysql/logs/mysql-relay
 
236
relay_log_index 
 
237
relay_log_info_file     relay-log.info
 
238
relay_log_purge ON
 
239
relay_log_space_limit   0
 
240
report_host     
 
241
report_password 
 
242
report_port     3306
 
243
report_user     
 
244
rpl_recovery_rank       0
 
245
secure_auth     OFF
 
246
secure_file_priv        
 
247
server_id       2171234
 
248
skip_external_locking   ON
 
249
skip_networking OFF
 
250
skip_show_database      OFF
 
251
slave_compressed_protocol       OFF
 
252
slave_exec_mode IDEMPOTENT
 
253
slave_load_tmpdir       /mnt/tmp
 
254
slave_net_timeout       3600
 
255
slave_skip_errors       OFF
 
256
slave_transaction_retries       10
 
257
slow_launch_time        2
 
258
slow_query_log  ON
 
259
slow_query_log_file     /mnt/data-store/mysql/logs/slowquery.log
 
260
socket  /tmp/mysql.sock
 
261
sort_buffer_size        8388608
 
262
sql_auto_is_null        ON
 
263
sql_big_selects ON
 
264
sql_big_tables  OFF
 
265
sql_buffer_result       OFF
 
266
sql_log_bin     ON
 
267
sql_log_off     OFF
 
268
sql_log_update  ON
 
269
sql_low_priority_updates        OFF
 
270
sql_max_join_size       18446744073709551615
 
271
sql_mode        
 
272
sql_notes       ON
 
273
sql_quote_show_create   ON
 
274
sql_safe_updates        OFF
 
275
sql_select_limit        18446744073709551615
 
276
sql_slave_skip_counter  
 
277
sql_warnings    OFF
 
278
ssl_ca  
 
279
ssl_capath      
 
280
ssl_cert        
 
281
ssl_cipher      
 
282
ssl_key 
 
283
storage_engine  MyISAM
 
284
sync_binlog     0
 
285
sync_frm        ON
 
286
system_time_zone        EST
 
287
table_definition_cache  256
 
288
table_lock_wait_timeout 50
 
289
table_open_cache        2000
 
290
table_type      MyISAM
 
291
thread_cache_size       8
 
292
thread_handling one-thread-per-connection
 
293
thread_stack    262144
 
294
time_format     %H:%i:%s
 
295
time_zone       SYSTEM
 
296
timed_mutexes   OFF
 
297
timestamp       1300546448
 
298
tmp_table_size  822083584
 
299
tmpdir  /mnt/tmp
 
300
transaction_alloc_block_size    8192
 
301
transaction_prealloc_size       4096
 
302
tx_isolation    REPEATABLE-READ
 
303
unique_checks   ON
 
304
updatable_views_with_limit      YES
 
305
version 5.1.43-60.hardy.7-log
 
306
version_comment (Percona SQL Server (GPL), XtraDB , Revision )
 
307
version_compile_machine x86_64
 
308
version_compile_os      debian-linux-gnu
 
309
wait_timeout    28800
 
310
warning_count   0
 
311