· 8 years ago · May 30, 2018, 12:36 AM
1START TRANSACTION READ only;
2CREATE TEMPORARY TABLE IF NOT EXISTS table1 (account_id INT(10) UNSIGNED);
3ROLLBACK;
4
5Variable_name Value
6auto_increment_increment 1
7auto_increment_offset 1
8autocommit ON
9automatic_sp_privileges ON
10avoid_temporal_upgrade OFF
11back_log 80
12basedir C:\Program Files\MySQL\MySQL Server 5.7\
13big_tables OFF
14bind_address *
15binlog_cache_size 32768
16binlog_checksum CRC32
17binlog_direct_non_transactional_updates OFF
18binlog_error_action ABORT_SERVER
19binlog_format ROW
20binlog_group_commit_sync_delay 0
21binlog_group_commit_sync_no_delay_count 0
22binlog_gtid_simple_recovery ON
23binlog_max_flush_queue_time 0
24binlog_order_commits ON
25binlog_row_image FULL
26binlog_rows_query_log_events OFF
27binlog_stmt_cache_size 32768
28binlog_transaction_dependency_history_size 25000
29binlog_transaction_dependency_tracking COMMIT_ORDER
30block_encryption_mode aes-128-ecb
31bulk_insert_buffer_size 8388608
32character_set_client utf8
33character_set_connection utf8
34character_set_database utf8
35character_set_filesystem binary
36character_set_results utf8
37character_set_server utf8
38character_set_system utf8
39character_sets_dir C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\
40check_proxy_users OFF
41collation_connection utf8_general_ci
42collation_database utf8_general_ci
43collation_server utf8_general_ci
44completion_type NO_CHAIN
45concurrent_insert AUTO
46connect_timeout 10
47core_file OFF
48datadir C:\ProgramData\MySQL\MySQL Server 5.7\Data\
49date_format %Y-%m-%d
50datetime_format %Y-%m-%d %H:%i:%s
51default_authentication_plugin mysql_native_password
52default_password_lifetime 0
53default_storage_engine InnoDB
54default_tmp_storage_engine InnoDB
55default_week_format 0
56delay_key_write ON
57delayed_insert_limit 100
58delayed_insert_timeout 300
59delayed_queue_size 1000
60disabled_storage_engines
61disconnect_on_expired_password ON
62div_precision_increment 4
63end_markers_in_json OFF
64enforce_gtid_consistency OFF
65eq_range_index_dive_limit 200
66error_count 0
67event_scheduler OFF
68expire_logs_days 0
69explicit_defaults_for_timestamp OFF
70external_user
71flush OFF
72flush_time 0
73foreign_key_checks ON
74ft_boolean_syntax "+ -><()~*:""""&|"
75ft_max_word_len 84
76ft_min_word_len 4
77ft_query_expansion_limit 20
78ft_stopword_file (built-in)
79general_log OFF
80general_log_file DESKTOP-11VS9FN.log
81group_concat_max_len 1024
82gtid_executed_compression_period 1000
83gtid_mode OFF
84gtid_next AUTOMATIC
85gtid_owned
86gtid_purged
87have_compress YES
88have_crypt NO
89have_dynamic_loading YES
90have_geometry YES
91have_openssl DISABLED
92have_profiling YES
93have_query_cache YES
94have_rtree_keys YES
95have_ssl DISABLED
96have_statement_timeout YES
97have_symlink YES
98host_cache_size 279
99hostname BLUEOA-LP005
100identity 0
101ignore_builtin_innodb OFF
102ignore_db_dirs
103init_connect
104init_file
105init_slave
106innodb_adaptive_flushing ON
107innodb_adaptive_flushing_lwm 10
108innodb_adaptive_hash_index ON
109innodb_adaptive_hash_index_parts 8
110innodb_adaptive_max_sleep_delay 150000
111innodb_api_bk_commit_interval 5
112innodb_api_disable_rowlock OFF
113innodb_api_enable_binlog OFF
114innodb_api_enable_mdl OFF
115innodb_api_trx_level 0
116innodb_autoextend_increment 64
117innodb_autoinc_lock_mode 1
118innodb_buffer_pool_chunk_size 8388608
119innodb_buffer_pool_dump_at_shutdown ON
120innodb_buffer_pool_dump_now OFF
121innodb_buffer_pool_dump_pct 25
122innodb_buffer_pool_filename ib_buffer_pool
123innodb_buffer_pool_instances 1
124innodb_buffer_pool_load_abort OFF
125innodb_buffer_pool_load_at_startup ON
126innodb_buffer_pool_load_now OFF
127innodb_buffer_pool_size 8388608
128innodb_change_buffer_max_size 25
129innodb_change_buffering all
130innodb_checksum_algorithm crc32
131innodb_checksums ON
132innodb_cmp_per_index_enabled OFF
133innodb_commit_concurrency 0
134innodb_compression_failure_threshold_pct 5
135innodb_compression_level 6
136innodb_compression_pad_pct_max 50
137innodb_concurrency_tickets 5000
138innodb_data_file_path ibdata1:12M:autoextend
139innodb_data_home_dir
140innodb_deadlock_detect ON
141innodb_default_row_format dynamic
142innodb_disable_sort_file_cache OFF
143innodb_doublewrite ON
144innodb_fast_shutdown 1
145innodb_file_format Barracuda
146innodb_file_format_check ON
147innodb_file_format_max Barracuda
148innodb_file_per_table ON
149innodb_fill_factor 100
150innodb_flush_log_at_timeout 1
151innodb_flush_log_at_trx_commit 1
152innodb_flush_method
153innodb_flush_neighbors 1
154innodb_flush_sync ON
155innodb_flushing_avg_loops 30
156innodb_force_load_corrupted OFF
157innodb_force_recovery 0
158innodb_ft_aux_table
159innodb_ft_cache_size 8000000
160innodb_ft_enable_diag_print OFF
161innodb_ft_enable_stopword ON
162innodb_ft_max_token_size 84
163innodb_ft_min_token_size 3
164innodb_ft_num_word_optimize 2000
165innodb_ft_result_cache_limit 2000000000
166innodb_ft_server_stopword_table
167innodb_ft_sort_pll_degree 2
168innodb_ft_total_cache_size 640000000
169innodb_ft_user_stopword_table
170innodb_io_capacity 200
171innodb_io_capacity_max 2000
172innodb_large_prefix ON
173innodb_lock_wait_timeout 50
174innodb_locks_unsafe_for_binlog OFF
175innodb_log_buffer_size 1048576
176innodb_log_checksums ON
177innodb_log_compressed_pages ON
178innodb_log_file_size 50331648
179innodb_log_files_in_group 2
180innodb_log_group_home_dir .\
181innodb_log_write_ahead_size 8192
182innodb_lru_scan_depth 1024
183innodb_max_dirty_pages_pct 75
184innodb_max_dirty_pages_pct_lwm 0
185innodb_max_purge_lag 0
186innodb_max_purge_lag_delay 0
187innodb_max_undo_log_size 1073741824
188innodb_monitor_disable
189innodb_monitor_enable
190innodb_monitor_reset
191innodb_monitor_reset_all
192innodb_old_blocks_pct 37
193innodb_old_blocks_time 1000
194innodb_online_alter_log_max_size 134217728
195innodb_open_files 300
196innodb_optimize_fulltext_only OFF
197innodb_page_cleaners 1
198innodb_page_size 16384
199innodb_print_all_deadlocks OFF
200innodb_purge_batch_size 300
201innodb_purge_rseg_truncate_frequency 128
202innodb_purge_threads 4
203innodb_random_read_ahead OFF
204innodb_read_ahead_threshold 56
205innodb_read_io_threads 4
206innodb_read_only OFF
207innodb_replication_delay 0
208innodb_rollback_on_timeout OFF
209innodb_rollback_segments 128
210innodb_sort_buffer_size 1048576
211innodb_spin_wait_delay 6
212innodb_stats_auto_recalc ON
213innodb_stats_include_delete_marked OFF
214innodb_stats_method nulls_equal
215innodb_stats_on_metadata OFF
216innodb_stats_persistent ON
217innodb_stats_persistent_sample_pages 20
218innodb_stats_sample_pages 8
219innodb_stats_transient_sample_pages 8
220innodb_status_output OFF
221innodb_status_output_locks OFF
222innodb_strict_mode OFF
223innodb_support_xa ON
224innodb_sync_array_size 1
225innodb_sync_spin_loops 30
226innodb_table_locks ON
227innodb_temp_data_file_path ibtmp1:12M:autoextend
228innodb_thread_concurrency 9
229innodb_thread_sleep_delay 0
230innodb_tmpdir
231innodb_undo_directory .\
232innodb_undo_log_truncate OFF
233innodb_undo_logs 128
234innodb_undo_tablespaces 0
235innodb_use_native_aio ON
236innodb_version 5.7.22
237innodb_write_io_threads 4
238insert_id 0
239interactive_timeout 28800
240internal_tmp_disk_storage_engine InnoDB
241join_buffer_size 262144
242keep_files_on_create OFF
243key_buffer_size 8388608
244key_cache_age_threshold 300
245key_cache_block_size 1024
246key_cache_division_limit 100
247keyring_operations ON
248large_files_support ON
249large_page_size 0
250large_pages OFF
251last_insert_id 0
252lc_messages en_US
253lc_messages_dir C:\Program Files\MySQL\MySQL Server 5.7\share\
254lc_time_names en_US
255license GPL
256local_infile ON
257lock_wait_timeout 31536000
258log_bin OFF
259log_bin_basename
260log_bin_index
261log_bin_trust_function_creators OFF
262log_bin_use_v1_row_events OFF
263log_builtin_as_identified_by_password OFF
264log_error .\DESKTOP-11VS9FN.err
265log_error_verbosity 3
266log_output FILE
267log_queries_not_using_indexes OFF
268log_slave_updates OFF
269log_slow_admin_statements OFF
270log_slow_slave_statements OFF
271log_statements_unsafe_for_binlog ON
272log_syslog ON
273log_syslog_tag
274log_throttle_queries_not_using_indexes 0
275log_timestamps UTC
276log_warnings 2
277long_query_time 10
278low_priority_updates OFF
279lower_case_file_system ON
280lower_case_table_names 1
281master_info_repository FILE
282master_verify_checksum OFF
283max_allowed_packet 173741056
284max_binlog_cache_size 1.84467E+19
285max_binlog_size 1073741824
286max_binlog_stmt_cache_size 1.84467E+19
287max_connect_errors 100
288max_connections 151
289max_delayed_threads 20
290max_digest_length 1024
291max_error_count 64
292max_execution_time 0
293max_heap_table_size 70254592
294max_insert_delayed_threads 20
295max_join_size 1.84467E+19
296max_length_for_sort_data 1024
297max_points_in_geometry 65536
298max_prepared_stmt_count 16382
299max_relay_log_size 0
300max_seeks_for_key 4294967295
301max_sort_length 1024
302max_sp_recursion_depth 0
303max_tmp_tables 32
304max_user_connections 0
305max_write_lock_count 4294967295
306metadata_locks_cache_size 1024
307metadata_locks_hash_instances 8
308min_examined_row_limit 0
309multi_range_count 256
310myisam_data_pointer_size 6
311myisam_max_sort_file_size 1.07374E+11
312myisam_mmap_size 1.84467E+19
313myisam_recover_options OFF
314myisam_repair_threads 1
315myisam_sort_buffer_size 8388608
316myisam_stats_method nulls_unequal
317myisam_use_mmap OFF
318mysql_native_password_proxy_users OFF
319named_pipe OFF
320net_buffer_length 16384
321net_read_timeout 30
322net_retry_count 10
323net_write_timeout 60
324new OFF
325ngram_token_size 2
326offline_mode OFF
327old OFF
328old_alter_table OFF
329old_passwords 0
330open_files_limit 6209
331optimizer_prune_level 1
332optimizer_search_depth 62
333optimizer_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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on"
334optimizer_trace "enabled=off,one_line=off"
335optimizer_trace_features "greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on"
336optimizer_trace_limit 1
337optimizer_trace_max_mem_size 16384
338optimizer_trace_offset -1
339parser_max_mem_size 1.84467E+19
340performance_schema ON
341performance_schema_accounts_size -1
342performance_schema_digests_size 10000
343performance_schema_events_stages_history_long_size 10000
344performance_schema_events_stages_history_size 10
345performance_schema_events_statements_history_long_size 10000
346performance_schema_events_statements_history_size 10
347performance_schema_events_transactions_history_long_size 10000
348performance_schema_events_transactions_history_size 10
349performance_schema_events_waits_history_long_size 10000
350performance_schema_events_waits_history_size 10
351performance_schema_hosts_size -1
352performance_schema_max_cond_classes 80
353performance_schema_max_cond_instances -1
354performance_schema_max_digest_length 1024
355performance_schema_max_file_classes 80
356performance_schema_max_file_handles 32768
357performance_schema_max_file_instances -1
358performance_schema_max_index_stat -1
359performance_schema_max_memory_classes 320
360performance_schema_max_metadata_locks -1
361performance_schema_max_mutex_classes 210
362performance_schema_max_mutex_instances -1
363performance_schema_max_prepared_statements_instances -1
364performance_schema_max_program_instances -1
365performance_schema_max_rwlock_classes 40
366performance_schema_max_rwlock_instances -1
367performance_schema_max_socket_classes 10
368performance_schema_max_socket_instances -1
369performance_schema_max_sql_text_length 1024
370performance_schema_max_stage_classes 150
371performance_schema_max_statement_classes 193
372performance_schema_max_statement_stack 10
373performance_schema_max_table_handles -1
374performance_schema_max_table_instances -1
375performance_schema_max_table_lock_stat -1
376performance_schema_max_thread_classes 50
377performance_schema_max_thread_instances -1
378performance_schema_session_connect_attrs_size 512
379performance_schema_setup_actors_size -1
380performance_schema_setup_objects_size -1
381performance_schema_users_size -1
382pid_file C:\ProgramData\MySQL\MySQL Server 5.7\Data\BLUEOA-LP005.pid
383plugin_dir C:\Program Files\MySQL\MySQL Server 5.7\lib\plugin\
384port 3306
385preload_buffer_size 32768
386profiling OFF
387profiling_history_size 15
388protocol_version 10
389proxy_user
390pseudo_slave_mode OFF
391pseudo_thread_id 503
392query_alloc_block_size 8192
393query_cache_limit 1048576
394query_cache_min_res_unit 4096
395query_cache_size 1048576
396query_cache_type OFF
397query_cache_wlock_invalidate OFF
398query_prealloc_size 8192
399rand_seed1 0
400rand_seed2 0
401range_alloc_block_size 4096
402range_optimizer_max_mem_size 8388608
403rbr_exec_mode STRICT
404read_buffer_size 8192
405read_only OFF
406read_rnd_buffer_size 1
407relay_log
408relay_log_basename C:\ProgramData\MySQL\MySQL Server 5.7\Data\BLUEOA-LP005-relay-bin
409relay_log_index C:\ProgramData\MySQL\MySQL Server 5.7\Data\BLUEOA-LP005-relay-bin.index
410relay_log_info_file relay-log.info
411relay_log_info_repository FILE
412relay_log_purge ON
413relay_log_recovery OFF
414relay_log_space_limit 0
415report_host
416report_password
417report_port 3306
418report_user
419require_secure_transport OFF
420rpl_stop_slave_timeout 31536000
421secure_auth ON
422secure_file_priv C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\
423server_id 1
424server_id_bits 32
425server_uuid 215d32a3-5340-11e8-93c8-106530971942
426session_track_gtids OFF
427session_track_schema ON
428session_track_state_change OFF
429session_track_system_variables "time_zone,autocommit,character_set_client,character_set_results,character_set_connection"
430session_track_transaction_info OFF
431sha256_password_proxy_users OFF
432shared_memory OFF
433shared_memory_base_name MYSQL
434show_compatibility_56 OFF
435show_create_table_verbosity OFF
436show_old_temporals OFF
437skip_external_locking ON
438skip_name_resolve OFF
439skip_networking OFF
440skip_show_database OFF
441slave_allow_batching OFF
442slave_checkpoint_group 512
443slave_checkpoint_period 300
444slave_compressed_protocol OFF
445slave_exec_mode IDEMPOTENT
446slave_load_tmpdir C:\WINDOWS\SERVIC~3\NETWOR~1\AppData\Local\Temp
447slave_max_allowed_packet 1073741824
448slave_net_timeout 60
449slave_parallel_type DATABASE
450slave_parallel_workers 0
451slave_pending_jobs_size_max 16777216
452slave_preserve_commit_order OFF
453slave_rows_search_algorithms "TABLE_SCAN,INDEX_SCAN"
454slave_skip_errors OFF
455slave_sql_verify_checksum ON
456slave_transaction_retries 10
457slave_type_conversions
458slow_launch_time 2
459slow_query_log ON
460slow_query_log_file DESKTOP-11VS9FN-slow.log
461socket MySQL
462sort_buffer_size 262144
463sql_auto_is_null OFF
464sql_big_selects ON
465sql_buffer_result OFF
466sql_log_bin ON
467sql_log_off OFF
468sql_mode
469sql_notes ON
470sql_quote_show_create ON
471sql_safe_updates OFF
472sql_select_limit 1.84467E+19
473sql_slave_skip_counter 0
474sql_warnings OFF
475ssl_ca
476ssl_capath
477ssl_cert
478ssl_cipher
479ssl_crl
480ssl_crlpath
481ssl_key
482stored_program_cache 256
483super_read_only OFF
484sync_binlog 1
485sync_frm ON
486sync_master_info 10000
487sync_relay_log 10000
488sync_relay_log_info 10000
489system_time_zone AUS Eastern Standard Time
490table_definition_cache 1400
491table_open_cache 2000
492table_open_cache_instances 16
493thread_cache_size 10
494thread_handling one-thread-per-connection
495thread_stack 262144
496time_format %H:%i:%s
497time_zone SYSTEM
498timestamp 1527639658
499tls_version "TLSv1,TLSv1.1"
500tmp_table_size 15728640
501tmpdir C:\WINDOWS\SERVIC~3\NETWOR~1\AppData\Local\Temp
502transaction_alloc_block_size 8192
503transaction_allow_batching OFF
504transaction_isolation REPEATABLE-READ
505transaction_prealloc_size 4096
506transaction_read_only OFF
507transaction_write_set_extraction OFF
508tx_isolation REPEATABLE-READ
509tx_read_only OFF
510unique_checks ON
511updatable_views_with_limit YES
512version 5.7.22-log
513version_comment MySQL Community Server (GPL)
514version_compile_machine x86_64
515version_compile_os Win64
516wait_timeout 28800
517warning_count 0