← Back to branch summary

~percona-toolkit-dev/percona-toolkit/fix-1015590-pt-mysql-summary-percona-server-5.5

« back to all changes in this revision

Viewing changes to t/pt-mysql-summary/samples/percona-server-5.5-variables

  • Committer: Brian Fraser
  • Date: 2012-11-02 03:21:48 UTC
  • Revision ID: brian.fraser@percona.com-20121102032148-7kj28hr68zdzmsxx
Fix for 1015590: pt-mysql-summary not Percona Server 5.5-ready

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-mysql-summary/samples/percona-server-5.5-variables
 
1
auto_increment_increment        1
 
2
auto_increment_offset   1
 
3
autocommit      ON
 
4
automatic_sp_privileges ON
 
5
back_log        50
 
6
basedir /home/hugmeir/mysql/Percona-Server-5.5.23-rel25.3-240.Linux.x86_64
 
7
big_tables      OFF
 
8
binlog_cache_size       32768
 
9
binlog_direct_non_transactional_updates OFF
 
10
binlog_format   STATEMENT
 
11
binlog_stmt_cache_size  32768
 
12
bulk_insert_buffer_size 8388608
 
13
character_set_client    latin1
 
14
character_set_connection        latin1
 
15
character_set_database  latin1
 
16
character_set_filesystem        binary
 
17
character_set_results   latin1
 
18
character_set_server    latin1
 
19
character_set_system    utf8
 
20
character_sets_dir      /home/hugmeir/mysql/Percona-Server-5.5.23-rel25.3-240.Linux.x86_64/share/charsets/
 
21
collation_connection    latin1_swedish_ci
 
22
collation_database      latin1_swedish_ci
 
23
collation_server        latin1_swedish_ci
 
24
completion_type NO_CHAIN
 
25
concurrent_insert       AUTO
 
26
connect_timeout 10
 
27
datadir /tmp/12345/data/
 
28
date_format     %Y-%m-%d
 
29
datetime_format %Y-%m-%d %H:%i:%s
 
30
default_storage_engine  InnoDB
 
31
default_week_format     0
 
32
delay_key_write ON
 
33
delayed_insert_limit    100
 
34
delayed_insert_timeout  300
 
35
delayed_queue_size      1000
 
36
div_precision_increment 4
 
37
engine_condition_pushdown       ON
 
38
event_scheduler OFF
 
39
expand_fast_index_creation      OFF
 
40
expire_logs_days        0
 
41
fast_index_creation     ON
 
42
flush   OFF
 
43
flush_time      0
 
44
foreign_key_checks      ON
 
45
ft_boolean_syntax       + -><()~*:""&|
 
46
ft_max_word_len 84
 
47
ft_min_word_len 4
 
48
ft_query_expansion_limit        20
 
49
ft_stopword_file        (built-in)
 
50
general_log     ON
 
51
general_log_file        genlog
 
52
group_concat_max_len    1024
 
53
have_compress   YES
 
54
have_crypt      YES
 
55
have_csv        YES
 
56
have_dynamic_loading    YES
 
57
have_geometry   YES
 
58
have_innodb     YES
 
59
have_ndbcluster NO
 
60
have_openssl    DISABLED
 
61
have_partitioning       YES
 
62
have_profiling  YES
 
63
have_query_cache        YES
 
64
have_response_time_distribution YES
 
65
have_rtree_keys YES
 
66
have_ssl        DISABLED
 
67
have_symlink    YES
 
68
hostname        naw
 
69
ignore_builtin_innodb   OFF
 
70
init_connect    
 
71
init_file       
 
72
init_slave      
 
73
innodb_adaptive_flushing        ON
 
74
innodb_adaptive_flushing_method estimate
 
75
innodb_adaptive_hash_index      ON
 
76
innodb_adaptive_hash_index_partitions   1
 
77
innodb_additional_mem_pool_size 8388608
 
78
innodb_autoextend_increment     8
 
79
innodb_autoinc_lock_mode        1
 
80
innodb_blocking_buffer_pool_restore     OFF
 
81
innodb_buffer_pool_instances    1
 
82
innodb_buffer_pool_restore_at_startup   0
 
83
innodb_buffer_pool_shm_checksum ON
 
84
innodb_buffer_pool_shm_key      0
 
85
innodb_buffer_pool_size 33554432
 
86
innodb_change_buffering all
 
