| 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 | |
|---|