1auto_increment_increment 3 2auto_increment_offset 1 3autocommit ON 4automatic_sp_privileges ON 5back_log 50 6basedir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686 7big_tables OFF 8binlog_cache_size 32768 9binlog_direct_non_transactional_updates OFF 10binlog_format ROW 11binlog_stmt_cache_size 32768 12bulk_insert_buffer_size 8388608 13character_set_client latin1 14character_set_connection latin1 15character_set_database latin1 16character_set_filesystem binary 17character_set_results latin1 18character_set_server latin1 19character_set_system utf8 20character_sets_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/share/charsets/ 21collation_connection latin1_swedish_ci 22collation_database latin1_swedish_ci 23collation_server latin1_swedish_ci 24completion_type NO_CHAIN 25concurrent_insert AUTO 26connect_timeout 10 27datadir /tmp/12345/data/ 28date_format %Y-%m-%d 29datetime_format %Y-%m-%d %H:%i:%s 30default_storage_engine InnoDB 31default_week_format 0 32delay_key_write ON 33delayed_insert_limit 100 34delayed_insert_timeout 300 35delayed_queue_size 1000 36div_precision_increment 4 37enforce_storage_engine 38engine_condition_pushdown ON 39event_scheduler OFF 40expand_fast_index_creation OFF 41expire_logs_days 0 42fast_index_creation ON 43flush OFF 44flush_time 0 45foreign_key_checks ON 46ft_boolean_syntax + -><()~*:""&| 47ft_max_word_len 84 48ft_min_word_len 4 49ft_query_expansion_limit 20 50ft_stopword_file (built-in) 51general_log ON 52general_log_file genlog 53group_concat_max_len 1024 54have_compress YES 55have_crypt YES 56have_csv YES 57have_dynamic_loading YES 58have_flashcache YES 59have_geometry YES 60have_innodb YES 61have_ndbcluster NO 62have_openssl DISABLED 63have_partitioning YES 64have_profiling YES 65have_query_cache YES 66have_response_time_distribution YES 67have_rtree_keys YES 68have_ssl DISABLED 69have_symlink YES 70hostname hugmeir 71ignore_builtin_innodb OFF 72init_connect 73init_file 74init_slave 75innodb_adaptive_flushing ON 76innodb_adaptive_flushing_method estimate 77innodb_adaptive_hash_index ON 78innodb_adaptive_hash_index_partitions 1 79innodb_additional_mem_pool_size 8388608 80innodb_autoextend_increment 8 81innodb_autoinc_lock_mode 2 82innodb_blocking_buffer_pool_restore OFF 83innodb_buffer_pool_instances 1 84innodb_buffer_pool_populate OFF 85innodb_buffer_pool_restore_at_startup 0 86innodb_buffer_pool_shm_checksum ON 87innodb_buffer_pool_shm_key 0 88innodb_buffer_pool_size 33554432 89innodb_change_buffering all 90innodb_changed_pages_limit 1000000 91innodb_checkpoint_age_target 0 92innodb_checksums ON 93innodb_commit_concurrency 0 94innodb_concurrency_tickets 500 95innodb_corrupt_table_action assert 96innodb_data_file_path ibdata1:10M:autoextend 97innodb_data_home_dir /tmp/12345/data 98innodb_dict_size_limit 0 99innodb_disallow_writes OFF 100innodb_doublewrite ON 101innodb_doublewrite_file 102innodb_fake_changes OFF 103innodb_fast_checksum OFF 104innodb_fast_shutdown 1 105innodb_file_format Antelope 106innodb_file_format_check ON 107innodb_file_format_max Antelope 108innodb_file_per_table OFF 109innodb_flush_log_at_trx_commit 1 110innodb_flush_method 111innodb_flush_neighbor_pages area 112innodb_force_load_corrupted OFF 113innodb_force_recovery 0 114innodb_ibuf_accel_rate 100 115innodb_ibuf_active_contract 1 116innodb_ibuf_max_size 16760832 117innodb_import_table_from_xtrabackup 0 118innodb_io_capacity 200 119innodb_kill_idle_transaction 0 120innodb_large_prefix OFF 121innodb_lazy_drop_table 0 122innodb_lock_wait_timeout 3 123innodb_locks_unsafe_for_binlog ON 124innodb_log_block_size 512 125innodb_log_buffer_size 8388608 126innodb_log_file_size 5242880 127innodb_log_files_in_group 2 128innodb_log_group_home_dir /tmp/12345/data 129innodb_max_dirty_pages_pct 75 130innodb_max_purge_lag 0 131innodb_merge_sort_block_size 1048576 132innodb_mirrored_log_groups 1 133innodb_old_blocks_pct 37 134innodb_old_blocks_time 0 135innodb_open_files 300 136innodb_page_size 16384 137innodb_purge_batch_size 20 138innodb_purge_threads 1 139innodb_random_read_ahead OFF 140innodb_read_ahead linear 141innodb_read_ahead_threshold 56 142innodb_read_io_threads 4 143innodb_recovery_stats OFF 144innodb_recovery_update_relay_log OFF 145innodb_replication_delay 0 146innodb_rollback_on_timeout OFF 147innodb_rollback_segments 128 148innodb_show_locks_held 10 149innodb_show_verbose_locks 0 150innodb_spin_wait_delay 6 151innodb_stats_auto_update 1 152innodb_stats_method nulls_equal 153innodb_stats_on_metadata ON 154innodb_stats_sample_pages 8 155innodb_stats_update_need_lock 1 156innodb_strict_mode OFF 157innodb_support_xa ON 158innodb_sync_spin_loops 30 159innodb_table_locks ON 160innodb_thread_concurrency 0 161innodb_thread_concurrency_timer_based OFF 162innodb_thread_sleep_delay 10000 163innodb_track_changed_pages OFF 164innodb_use_global_flush_log_at_trx_commit ON 165innodb_use_native_aio ON 166innodb_use_sys_malloc ON 167innodb_use_sys_stats_table OFF 168innodb_version 1.1.8-rel29.1 169innodb_write_io_threads 4 170interactive_timeout 28800 171join_buffer_size 131072 172keep_files_on_create OFF 173key_buffer_size 16777216 174key_cache_age_threshold 300 175key_cache_block_size 1024 176key_cache_division_limit 100 177large_files_support ON 178large_page_size 0 179large_pages OFF 180lc_messages en_US 181lc_messages_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/share/ 182lc_time_names en_US 183license GPL 184local_infile ON 185lock_wait_timeout 31536000 186locked_in_memory OFF 187log ON 188log_bin ON 189log_bin_trust_function_creators OFF 190log_error /tmp/12345/data/mysqld.log 191log_output FILE 192log_queries_not_using_indexes OFF 193log_slave_updates ON 194log_slow_admin_statements OFF 195log_slow_filter 196log_slow_queries OFF 197log_slow_rate_limit 1 198log_slow_rate_type session 199log_slow_slave_statements OFF 200log_slow_sp_statements ON 201log_slow_verbosity 202log_warnings 1 203log_warnings_suppress 204long_query_time 10.000000 205low_priority_updates OFF 206lower_case_file_system OFF 207lower_case_table_names 0 208max_allowed_packet 1048576 209max_binlog_cache_size 18446744073709547520 210max_binlog_files 0 211max_binlog_size 1073741824 212max_binlog_stmt_cache_size 18446744073709547520 213max_connect_errors 10 214max_connections 151 215max_delayed_threads 20 216max_error_count 64 217max_heap_table_size 16777216 218max_insert_delayed_threads 20 219max_join_size 18446744073709551615 220max_length_for_sort_data 1024 221max_long_data_size 1048576 222max_prepared_stmt_count 16382 223max_relay_log_size 0 224max_seeks_for_key 4294967295 225max_sort_length 1024 226max_sp_recursion_depth 0 227max_tmp_tables 32 228max_user_connections 0 229max_write_lock_count 4294967295 230metadata_locks_cache_size 1024 231min_examined_row_limit 0 232multi_range_count 256 233myisam_data_pointer_size 6 234myisam_max_sort_file_size 2146435072 235myisam_mmap_size 4294967295 236myisam_recover_options OFF 237myisam_repair_threads 1 238myisam_sort_buffer_size 8388608 239myisam_stats_method nulls_unequal 240myisam_use_mmap OFF 241net_buffer_length 16384 242net_read_timeout 30 243net_retry_count 10 244net_write_timeout 60 245new OFF 246old OFF 247old_alter_table OFF 248old_passwords OFF 249open_files_limit 1024 250optimizer_fix ON 251optimizer_prune_level 1 252optimizer_search_depth 62 253optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on 254performance_schema OFF 255performance_schema_events_waits_history_long_size 10000 256performance_schema_events_waits_history_size 10 257performance_schema_max_cond_classes 80 258performance_schema_max_cond_instances 1000 259performance_schema_max_file_classes 50 260performance_schema_max_file_handles 32768 261performance_schema_max_file_instances 10000 262performance_schema_max_mutex_classes 200 263performance_schema_max_mutex_instances 1000000 264performance_schema_max_rwlock_classes 30 265performance_schema_max_rwlock_instances 1000000 266performance_schema_max_table_handles 100000 267performance_schema_max_table_instances 50000 268performance_schema_max_thread_classes 50 269performance_schema_max_thread_instances 1000 270pid_file /tmp/12345/data/mysql_sandbox12345.pid 271plugin_dir /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/lib/mysql/plugin/ 272port 12345 273preload_buffer_size 32768 274profiling OFF 275profiling_history_size 15 276protocol_version 10 277query_alloc_block_size 8192 278query_cache_limit 1048576 279query_cache_min_res_unit 4096 280query_cache_size 0 281query_cache_strip_comments OFF 282query_cache_type ON 283query_cache_wlock_invalidate OFF 284query_prealloc_size 8192 285query_response_time_range_base 10 286query_response_time_stats OFF 287range_alloc_block_size 4096 288read_buffer_size 131072 289read_only OFF 290read_rnd_buffer_size 262144 291relay_log mysql-relay-bin 292relay_log_index 293relay_log_info_file relay-log.info 294relay_log_purge ON 295relay_log_recovery OFF 296relay_log_space_limit 0 297report_host 127.0.0.1 298report_password 299report_port 12345 300report_user 301rpl_recovery_rank 0 302secure_auth OFF 303secure_file_priv 304server_id 12345 305skip_external_locking ON 306skip_name_resolve OFF 307skip_networking OFF 308skip_show_database OFF 309slave_compressed_protocol OFF 310slave_exec_mode STRICT 311slave_load_tmpdir /tmp 312slave_max_allowed_packet 1073741824 313slave_net_timeout 3600 314slave_skip_errors OFF 315slave_transaction_retries 10 316slave_type_conversions 317slow_launch_time 2 318slow_query_log OFF 319slow_query_log_file /tmp/12345/data/hugmeir-slow.log 320slow_query_log_timestamp_always OFF 321slow_query_log_timestamp_precision second 322slow_query_log_use_global_control 323socket /tmp/12345/mysql_sandbox12345.sock 324sort_buffer_size 2097152 325sql_auto_is_null OFF 326sql_big_selects ON 327sql_big_tables OFF 328sql_buffer_result OFF 329sql_log_bin ON 330sql_log_off OFF 331sql_low_priority_updates OFF 332sql_max_join_size 18446744073709551615 333sql_mode 334sql_notes ON 335sql_quote_show_create ON 336sql_safe_updates OFF 337sql_select_limit 18446744073709551615 338sql_slave_skip_counter 0 339sql_warnings OFF 340ssl_ca 341ssl_capath 342ssl_cert 343ssl_cipher 344ssl_key 345storage_engine InnoDB 346stored_program_cache 256 347sync_binlog 0 348sync_frm ON 349sync_master_info 0 350sync_relay_log 0 351sync_relay_log_info 0 352system_time_zone ART 353table_definition_cache 400 354table_open_cache 400 355thread_cache_size 0 356thread_concurrency 10 357thread_handling one-thread-per-connection 358thread_stack 196608 359thread_statistics OFF 360time_format %H:%i:%s 361time_zone SYSTEM 362timed_mutexes OFF 363tmp_table_size 16777216 364tmpdir /tmp 365transaction_alloc_block_size 8192 366transaction_prealloc_size 4096 367tx_isolation REPEATABLE-READ 368unique_checks ON 369updatable_views_with_limit YES 370userstat OFF 371version 5.5.28-23.7-log 372version_comment Percona XtraDB Cluster (GPL) 5.5.28-23.7, Revision 373, wsrep_23.7.r3821 373version_compile_machine i686 374version_compile_os Linux 375wait_timeout 28800 376wsrep_OSU_method TOI 377wsrep_auto_increment_control ON 378wsrep_causal_reads OFF 379wsrep_certify_nonPK ON 380wsrep_cluster_address gcomm:// 381wsrep_cluster_name pt_sandbox_cluster 382wsrep_convert_LOCK_to_trx OFF 383wsrep_data_home_dir /tmp/12345/data/ 384wsrep_dbug_option 385wsrep_debug OFF 386wsrep_drupal_282555_workaround OFF 387wsrep_forced_binlog_format NONE 388wsrep_log_conflicts OFF 389wsrep_max_ws_rows 131072 390wsrep_max_ws_size 1073741824 391wsrep_mysql_replication_bundle 0 392wsrep_node_address 393wsrep_node_incoming_address 192.168.0.100 394wsrep_node_name 12345 395wsrep_notify_cmd 396wsrep_on ON 397wsrep_provider /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-XtraDB-Cluster-5.5.28-23.7.373.Linux.i686/lib/libgalera_smm.so 398wsrep_provider_options base_host = 192.168.122.1; base_port = 12355; cert.log_conflicts = no; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = PT5M; gcache.dir = /tmp/12345/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /tmp/12345/data//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 2147483647; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://192.168.0.100:12355; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 192.168.122.1; pc.checksum = true; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT2S; pc.npvo = false; pc.version = 0; protonet.backend = asio; protonet.version = 0; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3 399wsrep_recover OFF 400wsrep_replicate_myisam ON 401wsrep_retry_autocommit 1 402wsrep_slave_threads 2 403wsrep_sst_auth 404wsrep_sst_donor 405wsrep_sst_donor_rejects_queries OFF 406wsrep_sst_method rsync 407wsrep_sst_receive_address 192.168.0.100:12365 408wsrep_start_position 00000000-0000-0000-0000-000000000000:-1 409internal::nice_of_32578 0 410internal::oom_of_32578 0 411internal::nice_of_32419 0 412internal::oom_of_32419 0 413internal::nice_of_32324 0 414internal::oom_of_32324 0 415pt-summary-internal-pid_file_exists 1 416pt-summary-internal-current_time 2012-11-27 16:56 417pt-summary-internal-Config_File_path 418pt-summary-internal-mysql_executable /usr/bin/mysql 419pt-summary-internal-now 2012-11-27 17:38:42 420pt-summary-internal-user msandbox@% 421pt-summary-internal-FNV_64 Unknown 422pt-summary-internal-trigger_count 6 423