87
innodb_checkpoint_age_target    0
 
88
innodb_checksums        ON
 
89
innodb_commit_concurrency       0
 
90
innodb_concurrency_tickets      500
 
91
innodb_corrupt_table_action     assert
 
92
innodb_data_file_path   ibdata1:10M:autoextend
 
93
innodb_data_home_dir    /tmp/12345/data
 
94
innodb_dict_size_limit  0
 
95
innodb_doublewrite      ON
 
96
innodb_doublewrite_file 
 
97
innodb_fake_changes     OFF
 
98
innodb_fast_checksum    OFF
 
99
innodb_fast_shutdown    1
 
100
innodb_file_format      Antelope
 
101
innodb_file_format_check        ON
 
102
innodb_file_format_max  Antelope
 
103
innodb_file_per_table   OFF
 
104
innodb_flush_log_at_trx_commit  1
 
105
innodb_flush_method     
 
106
innodb_flush_neighbor_pages     area
 
107
innodb_force_load_corrupted     OFF
 
108
innodb_force_recovery   0
 
109
innodb_ibuf_accel_rate  100
 
110
innodb_ibuf_active_contract     1
 
111
innodb_ibuf_max_size    16760832
 
112
innodb_import_table_from_xtrabackup     0
 
113
innodb_io_capacity      200
 
114
innodb_kill_idle_transaction    0
 
115
innodb_large_prefix     OFF
 
116
innodb_lazy_drop_table  0
 
117
innodb_lock_wait_timeout        3
 
118
innodb_locks_unsafe_for_binlog  OFF
 
119
innodb_log_block_size   512
 
120
innodb_log_buffer_size  8388608
 
121
innodb_log_file_size    5242880
 
122
innodb_log_files_in_group       2
 
123
innodb_log_group_home_dir       /tmp/12345/data
 
124
innodb_max_dirty_pages_pct      75
 
125
innodb_max_purge_lag    0
 
126
innodb_mirrored_log_groups      1
 
127
innodb_old_blocks_pct   37
 
128
innodb_old_blocks_time  0
 
129
innodb_open_files       300
 
130
innodb_page_size        16384
 
131
innodb_purge_batch_size 20
 
132
innodb_purge_threads    1
 
133
innodb_random_read_ahead        OFF
 
134
innodb_read_ahead       linear
 
135
innodb_read_ahead_threshold     56
 
136
innodb_read_io_threads  4
 
137
innodb_recovery_stats   OFF
 
138
innodb_recovery_update_relay_log        OFF
 
139
innodb_replication_delay        0
 
140
innodb_rollback_on_timeout      OFF
 
141
innodb_rollback_segments        128
 
142
innodb_show_locks_held  10
 
143
innodb_show_verbose_locks       0
 
144
innodb_spin_wait_delay  6
 
145
innodb_stats_auto_update        1
 
146
innodb_stats_method     nulls_equal
 
147
innodb_stats_on_metadata        ON
 
148
innodb_stats_sample_pages       8
 
149
innodb_stats_update_need_lock   1
 
150
innodb_strict_mode      OFF
 
151
innodb_support_xa       ON
 
152
innodb_sync_spin_loops  30
 
153
innodb_table_locks      ON
 
154
innodb_thread_concurrency       0
 
155
innodb_thread_concurrency_timer_based   OFF
 
156
innodb_thread_sleep_delay       10000
 
157
innodb_use_global_flush_log_at_trx_commit       ON
 
158
innodb_use_native_aio   ON
 
159
innodb_use_sys_malloc   ON
 
160
innodb_use_sys_stats_table      OFF
 
161
innodb_version  1.1.8-rel25.3
 
162
innodb_write_io_threads 4
 
163
interactive_timeout     28800
 
164
join_buffer_size        131072
 
165
keep_files_on_create    OFF
 
166
key_buffer_size 16777216
 
167
key_cache_age_threshold 300
 
168
key_cache_block_size    1024
 
169
key_cache_division_limit        100
 
170
large_files_support     ON
 
171
large_page_size 0
 
172
large_pages     OFF
 
173
lc_messages     en_US
 
174
lc_messages_dir /home/hugmeir/mysql/Percona-Server-5.5.23-rel25.3-240.Linux.x86_64/share/
 
175
lc_time_names   en_US
 
176
license GPL
 
177
local_infile    ON
 
178
lock_wait_timeout       31536000
 
