innodb_support_xa;ON
innodb_sync_array_size;1
innodb_sync_spin_loops;30
innodb_table_locks;ON
innodb_thread_concurrency;0
innodb_thread_sleep_delay;10000
innodb_track_changed_pages;OFF
innodb_undo_directory;.
innodb_undo_logs;128
innodb_undo_tablespaces;0
innodb_use_atomic_writes;OFF
innodb_use_global_flush_log_at_trx_commit;ON
innodb_use_native_aio;ON
innodb_use_sys_malloc;ON
innodb_version;5.6.24-72.2
innodb_write_io_threads;4
interactive_timeout;28800
join_buffer_size;262144
keep_files_on_create;OFF
key_buffer_size;8388608
key_cache_age_threshold;300
key_cache_block_size;1024
key_cache_division_limit;100
large_files_support;ON
large_page_size;0
large_pages;OFF
lc_messages;en_US
lc_messages_dir;/usr/share/percona-xtradb-cluster/
lc_time_names;en_US
license;GPL
local_infile;ON
lock_wait_timeout;31536000
locked_in_memory;OFF
log_bin;ON
log_bin_basename;/var/lib/mysql/database01
log_bin_index;/var/lib/mysql/database01.index
log_bin_trust_function_creators;OFF
log_bin_use_v1_row_events;OFF
log_error;/var/log/mysqld.log
log_output;FILE
log_queries_not_using_indexes;OFF
log_slave_updates;ON
log_slow_admin_statements;OFF
log_slow_filter;
log_slow_rate_limit;1
log_slow_rate_type;session
log_slow_slave_statements;OFF
log_slow_sp_statements;ON
log_slow_verbosity;
log_throttle_queries_not_using_indexes;0
log_warnings;2
log_warnings_suppress;
long_query_time;5.000000
low_priority_updates;OFF
lower_case_file_system;OFF
lower_case_table_names;1
master_info_repository;FILE
master_verify_checksum;OFF
max_allowed_packet;4194304
max_binlog_cache_size;18446744073709547520
max_binlog_files;0
max_binlog_size;52428800
max_binlog_stmt_cache_size;18446744073709547520
max_connect_errors;100
max_connections;150
max_delayed_threads;20
max_digest_length;1024
max_error_count;64
max_heap_table_size;16777216
max_insert_delayed_threads;20
max_join_size;18446744073709551615
max_length_for_sort_data;1024
max_prepared_stmt_count;16382
max_relay_log_size;0
max_seeks_for_key;18446744073709551615
max_slowlog_files;0
max_slowlog_size;0
max_sort_length;1024
max_sp_recursion_depth;0
max_statement_time;0
max_tmp_tables;32
max_user_connections;0
max_write_lock_count;18446744073709551615
metadata_locks_cache_size;1024
metadata_locks_hash_instances;8
min_examined_row_limit;0
multi_range_count;256
myisam_data_pointer_size;6
myisam_max_sort_file_size;9223372036853727232
myisam_mmap_size;18446744073709551615
myisam_recover_options;OFF
myisam_repair_threads;1
myisam_sort_buffer_size;8388608
myisam_stats_method;ulls_unequal
myisam_use_mmap;OFF
net_buffer_length;16384
net_read_timeout;30
net_retry_count;10
net_write_timeout;60
new;OFF
old;OFF
old_alter_table;OFF
old_passwords;0
open_files_limit;5000
optimizer_prune_level;1
optimizer_search_depth;62
optimizer_switch;index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
optimizer_trace;enabled=off,one_line=off
optimizer_trace_features;greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
optimizer_trace_limit;1
optimizer_trace_max_mem_size;16384
optimizer_trace_offset;-1
performance_schema;ON
performance_schema_accounts_size;100
performance_schema_digests_size;10000
performance_schema_events_stages_history_long_size;10000
performance_schema_events_stages_history_size;10
performance_schema_events_statements_history_long_size;10000
performance_schema_events_statements_history_size;10
performance_schema_events_waits_history_long_size;10000
performance_schema_events_waits_history_size;10
performance_schema_hosts_size;100
performance_schema_max_cond_classes;80
performance_schema_max_cond_instances;3500
performance_schema_max_file_classes;50
performance_schema_max_file_handles;32768
performance_schema_max_file_instances;7693
performance_schema_max_mutex_classes;200
performance_schema_max_mutex_instances;16200
performance_schema_max_rwlock_classes;40
performance_schema_max_rwlock_instances;9100
performance_schema_max_socket_classes;10
performance_schema_max_socket_instances;320
performance_schema_max_stage_classes;150
performance_schema_max_statement_classes;179
performance_schema_max_table_handles;4000
performance_schema_max_table_instances;12500
performance_schema_max_thread_classes;50
performance_schema_max_thread_instances;400
performance_schema_session_connect_attrs_size;512
performance_schema_setup_actors_size;100
performance_schema_setup_objects_size;100
performance_schema_users_size;100
pid_file;/var/lib/mysql/database01.pid
plugin_dir;/usr/lib64/mysql/plugin/
port;3306
preload_buffer_size;32768
profiling;OFF
profiling_history_size;15
protocol_version;10
query_alloc_block_size;8192
query_cache_limit;1048576
query_cache_min_res_unit;4096
query_cache_size;1048576
query_cache_strip_comments;OFF
query_cache_type;OFF
query_cache_wlock_invalidate;OFF
query_prealloc_size;8192
range_alloc_block_size;4096
read_buffer_size;131072
read_only;OFF
read_rnd_buffer_size;262144
relay_log;
relay_log_basename;
relay_log_index;
relay_log_info_file;relay-log.info
relay_log_info_repository;FILE
relay_log_purge;ON
relay_log_recovery;OFF
relay_log_space_limit;0
report_host;
report_password;
report_port;3306
report_user;
rpl_stop_slave_timeout;31536000
secure_auth;ON
secure_file_priv;
server_id;1
server_id_bits;32
server_uuid;eb55dadf-db4d-11e5-ae62-0011259dcb16
sha256_password_private_key_path;private_key.pem
sha256_password_public_key_path;public_key.pem
show_old_temporals;OFF
simplified_binlog_gtid_recovery;OFF
skip_external_locking;ON
skip_name_resolve;ON
skip_networking;OFF
skip_show_database;OFF
slave_allow_batching;OFF
slave_checkpoint_group;512
slave_checkpoint_period;300
slave_compressed_protocol;OFF
slave_exec_mode;STRICT
slave_load_tmpdir;/tmp
slave_max_allowed_packet;1073741824
slave_net_timeout;3600
slave_parallel_workers;0
slave_pending_jobs_size_max;16777216
slave_rows_search_algorithms;TABLE_SCAN,INDEX_SCAN
slave_skip_errors;OFF
slave_sql_verify_checksum;ON
slave_transaction_retries;10
slave_type_conversions;
slow_launch_time;2
slow_query_log;ON
slow_query_log_always_write_time;10.000000
slow_query_log_file;/var/log/slow.log
slow_query_log_timestamp_always;OFF
slow_query_log_timestamp_precision;second
slow_query_log_use_global_control;
socket;/var/lib/mysql/mysql.sock
sort_buffer_size;262144
sql_auto_is_null;OFF
sql_big_selects;ON
sql_buffer_result;OFF
sql_log_bin;ON
sql_log_off;OFF
sql_mode;NO_ENGINE_SUBSTITUTION
sql_notes;ON
sql_quote_show_create;ON
sql_safe_updates;OFF
sql_select_limit;18446744073709551615
sql_slave_skip_counter;0
sql_warnings;OFF
ssl_ca;
ssl_capath;
ssl_cert;
ssl_cipher;
ssl_crl;
ssl_crlpath;
ssl_key;
storage_engine;InnoDB
stored_program_cache;256
super_read_only;OFF
sync_binlog;0
sync_frm;ON
sync_master_info;10000
sync_relay_log;10000
sync_relay_log_info;10000
system_time_zone;GMT
table_definition_cache;1400