← Back to branch summary

~percona-toolkit-dev/percona-toolkit/pt-agent

« back to all changes in this revision

Viewing changes to t/lib/samples/show-variables/vars002.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/vars002.txt
 
1
Variable_name   Value
 
2
auto_increment_increment        1
 
3
auto_increment_offset   1
 
4
autocommit      ON
 
5
automatic_sp_privileges ON
 
6
back_log        50
 
7
basedir /home/daniel/mysql_binaries/mysql-5.1.34-linux-x86_64-glibc23/
 
8
big_tables      OFF
 
9
binlog_cache_size       32768
 
10
binlog_format   STATEMENT
 
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      /home/daniel/mysql_binaries/mysql-5.1.34-linux-x86_64-glibc23/share/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       1
 
25
connect_timeout 10
 
26
datadir /tmp/12345/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        0
 
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        /tmp/12345/data/mysql_sandbox12345.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        dante
 
65
identity        0
 
66
ignore_builtin_innodb   OFF
 
67
init_connect    
 
68
init_file       
 
69
init_slave      
 
70
innodb_adaptive_hash_index      ON
 
71
innodb_additional_mem_pool_size 1048576
 
72
innodb_autoextend_increment     8
 
73
innodb_autoinc_lock_mode        1
 
74
innodb_buffer_pool_size 16777216
 
75
innodb_checksums        ON
 
76
innodb_commit_concurrency       0
 
77
innodb_concurrency_tickets      500
 
78
innodb_data_file_path   ibdata1:10M:autoextend
 
79
innodb_data_home_dir    /tmp/12345/data
 
80
innodb_doublewrite      ON
 
81
innodb_fast_shutdown    1
 
82
innodb_file_io_threads  4
 
83
innodb_file_per_table   OFF
 
84
innodb_flush_log_at_trx_commit  1
 
85
innodb_flush_method     
 
86
innodb_force_recovery   0
 
87
innodb_lock_wait_timeout        3
 
88
innodb_locks_unsafe_for_binlog  OFF
 
89
innodb_log_buffer_size  1048576
 
90
innodb_log_file_size    5242880
 
91
innodb_log_files_in_group       2
 
92
innodb_log_group_home_dir       /tmp/12345/data
 
93
innodb_max_dirty_pages_pct      90
 
94
innodb_max_purge_lag    0
 
95
innodb_mirrored_log_groups      1
 
96
innodb_open_files       300
 
97
innodb_rollback_on_timeout      OFF
 
98
innodb_stats_on_metadata        ON
 
99
innodb_support_xa       ON
 
100
innodb_sync_spin_loops  20
 
101
innodb_table_locks      ON
 
102
innodb_thread_concurrency       8
 
103
innodb_thread_sleep_delay       10000
 
104
insert_id       0
 
105
interactive_timeout     28800
 
106
join_buffer_size        131072
 
107
keep_files_on_create    OFF
 
108
key_buffer_size 16777216
 
109
key_cache_age_threshold 300
 
110
key_cache_block_size    1024
 
111
key_cache_division_limit        100
 
112
language        /home/daniel/mysql_binaries/mysql-5.1.34-linux-x86_64-glibc23/share/english/
 
113
large_files_support     ON
 
114
large_page_size 0
 
115
large_pages     OFF
 
116
last_insert_id  0
 
117
lc_time_names   en_US
 
118
license GPL
 
119
local_infile    ON
 
120
locked_in_memory        OFF
 
121
log     OFF
 
122
log_bin ON
 
123
log_bin_trust_function_creators OFF
 
124
log_bin_trust_routine_creators  OFF
 
125
log_error       /tmp/12345/data/mysqld.log
 
126
log_output      FILE
 
127
log_queries_not_using_indexes   OFF
 
128
log_slave_updates       ON
 
129
log_slow_queries        OFF
 
130
log_warnings    1
 
131
long_query_time 10.000000
 
132
low_priority_updates    OFF
 
133
lower_case_file_system  OFF
 
134
lower_case_table_names  0
 
135
max_allowed_packet      1048576
 
136
max_binlog_cache_size   18446744073709547520
 
137
max_binlog_size 1073741824
 
138
max_connect_errors      10
 
139
max_connections 151
 
140
max_delayed_threads     20
 
141
max_error_count 64
 
142
max_heap_table_size     16777216
 
143
max_insert_delayed_threads      20
 
144
max_join_size   18446744073709551615
 
145
max_length_for_sort_data        1024
 
146
max_prepared_stmt_count 16382
 
147
max_relay_log_size      0
 
148
max_seeks_for_key       18446744073709551615
 
149
max_sort_length 1024
 
150
max_sp_recursion_depth  0
 
151
max_tmp_tables  32
 
152
max_user_connections    0
 
153
max_write_lock_count    18446744073709551615
 