179
locked_in_memory        OFF
 
180
log     ON
 
181
log_bin ON
 
182
log_bin_trust_function_creators OFF
 
183
log_error       /tmp/12345/data/mysqld.log
 
184
log_output      FILE
 
185
log_queries_not_using_indexes   OFF
 
186
log_slave_updates       ON
 
187
log_slow_admin_statements       OFF
 
188
log_slow_filter 
 
189
log_slow_queries        OFF
 
190
log_slow_rate_limit     1
 
191
log_slow_rate_type      session
 
192
log_slow_slave_statements       OFF
 
193
log_slow_sp_statements  ON
 
194
log_slow_verbosity      
 
195
log_warnings    1
 
196
log_warnings_suppress   
 
197
long_query_time 10.000000
 
198
low_priority_updates    OFF
 
199
lower_case_file_system  OFF
 
200
lower_case_table_names  0
 
201
max_allowed_packet      1048576
 
202
max_binlog_cache_size   18446744073709547520
 
203
max_binlog_size 1073741824
 
204
max_binlog_stmt_cache_size      18446744073709547520
 
205
max_connect_errors      10
 
206
max_connections 151
 
207
max_delayed_threads     20
 
208
max_error_count 64
 
209
max_heap_table_size     16777216
 
210
max_insert_delayed_threads      20
 
211
max_join_size   18446744073709551615
 
212
max_length_for_sort_data        1024
 
213
max_long_data_size      1048576
 
214
max_prepared_stmt_count 16382
 
215
max_relay_log_size      0
 
216
max_seeks_for_key       18446744073709551615
 
217
max_sort_length 1024
 
218
max_sp_recursion_depth  0
 
219
max_tmp_tables  32
 
220
max_user_connections    0
 
221
max_write_lock_count    18446744073709551615
 
222
metadata_locks_cache_size       1024
 
223
min_examined_row_limit  0
 
224
multi_range_count       256
 
225
myisam_data_pointer_size        6
 
226
myisam_max_sort_file_size       9223372036853727232
 
227
myisam_mmap_size        18446744073709551615
 
228
myisam_recover_options  OFF
 
229
myisam_repair_threads   1
 
230
myisam_sort_buffer_size 8388608
 
231
myisam_stats_method     nulls_unequal
 
232
myisam_use_mmap OFF
 
233
net_buffer_length       16384
 
234
net_read_timeout        30
 
235
net_retry_count 10
 
236
net_write_timeout       60
 
237
new     OFF
 
238
old     OFF
 
239
old_alter_table OFF
 
240
old_passwords   OFF
 
241
open_files_limit        1024
 
242
optimizer_fix   ON
 
243
optimizer_prune_level   1
 
244
optimizer_search_depth  62
 
245
optimizer_switch        index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
 
246
performance_schema      OFF
 
247
performance_schema_events_waits_history_long_size       10000
 
248
performance_schema_events_waits_history_size    10
 
249
performance_schema_max_cond_classes     80
 
250
performance_schema_max_cond_instances   1000
 
251
performance_schema_max_file_classes     50
 
252
performance_schema_max_file_handles     32768
 
253
performance_schema_max_file_instances   10000
 
254
performance_schema_max_mutex_classes    200
 
255
performance_schema_max_mutex_instances  1000000
 
256
performance_schema_max_rwlock_classes   30
 
257
performance_schema_max_rwlock_instances 1000000
 
258
performance_schema_max_table_handles    100000
 
259
performance_schema_max_table_instances  50000
 
260
performance_schema_max_thread_classes   50
 
261
performance_schema_max_thread_instances 1000
 
262
pid_file        /tmp/12345/data/mysql_sandbox12345.pid
 
263
plugin_dir      /home/hugmeir/mysql/Percona-Server-5.5.23-rel25.3-240.Linux.x86_64/lib/plugin/
 
264
port    12345
 
265
preload_buffer_size     32768
 
266
profiling       OFF
 
267
profiling_history_size  15
 
268
protocol_version        10
 
269
query_alloc_block_size  8192
 
270
query_cache_limit       1048576
 
271
query_cache_min_res_unit        4096
 
272
query_cache_size        0
 
273
query_cache_strip_comments      OFF
 
274
query_cache_type        ON
 
275
query_cache_wlock_invalidate    OFF
 
276
query_prealloc_size     8192
 
277
query_response_time_range_base  10
 
