| 1 | Variable_name Value
|
|---|
| 2 | auto_increment_increment 1
|
|---|
| 3 | auto_increment_offset 1
|
|---|
| 4 | autocommit ON
|
|---|
| 5 | automatic_sp_privileges ON
|
|---|
| 6 | avoid_temporal_upgrade OFF
|
|---|
| 7 | back_log 80
|
|---|
| 8 | basedir /usr/local/Cellar/mysql/5.6.24
|
|---|
| 9 | big_tables OFF
|
|---|
| 10 | bind_address *
|
|---|
| 11 | binlog_cache_size 32768
|
|---|
| 12 | binlog_checksum CRC32
|
|---|
| 13 | binlog_direct_non_transactional_updates OFF
|
|---|
| 14 | binlog_error_action IGNORE_ERROR
|
|---|
| 15 | binlog_format STATEMENT
|
|---|
| 16 | binlog_gtid_simple_recovery OFF
|
|---|
| 17 | binlog_max_flush_queue_time 0
|
|---|
| 18 | binlog_order_commits ON
|
|---|
| 19 | binlog_row_image FULL
|
|---|
| 20 | binlog_rows_query_log_events OFF
|
|---|
| 21 | binlog_stmt_cache_size 32768
|
|---|
| 22 | binlogging_impossible_mode IGNORE_ERROR
|
|---|
| 23 | block_encryption_mode aes-128-ecb
|
|---|
| 24 | bulk_insert_buffer_size 8388608
|
|---|
| 25 | character_set_client utf8
|
|---|
| 26 | character_set_connection utf8
|
|---|
| 27 | character_set_database utf8
|
|---|
| 28 | character_set_filesystem binary
|
|---|
| 29 | character_set_results utf8
|
|---|
| 30 | character_set_server utf8
|
|---|
| 31 | character_set_system utf8
|
|---|
| 32 | character_sets_dir /usr/local/Cellar/mysql/5.6.24/share/mysql/charsets/
|
|---|
| 33 | collation_connection utf8_general_ci
|
|---|
| 34 | collation_database utf8_general_ci
|
|---|
| 35 | collation_server utf8_general_ci
|
|---|
| 36 | completion_type NO_CHAIN
|
|---|
| 37 | concurrent_insert AUTO
|
|---|
| 38 | connect_timeout 10
|
|---|
| 39 | core_file OFF
|
|---|
| 40 | datadir /usr/local/var/mysql/
|
|---|
| 41 | date_format %Y-%m-%d
|
|---|
| 42 | datetime_format %Y-%m-%d %H:%i:%s
|
|---|
| 43 | default_storage_engine InnoDB
|
|---|
| 44 | default_tmp_storage_engine InnoDB
|
|---|
| 45 | default_week_format 0
|
|---|
| 46 | delay_key_write ON
|
|---|
| 47 | delayed_insert_limit 100
|
|---|
| 48 | delayed_insert_timeout 300
|
|---|
| 49 | delayed_queue_size 1000
|
|---|
| 50 | disconnect_on_expired_password ON
|
|---|
| 51 | div_precision_increment 4
|
|---|
| 52 | end_markers_in_json OFF
|
|---|
| 53 | enforce_gtid_consistency OFF
|
|---|
| 54 | eq_range_index_dive_limit 10
|
|---|
| 55 | error_count 0
|
|---|
| 56 | event_scheduler OFF
|
|---|
| 57 | expire_logs_days 0
|
|---|
| 58 | explicit_defaults_for_timestamp OFF
|
|---|
| 59 | external_user
|
|---|
| 60 | flush OFF
|
|---|
| 61 | flush_time 0
|
|---|
| 62 | foreign_key_checks ON
|
|---|
| 63 | ft_boolean_syntax + -><()~*:""&|
|
|---|
| 64 | ft_max_word_len 84
|
|---|
| 65 | ft_min_word_len 4
|
|---|
| 66 | ft_query_expansion_limit 20
|
|---|
| 67 | ft_stopword_file (built-in)
|
|---|
| 68 | general_log OFF
|
|---|
| 69 | general_log_file /usr/local/var/mysql/LaszlosMacBookPro.log
|
|---|
| 70 | group_concat_max_len 1024
|
|---|
| 71 | gtid_executed
|
|---|
| 72 | gtid_mode OFF
|
|---|
| 73 | gtid_next AUTOMATIC
|
|---|
| 74 | gtid_owned
|
|---|
| 75 | gtid_purged
|
|---|
| 76 | have_compress YES
|
|---|
| 77 | have_crypt YES
|
|---|
| 78 | have_dynamic_loading YES
|
|---|
| 79 | have_geometry YES
|
|---|
| 80 | have_openssl DISABLED
|
|---|
| 81 | have_profiling YES
|
|---|
| 82 | have_query_cache YES
|
|---|
| 83 | have_rtree_keys YES
|
|---|
| 84 | have_ssl DISABLED
|
|---|
| 85 | have_symlink YES
|
|---|
| 86 | host_cache_size 279
|
|---|
| 87 | hostname LaszlosMacBookPro.fritz.box
|
|---|
| 88 | identity 0
|
|---|
| 89 | ignore_builtin_innodb OFF
|
|---|
| 90 | ignore_db_dirs
|
|---|
| 91 | init_connect
|
|---|
| 92 | init_file
|
|---|
| 93 | init_slave
|
|---|
| 94 | innodb_adaptive_flushing ON
|
|---|
| 95 | innodb_adaptive_flushing_lwm 10
|
|---|
| 96 | innodb_adaptive_hash_index ON
|
|---|
| 97 | innodb_adaptive_max_sleep_delay 150000
|
|---|
| 98 | innodb_additional_mem_pool_size 8388608
|
|---|
| 99 | innodb_api_bk_commit_interval 5
|
|---|
| 100 | innodb_api_disable_rowlock OFF
|
|---|
| 101 | innodb_api_enable_binlog OFF
|
|---|
| 102 | innodb_api_enable_mdl OFF
|
|---|
| 103 | innodb_api_trx_level 0
|
|---|
| 104 | innodb_autoextend_increment 64
|
|---|
| 105 | innodb_autoinc_lock_mode 1
|
|---|
| 106 | innodb_buffer_pool_dump_at_shutdown OFF
|
|---|
| 107 | innodb_buffer_pool_dump_now OFF
|
|---|
| 108 | innodb_buffer_pool_filename ib_buffer_pool
|
|---|
| 109 | innodb_buffer_pool_instances 8
|
|---|
| 110 | innodb_buffer_pool_load_abort OFF
|
|---|
| 111 | innodb_buffer_pool_load_at_startup OFF
|
|---|
| 112 | innodb_buffer_pool_load_now OFF
|
|---|
| 113 | innodb_buffer_pool_size 134217728
|
|---|
| 114 | innodb_change_buffer_max_size 25
|
|---|
| 115 | innodb_change_buffering all
|
|---|
| 116 | innodb_checksum_algorithm innodb
|
|---|
| 117 | innodb_checksums ON
|
|---|
| 118 | innodb_cmp_per_index_enabled OFF
|
|---|
| 119 | innodb_commit_concurrency 0
|
|---|
| 120 | innodb_compression_failure_threshold_pct 5
|
|---|
| 121 | innodb_compression_level 6
|
|---|
| 122 | innodb_compression_pad_pct_max 50
|
|---|
| 123 | innodb_concurrency_tickets 5000
|
|---|
| 124 | innodb_data_file_path ibdata1:12M:autoextend
|
|---|
| 125 | innodb_data_home_dir
|
|---|
| 126 | innodb_disable_sort_file_cache OFF
|
|---|
| 127 | innodb_doublewrite ON
|
|---|
| 128 | innodb_fast_shutdown 1
|
|---|
| 129 | innodb_file_format Antelope
|
|---|
| 130 | innodb_file_format_check ON
|
|---|
| 131 | innodb_file_format_max Antelope
|
|---|
| 132 | innodb_file_per_table ON
|
|---|
| 133 | innodb_flush_log_at_timeout 1
|
|---|
| 134 | innodb_flush_log_at_trx_commit 1
|
|---|
| 135 | innodb_flush_method
|
|---|
| 136 | innodb_flush_neighbors 1
|
|---|
| 137 | innodb_flushing_avg_loops 30
|
|---|
| 138 | innodb_force_load_corrupted OFF
|
|---|
| 139 | innodb_force_recovery 0
|
|---|
| 140 | innodb_ft_aux_table
|
|---|
| 141 | innodb_ft_cache_size 8000000
|
|---|
| 142 | innodb_ft_enable_diag_print OFF
|
|---|
| 143 | innodb_ft_enable_stopword ON
|
|---|
| 144 | innodb_ft_max_token_size 84
|
|---|
| 145 | innodb_ft_min_token_size 3
|
|---|
| 146 | innodb_ft_num_word_optimize 2000
|
|---|
| 147 | innodb_ft_result_cache_limit 2000000000
|
|---|
| 148 | innodb_ft_server_stopword_table
|
|---|
| 149 | innodb_ft_sort_pll_degree 2
|
|---|
| 150 | innodb_ft_total_cache_size 640000000
|
|---|
| 151 | innodb_ft_user_stopword_table
|
|---|
| 152 | innodb_io_capacity 200
|
|---|
| 153 | innodb_io_capacity_max 2000
|
|---|
| 154 | innodb_large_prefix OFF
|
|---|
| 155 | innodb_lock_wait_timeout 50
|
|---|
| 156 | innodb_locks_unsafe_for_binlog OFF
|
|---|
| 157 | innodb_log_buffer_size 8388608
|
|---|
| 158 | innodb_log_compressed_pages ON
|
|---|
| 159 | innodb_log_file_size 50331648
|
|---|
| 160 | innodb_log_files_in_group 2
|
|---|
| 161 | innodb_log_group_home_dir ./
|
|---|
| 162 | innodb_lru_scan_depth 1024
|
|---|
| 163 | innodb_max_dirty_pages_pct 75
|
|---|
| 164 | innodb_max_dirty_pages_pct_lwm 0
|
|---|
| 165 | innodb_max_purge_lag 0
|
|---|
| 166 | innodb_max_purge_lag_delay 0
|
|---|
| 167 | innodb_mirrored_log_groups 1
|
|---|
| 168 | innodb_monitor_disable
|
|---|
| 169 | innodb_monitor_enable
|
|---|
| 170 | innodb_monitor_reset
|
|---|
| 171 | innodb_monitor_reset_all
|
|---|
| 172 | innodb_old_blocks_pct 37
|
|---|
| 173 | innodb_old_blocks_time 1000
|
|---|
| 174 | innodb_online_alter_log_max_size 134217728
|
|---|
| 175 | innodb_open_files 2000
|
|---|
| 176 | innodb_optimize_fulltext_only OFF
|
|---|
| 177 | innodb_page_size 16384
|
|---|
| 178 | innodb_print_all_deadlocks OFF
|
|---|
| 179 | innodb_purge_batch_size 300
|
|---|
| 180 | innodb_purge_threads 1
|
|---|
| 181 | innodb_random_read_ahead OFF
|
|---|
| 182 | innodb_read_ahead_threshold 56
|
|---|
| 183 | innodb_read_io_threads 4
|
|---|
| 184 | innodb_read_only OFF
|
|---|
| 185 | innodb_replication_delay 0
|
|---|
| 186 | innodb_rollback_on_timeout OFF
|
|---|
| 187 | innodb_rollback_segments 128
|
|---|
| 188 | innodb_sort_buffer_size 1048576
|
|---|
| 189 | innodb_spin_wait_delay 6
|
|---|
| 190 | innodb_stats_auto_recalc ON
|
|---|
| 191 | innodb_stats_method nulls_equal
|
|---|
| 192 | innodb_stats_on_metadata OFF
|
|---|
| 193 | innodb_stats_persistent ON
|
|---|
| 194 | innodb_stats_persistent_sample_pages 20
|
|---|
| 195 | innodb_stats_sample_pages 8
|
|---|
| 196 | innodb_stats_transient_sample_pages 8
|
|---|
| 197 | innodb_status_output OFF
|
|---|
| 198 | innodb_status_output_locks OFF
|
|---|
| 199 | innodb_strict_mode OFF
|
|---|
| 200 | innodb_support_xa ON
|
|---|
| 201 | innodb_sync_array_size 1
|
|---|
| 202 | innodb_sync_spin_loops 30
|
|---|
| 203 | innodb_table_locks ON
|
|---|
| 204 | innodb_thread_concurrency 0
|
|---|
| 205 | innodb_thread_sleep_delay 10000
|
|---|
| 206 | innodb_undo_directory .
|
|---|
| 207 | innodb_undo_logs 128
|
|---|
| 208 | innodb_undo_tablespaces 0
|
|---|
| 209 | innodb_use_native_aio OFF
|
|---|
| 210 | innodb_use_sys_malloc ON
|
|---|
| 211 | innodb_version 5.6.24
|
|---|
| 212 | innodb_write_io_threads 4
|
|---|
| 213 | insert_id 0
|
|---|
| 214 | interactive_timeout 28800
|
|---|
| 215 | join_buffer_size 262144
|
|---|
| 216 | keep_files_on_create OFF
|
|---|
| 217 | key_buffer_size 8388608
|
|---|
| 218 | key_cache_age_threshold 300
|
|---|
| 219 | key_cache_block_size 1024
|
|---|
| 220 | key_cache_division_limit 100
|
|---|
| 221 | large_files_support ON
|
|---|
| 222 | large_page_size 0
|
|---|
| 223 | large_pages OFF
|
|---|
| 224 | last_insert_id 0
|
|---|
| 225 | lc_messages en_US
|
|---|
| 226 | lc_messages_dir /usr/local/Cellar/mysql/5.6.24/share/mysql/
|
|---|
| 227 | lc_time_names en_US
|
|---|
| 228 | license GPL
|
|---|
| 229 | local_infile ON
|
|---|
| 230 | lock_wait_timeout 31536000
|
|---|
| 231 | locked_in_memory OFF
|
|---|
| 232 | log_bin OFF
|
|---|
| 233 | log_bin_basename
|
|---|
| 234 | log_bin_index
|
|---|
| 235 | log_bin_trust_function_creators OFF
|
|---|
| 236 | log_bin_use_v1_row_events OFF
|
|---|
| 237 | log_error /usr/local/var/mysql/LaszlosMacBookPro.fritz.box.err
|
|---|
| 238 | log_output FILE
|
|---|
| 239 | log_queries_not_using_indexes OFF
|
|---|
| 240 | log_slave_updates OFF
|
|---|
| 241 | log_slow_admin_statements OFF
|
|---|
| 242 | log_slow_slave_statements OFF
|
|---|
| 243 | log_throttle_queries_not_using_indexes 0
|
|---|
| 244 | log_warnings 1
|
|---|
| 245 | long_query_time 10.000000
|
|---|
| 246 | low_priority_updates OFF
|
|---|
| 247 | lower_case_file_system ON
|
|---|
| 248 | lower_case_table_names 2
|
|---|
| 249 | master_info_repository FILE
|
|---|
| 250 | master_verify_checksum OFF
|
|---|
| 251 | max_allowed_packet 4194304
|
|---|
| 252 | max_binlog_cache_size 18446744073709547520
|
|---|
| 253 | max_binlog_size 1073741824
|
|---|
| 254 | max_binlog_stmt_cache_size 18446744073709547520
|
|---|
| 255 | max_connect_errors 100
|
|---|
| 256 | max_connections 151
|
|---|
| 257 | max_delayed_threads 20
|
|---|
| 258 | max_digest_length 1024
|
|---|
| 259 | max_error_count 64
|
|---|
| 260 | max_heap_table_size 16777216
|
|---|
| 261 | max_insert_delayed_threads 20
|
|---|
| 262 | max_join_size 18446744073709551615
|
|---|
| 263 | max_length_for_sort_data 1024
|
|---|
| 264 | max_prepared_stmt_count 16382
|
|---|
| 265 | max_relay_log_size 0
|
|---|
| 266 | max_seeks_for_key 18446744073709551615
|
|---|
| 267 | max_sort_length 1024
|
|---|
| 268 | max_sp_recursion_depth 0
|
|---|
| 269 | max_tmp_tables 32
|
|---|
| 270 | max_user_connections 0
|
|---|
| 271 | max_write_lock_count 18446744073709551615
|
|---|
| 272 | metadata_locks_cache_size 1024
|
|---|
| 273 | metadata_locks_hash_instances 8
|
|---|
| 274 | min_examined_row_limit 0
|
|---|
| 275 | multi_range_count 256
|
|---|
| 276 | myisam_data_pointer_size 6
|
|---|
| 277 | myisam_max_sort_file_size 9223372036853727232
|
|---|
| 278 | myisam_mmap_size 18446744073709551615
|
|---|
| 279 | myisam_recover_options OFF
|
|---|
| 280 | myisam_repair_threads 1
|
|---|
| 281 | myisam_sort_buffer_size 8388608
|
|---|
| 282 | myisam_stats_method nulls_unequal
|
|---|
| 283 | myisam_use_mmap OFF
|
|---|
| 284 | net_buffer_length 16384
|
|---|
| 285 | net_read_timeout 30
|
|---|
| 286 | net_retry_count 10
|
|---|
| 287 | net_write_timeout 60
|
|---|
| 288 | new OFF
|
|---|
| 289 | old OFF
|
|---|
| 290 | old_alter_table OFF
|
|---|
| 291 | old_passwords 0
|
|---|
| 292 | open_files_limit 5000
|
|---|
| 293 | optimizer_prune_level 1
|
|---|
| 294 | optimizer_search_depth 62
|
|---|
| 295 | 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
|
|---|
| 296 | optimizer_trace enabled=off,one_line=off
|
|---|
| 297 | optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
|
|---|
| 298 | optimizer_trace_limit 1
|
|---|
| 299 | optimizer_trace_max_mem_size 16384
|
|---|
| 300 | optimizer_trace_offset -1
|
|---|
| 301 | performance_schema ON
|
|---|
| 302 | performance_schema_accounts_size 100
|
|---|
| 303 | performance_schema_digests_size 10000
|
|---|
| 304 | performance_schema_events_stages_history_long_size 10000
|
|---|
| 305 | performance_schema_events_stages_history_size 10
|
|---|
| 306 | performance_schema_events_statements_history_long_size 10000
|
|---|
| 307 | performance_schema_events_statements_history_size 10
|
|---|
| 308 | performance_schema_events_waits_history_long_size 10000
|
|---|
| 309 | performance_schema_events_waits_history_size 10
|
|---|
| 310 | performance_schema_hosts_size 100
|
|---|
| 311 | performance_schema_max_cond_classes 80
|
|---|
| 312 | performance_schema_max_cond_instances 3504
|
|---|
| 313 | performance_schema_max_file_classes 50
|
|---|
| 314 | performance_schema_max_file_handles 32768
|
|---|
| 315 | performance_schema_max_file_instances 7693
|
|---|
| 316 | performance_schema_max_mutex_classes 200
|
|---|
| 317 | performance_schema_max_mutex_instances 15906
|
|---|
| 318 | performance_schema_max_rwlock_classes 40
|
|---|
| 319 | performance_schema_max_rwlock_instances 9102
|
|---|
| 320 | performance_schema_max_socket_classes 10
|
|---|
| 321 | performance_schema_max_socket_instances 322
|
|---|
| 322 | performance_schema_max_stage_classes 150
|
|---|
| 323 | performance_schema_max_statement_classes 168
|
|---|
| 324 | performance_schema_max_table_handles 4000
|
|---|
| 325 | performance_schema_max_table_instances 12500
|
|---|
| 326 | performance_schema_max_thread_classes 50
|
|---|
| 327 | performance_schema_max_thread_instances 402
|
|---|
| 328 | performance_schema_session_connect_attrs_size 512
|
|---|
| 329 | performance_schema_setup_actors_size 100
|
|---|
| 330 | performance_schema_setup_objects_size 100
|
|---|
| 331 | performance_schema_users_size 100
|
|---|
| 332 | pid_file /usr/local/var/mysql/LaszlosMacBookPro.fritz.box.pid
|
|---|
| 333 | plugin_dir /usr/local/Cellar/mysql/5.6.24/lib/plugin/
|
|---|
| 334 | port 3306
|
|---|
| 335 | preload_buffer_size 32768
|
|---|
| 336 | profiling OFF
|
|---|
| 337 | profiling_history_size 15
|
|---|
| 338 | protocol_version 10
|
|---|
| 339 | proxy_user
|
|---|
| 340 | pseudo_slave_mode OFF
|
|---|
| 341 | pseudo_thread_id 174
|
|---|
| 342 | query_alloc_block_size 8192
|
|---|
| 343 | query_cache_limit 1048576
|
|---|
| 344 | query_cache_min_res_unit 4096
|
|---|
| 345 | query_cache_size 1048576
|
|---|
| 346 | query_cache_type OFF
|
|---|
| 347 | query_cache_wlock_invalidate OFF
|
|---|
| 348 | query_prealloc_size 8192
|
|---|
| 349 | rand_seed1 0
|
|---|
| 350 | rand_seed2 0
|
|---|
| 351 | range_alloc_block_size 4096
|
|---|
| 352 | read_buffer_size 131072
|
|---|
| 353 | read_only OFF
|
|---|
| 354 | read_rnd_buffer_size 262144
|
|---|
| 355 | relay_log
|
|---|
| 356 | relay_log_basename
|
|---|
| 357 | relay_log_index
|
|---|
| 358 | relay_log_info_file relay-log.info
|
|---|
| 359 | relay_log_info_repository FILE
|
|---|
| 360 | relay_log_purge ON
|
|---|
| 361 | relay_log_recovery OFF
|
|---|
| 362 | relay_log_space_limit 0
|
|---|
| 363 | report_host
|
|---|
| 364 | report_password
|
|---|
| 365 | report_port 3306
|
|---|
| 366 | report_user
|
|---|
| 367 | rpl_stop_slave_timeout 31536000
|
|---|
| 368 | secure_auth ON
|
|---|
| 369 | secure_file_priv
|
|---|
| 370 | server_id 0
|
|---|
| 371 | server_id_bits 32
|
|---|
| 372 | server_uuid 0cde427c-5de5-11e4-ac76-c7cfba34d58f
|
|---|
| 373 | sha256_password_private_key_path private_key.pem
|
|---|
| 374 | sha256_password_public_key_path public_key.pem
|
|---|
| 375 | show_old_temporals OFF
|
|---|
| 376 | simplified_binlog_gtid_recovery OFF
|
|---|
| 377 | skip_external_locking ON
|
|---|
| 378 | skip_name_resolve OFF
|
|---|
| 379 | skip_networking OFF
|
|---|
| 380 | skip_show_database OFF
|
|---|
| 381 | slave_allow_batching OFF
|
|---|
| 382 | slave_checkpoint_group 512
|
|---|
| 383 | slave_checkpoint_period 300
|
|---|
| 384 | slave_compressed_protocol OFF
|
|---|
| 385 | slave_exec_mode STRICT
|
|---|
| 386 | slave_load_tmpdir /var/folders/rb/t5gw7jmd1716d4lc8y5w3gm80000gn/T/
|
|---|
| 387 | slave_max_allowed_packet 1073741824
|
|---|
| 388 | slave_net_timeout 3600
|
|---|
| 389 | slave_parallel_workers 0
|
|---|
| 390 | slave_pending_jobs_size_max 16777216
|
|---|
| 391 | slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN
|
|---|
| 392 | slave_skip_errors OFF
|
|---|
| 393 | slave_sql_verify_checksum ON
|
|---|
| 394 | slave_transaction_retries 10
|
|---|
| 395 | slave_type_conversions
|
|---|
| 396 | slow_launch_time 2
|
|---|
| 397 | slow_query_log OFF
|
|---|
| 398 | slow_query_log_file /usr/local/var/mysql/LaszlosMacBookPro-slow.log
|
|---|
| 399 | socket /tmp/mysql.sock
|
|---|
| 400 | sort_buffer_size 262144
|
|---|
| 401 | sql_auto_is_null OFF
|
|---|
| 402 | sql_big_selects ON
|
|---|
| 403 | sql_buffer_result OFF
|
|---|
| 404 | sql_log_bin ON
|
|---|
| 405 | sql_log_off OFF
|
|---|
| 406 | sql_mode NO_ENGINE_SUBSTITUTION
|
|---|
| 407 | sql_notes ON
|
|---|
| 408 | sql_quote_show_create ON
|
|---|
| 409 | sql_safe_updates OFF
|
|---|
| 410 | sql_select_limit 18446744073709551615
|
|---|
| 411 | sql_slave_skip_counter 0
|
|---|
| 412 | sql_warnings OFF
|
|---|
| 413 | ssl_ca
|
|---|
| 414 | ssl_capath
|
|---|
| 415 | ssl_cert
|
|---|
| 416 | ssl_cipher
|
|---|
| 417 | ssl_crl
|
|---|
| 418 | ssl_crlpath
|
|---|
| 419 | ssl_key
|
|---|
| 420 | storage_engine InnoDB
|
|---|
| 421 | stored_program_cache 256
|
|---|
| 422 | sync_binlog 0
|
|---|
| 423 | sync_frm ON
|
|---|
| 424 | sync_master_info 10000
|
|---|
| 425 | sync_relay_log 10000
|
|---|
| 426 | sync_relay_log_info 10000
|
|---|
| 427 | system_time_zone CEST
|
|---|
| 428 | table_definition_cache 1400
|
|---|
| 429 | table_open_cache 2000
|
|---|
| 430 | table_open_cache_instances 1
|
|---|
| 431 | thread_cache_size 9
|
|---|
| 432 | thread_concurrency 10
|
|---|
| 433 | thread_handling one-thread-per-connection
|
|---|
| 434 | thread_stack 262144
|
|---|
| 435 | time_format %H:%i:%s
|
|---|
| 436 | time_zone SYSTEM
|
|---|
| 437 | timed_mutexes OFF
|
|---|
| 438 | timestamp 1429300119.177702
|
|---|
| 439 | tmp_table_size 16777216
|
|---|
| 440 | tmpdir /var/folders/rb/t5gw7jmd1716d4lc8y5w3gm80000gn/T/
|
|---|
| 441 | transaction_alloc_block_size 8192
|
|---|
| 442 | transaction_allow_batching OFF
|
|---|
| 443 | transaction_prealloc_size 4096
|
|---|
| 444 | tx_isolation REPEATABLE-READ
|
|---|
| 445 | tx_read_only OFF
|
|---|
| 446 | unique_checks ON
|
|---|
| 447 | updatable_views_with_limit YES
|
|---|
| 448 | version 5.6.24
|
|---|
| 449 | version_comment Homebrew
|
|---|
| 450 | version_compile_machine x86_64
|
|---|
| 451 | version_compile_os osx10.10
|
|---|
| 452 | wait_timeout 28800
|
|---|
| 453 | warning_count 0
|
|---|