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