278
query_response_time_stats       OFF
 
279
range_alloc_block_size  4096
 
280
read_buffer_size        131072
 
281
read_only       OFF
 
282
read_rnd_buffer_size    262144
 
283
relay_log       mysql-relay-bin
 
284
relay_log_index 
 
285
relay_log_info_file     relay-log.info
 
286
relay_log_purge ON
 
287
relay_log_recovery      OFF
 
288
relay_log_space_limit   0
 
289
report_host     127.0.0.1
 
290
report_password 
 
291
report_port     12345
 
292
report_user     
 
293
rpl_recovery_rank       0
 
294
secure_auth     OFF
 
295
secure_file_priv        
 
296
server_id       12345
 
297
skip_external_locking   ON
 
298
skip_name_resolve       OFF
 
299
skip_networking OFF
 
300
skip_show_database      OFF
 
301
slave_compressed_protocol       OFF
 
302
slave_exec_mode STRICT
 
303
slave_load_tmpdir       /tmp
 
304
slave_net_timeout       3600
 
305
slave_skip_errors       OFF
 
306
slave_transaction_retries       10
 
307
slave_type_conversions  
 
308
slow_launch_time        2
 
309
slow_query_log  OFF
 
310
slow_query_log_file     /tmp/12345/data/naw-slow.log
 
311
slow_query_log_timestamp_always OFF
 
312
slow_query_log_timestamp_precision      second
 
313
slow_query_log_use_global_control       
 
314
socket  /tmp/12345/mysql_sandbox12345.sock
 
315
sort_buffer_size        2097152
 
316
sql_auto_is_null        OFF
 
317
sql_big_selects ON
 
318
sql_big_tables  OFF
 
319
sql_buffer_result       OFF
 
320
sql_log_bin     ON
 
321
sql_log_off     OFF
 
322
sql_low_priority_updates        OFF
 
323
sql_max_join_size       18446744073709551615
 
324
sql_mode        
 
325
sql_notes       ON
 
326
sql_quote_show_create   ON
 
327
sql_safe_updates        OFF
 
328
sql_select_limit        18446744073709551615
 
329
sql_slave_skip_counter  0
 
330
sql_warnings    OFF
 
331
ssl_ca  
 
332
ssl_capath      
 
333
ssl_cert        
 
334
ssl_cipher      
 
335
ssl_key 
 
336
storage_engine  InnoDB
 
337
stored_program_cache    256
 
338
sync_binlog     0
 
339
sync_frm        ON
 
340
sync_master_info        0
 
341
sync_relay_log  0
 
342
sync_relay_log_info     0
 
343
system_time_zone        ART
 
344
table_definition_cache  400
 
345
table_open_cache        400
 
346
thread_cache_size       0
 
347
thread_concurrency      10
 
348
thread_handling one-thread-per-connection
 
349
thread_stack    262144
 
350
thread_statistics       OFF
 
351
time_format     %H:%i:%s
 
352
time_zone       SYSTEM
 
353
timed_mutexes   OFF
 
354
tmp_table_size  16777216
 
355
tmpdir  /tmp
 
356
transaction_alloc_block_size    8192
 
357
transaction_prealloc_size       4096
 
358
tx_isolation    REPEATABLE-READ
 
359
unique_checks   ON
 
360
updatable_views_with_limit      YES
 
361
userstat        OFF
 
362
version 5.5.23-rel25.3-log
 
363
version_comment Percona Server with XtraDB (GPL), Release rel25.3, Revision 240
 
364
version_compile_machine x86_64
 
365
version_compile_os      Linux
 
366
wait_timeout    28800
 
367
internal::nice_of_19928    0
 
368
internal::oom_of_19928    0
 
369
internal::nice_of_19856    0
 
370
internal::oom_of_19856    0
 
371
internal::nice_of_19787    0
 
372
internal::oom_of_19787    0
 
373
pt-summary-internal-pid_file_exists    1
 
374
pt-summary-internal-current_time    2012-11-01 23:13
 
375
pt-summary-internal-Config_File_path    
 
376
pt-summary-internal-mysql_executable    /usr/bin/mysql
 
377
pt-summary-internal-now    2012-11-02 00:12:09
 
378
pt-summary-internal-user   msandbox@%
 
379
pt-summary-internal-FNV_64   Unknown
 
380
pt-summary-internal-trigger_count   6