154
min_examined_row_limit  0
 
155
multi_range_count       256
 
156
myisam_data_pointer_size        6
 
157
myisam_max_sort_file_size       9223372036853727232
 
158
myisam_recover_options  OFF
 
159
myisam_repair_threads   1
 
160
myisam_sort_buffer_size 8388608
 
161
myisam_stats_method     nulls_unequal
 
162
myisam_use_mmap OFF
 
163
net_buffer_length       16384
 
164
net_read_timeout        30
 
165
net_retry_count 10
 
166
net_write_timeout       60
 
167
new     OFF
 
168
old     OFF
 
169
old_alter_table OFF
 
170
old_passwords   OFF
 
171
open_files_limit        1024
 
172
optimizer_prune_level   1
 
173
optimizer_search_depth  62
 
174
optimizer_switch        index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on
 
175
pid_file        /tmp/12345/data/mysql_sandbox12345.pid
 
176
plugin_dir      /home/daniel/mysql_binaries/mysql-5.1.34-linux-x86_64-glibc23/lib/plugin
 
177
port    12345
 
178
preload_buffer_size     32768
 
179
profiling       OFF
 
180
profiling_history_size  15
 
181
protocol_version        10
 
182
pseudo_thread_id        25
 
183
query_alloc_block_size  8192
 
184
query_cache_limit       1048576
 
185
query_cache_min_res_unit        4096
 
186
query_cache_size        0
 
187
query_cache_type        ON
 
188
query_cache_wlock_invalidate    OFF
 
189
query_prealloc_size     8192
 
190
rand_seed1      
 
191
rand_seed2      
 
192
range_alloc_block_size  4096
 
193
read_buffer_size        131072
 
194
read_only       OFF
 
195
read_rnd_buffer_size    262144
 
196
relay_log       mysql-relay-bin
 
197
relay_log_index 
 
198
relay_log_info_file     relay-log.info
 
199
relay_log_purge ON
 
200
relay_log_space_limit   0
 
201
report_host     127.0.0.1
 
202
report_password 
 
203
report_port     12345
 
204
report_user     
 
205
rpl_recovery_rank       0
 
206
secure_auth     OFF
 
207
secure_file_priv        
 
208
server_id       12345
 
209
skip_external_locking   ON
 
210
skip_networking OFF
 
211
skip_show_database      OFF
 
212
slave_compressed_protocol       OFF
 
213
slave_exec_mode STRICT
 
214
slave_load_tmpdir       /tmp
 
215
slave_net_timeout       3600
 
216
slave_skip_errors       
 
217
slave_transaction_retries       10
 
218
slow_launch_time        2
 
219
slow_query_log  OFF
 
220
slow_query_log_file     /tmp/12345/data/mysql_sandbox12345-slow.log
 
221
socket  /tmp/12345/mysql_sandbox12345.sock
 
222
sort_buffer_size        2097144
 
223
sql_auto_is_null        ON
 
224
sql_big_selects ON
 
225
sql_big_tables  OFF
 
226
sql_buffer_result       OFF
 
227
sql_log_bin     ON
 
228
sql_log_off     OFF
 
229
sql_log_update  ON
 
230
sql_low_priority_updates        OFF
 
231
sql_max_join_size       18446744073709551615
 
232
sql_mode        
 
233
sql_notes       ON
 
234
sql_quote_show_create   ON
 
235
sql_safe_updates        OFF
 
236
sql_select_limit        18446744073709551615
 
237
sql_slave_skip_counter  
 
238
sql_warnings    OFF
 
239
ssl_ca  
 
240
ssl_capath      
 
241
ssl_cert        
 
242
ssl_cipher      
 
243
ssl_key 
 
244
storage_engine  MyISAM
 
245
sync_binlog     0
 
246
sync_frm        ON
 
247
system_time_zone        MDT
 
248
table_definition_cache  256
 
249
table_lock_wait_timeout 50
 
250
table_open_cache        64
 
251
table_type      MyISAM
 
252
thread_cache_size       0
 
253
thread_handling one-thread-per-connection
 
254
thread_stack    262144
 
255
time_format     %H:%i:%s
 
256
time_zone       SYSTEM
 
257
timed_mutexes   OFF
 
258
timestamp       1281712414
 
259
tmp_table_size  16777216
 
260
tmpdir  /tmp
 
261
transaction_alloc_block_size    8192
 
262
transaction_prealloc_size       4096
 
263
tx_isolation    REPEATABLE-READ
 
264
unique_checks   ON
 
265
updatable_views_with_limit      YES
 
266
version 5.1.34-log
 
267
version_comment MySQL Community Server (GPL)
 
268
version_compile_machine x86_64
 
269
version_compile_os      unknown-linux-gnu
 
270
wait_timeout    28800
 
271
warning_count   0