Advertisement
Guest User

Untitled

a guest
Jul 26th, 2020
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.32 KB | None | 0 0
  1. activate_all_roles_on_login OFF
  2. admin_address
  3. admin_port 33062
  4. auto_generate_certs ON
  5. auto_increment_increment 1
  6. auto_increment_offset 1
  7. autocommit ON
  8. automatic_sp_privileges ON
  9. avoid_temporal_upgrade OFF
  10. back_log 400
  11. basedir c:\wamp64\bin\mysql\mysql8.0.20\
  12. big_tables OFF
  13. bind_address *
  14. binlog_cache_size 32768
  15. binlog_checksum CRC32
  16. binlog_direct_non_transactional_updates OFF
  17. binlog_encryption OFF
  18. binlog_error_action ABORT_SERVER
  19. binlog_expire_logs_seconds 2592000
  20. binlog_format ROW
  21. binlog_group_commit_sync_delay 0
  22. binlog_group_commit_sync_no_delay_count 0
  23. binlog_gtid_simple_recovery ON
  24. binlog_max_flush_queue_time 0
  25. binlog_order_commits ON
  26. binlog_rotate_encryption_master_key_at_startup OFF
  27. binlog_row_event_max_size 8192
  28. binlog_row_image FULL
  29. binlog_row_metadata MINIMAL
  30. binlog_row_value_options
  31. binlog_rows_query_log_events OFF
  32. binlog_stmt_cache_size 32768
  33. binlog_transaction_compression OFF
  34. binlog_transaction_compression_level_zstd 3
  35. binlog_transaction_dependency_history_size 25000
  36. binlog_transaction_dependency_tracking COMMIT_ORDER
  37. block_encryption_mode aes-128-ecb
  38. bulk_insert_buffer_size 8388608
  39. caching_sha2_password_auto_generate_rsa_keys ON
  40. caching_sha2_password_private_key_path private_key.pem
  41. caching_sha2_password_public_key_path public_key.pem
  42. character_set_client utf8mb4
  43. character_set_connection utf8mb4
  44. character_set_database utf8mb4
  45. character_set_filesystem binary
  46. character_set_results utf8mb4
  47. character_set_server utf8mb4
  48. character_set_system utf8
  49. character_sets_dir c:\wamp64\bin\mysql\mysql8.0.20\share\charsets\
  50. check_proxy_users OFF
  51. collation_connection utf8mb4_0900_ai_ci
  52. collation_database utf8mb4_0900_ai_ci
  53. collation_server utf8mb4_0900_ai_ci
  54. completion_type NO_CHAIN
  55. concurrent_insert AUTO
  56. connect_timeout 10
  57. core_file OFF
  58. create_admin_listener_thread OFF
  59. cte_max_recursion_depth 1000
  60. datadir c:\wamp64\bin\mysql\mysql8.0.20\data\
  61. default_authentication_plugin mysql_native_password
  62. default_collation_for_utf8mb4 utf8mb4_0900_ai_ci
  63. default_password_lifetime 0
  64. default_storage_engine InnoDB
  65. default_table_encryption OFF
  66. default_tmp_storage_engine InnoDB
  67. default_week_format 0
  68. delay_key_write ON
  69. delayed_insert_limit 100
  70. delayed_insert_timeout 300
  71. delayed_queue_size 1000
  72. disabled_storage_engines
  73. disconnect_on_expired_password ON
  74. div_precision_increment 4
  75. end_markers_in_json OFF
  76. enforce_gtid_consistency OFF
  77. eq_range_index_dive_limit 200
  78. event_scheduler ON
  79. expire_logs_days 0
  80. explicit_defaults_for_timestamp ON
  81. flush OFF
  82. flush_time 0
  83. foreign_key_checks ON
  84. ft_boolean_syntax + -><()~*:""&|
  85. ft_max_word_len 84
  86. ft_min_word_len 4
  87. ft_query_expansion_limit 20
  88. ft_stopword_file (built-in)
  89. general_log OFF
  90. general_log_file c:\wamp64\bin\mysql\mysql8.0.20\data\MIS-VIS2-VM3.log
  91. generated_random_password_length 20
  92. group_concat_max_len 1024
  93. group_replication_consistency EVENTUAL
  94. gtid_executed
  95. gtid_executed_compression_period 1000
  96. gtid_mode OFF
  97. gtid_owned
  98. gtid_purged
  99. have_compress YES
  100. have_dynamic_loading YES
  101. have_geometry YES
  102. have_openssl DISABLED
  103. have_profiling YES
  104. have_query_cache NO
  105. have_rtree_keys YES
  106. have_ssl DISABLED
  107. have_statement_timeout YES
  108. have_symlink DISABLED
  109. histogram_generation_max_mem_size 20000000
  110. host_cache_size 528
  111. hostname MIS-VIS2-VM3
  112. information_schema_stats_expiry 86400
  113. init_connect
  114. init_file
  115. init_slave
  116. innodb_adaptive_flushing ON
  117. innodb_adaptive_flushing_lwm 10
  118. innodb_adaptive_hash_index ON
  119. innodb_adaptive_hash_index_parts 8
  120. innodb_adaptive_max_sleep_delay 150000
  121. innodb_api_bk_commit_interval 5
  122. innodb_api_disable_rowlock OFF
  123. innodb_api_enable_binlog OFF
  124. innodb_api_enable_mdl OFF
  125. innodb_api_trx_level 0
  126. innodb_autoextend_increment 64
  127. innodb_autoinc_lock_mode 1
  128. innodb_buffer_pool_chunk_size 134217728
  129. innodb_buffer_pool_dump_at_shutdown ON
  130. innodb_buffer_pool_dump_now OFF
  131. innodb_buffer_pool_dump_pct 25
  132. innodb_buffer_pool_filename ib_buffer_pool
  133. innodb_buffer_pool_in_core_file ON
  134. innodb_buffer_pool_instances 8
  135. innodb_buffer_pool_load_abort OFF
  136. innodb_buffer_pool_load_at_startup ON
  137. innodb_buffer_pool_load_now OFF
  138. innodb_buffer_pool_size 4294967296
  139. innodb_change_buffer_max_size 25
  140. innodb_change_buffering all
  141. innodb_checksum_algorithm crc32
  142. innodb_cmp_per_index_enabled OFF
  143. innodb_commit_concurrency 0
  144. innodb_compression_failure_threshold_pct 5
  145. innodb_compression_level 6
  146. innodb_compression_pad_pct_max 50
  147. innodb_concurrency_tickets 5000
  148. innodb_data_file_path ibdata1:12M:autoextend
  149. innodb_data_home_dir
  150. innodb_deadlock_detect ON
  151. innodb_dedicated_server OFF
  152. innodb_default_row_format dynamic
  153. innodb_directories
  154. innodb_disable_sort_file_cache OFF
  155. innodb_doublewrite ON
  156. innodb_doublewrite_batch_size 0
  157. innodb_doublewrite_dir
  158. innodb_doublewrite_files 2
  159. innodb_doublewrite_pages 8
  160. innodb_fast_shutdown 1
  161. innodb_file_per_table ON
  162. innodb_fill_factor 100
  163. innodb_flush_log_at_timeout 1
  164. innodb_flush_log_at_trx_commit 2
  165. innodb_flush_method unbuffered
  166. innodb_flush_neighbors 2
  167. innodb_flush_sync ON
  168. innodb_flushing_avg_loops 30
  169. innodb_force_load_corrupted OFF
  170. innodb_force_recovery 0
  171. innodb_fsync_threshold 0
  172. innodb_ft_aux_table
  173. innodb_ft_cache_size 8000000
  174. innodb_ft_enable_diag_print OFF
  175. innodb_ft_enable_stopword ON
  176. innodb_ft_max_token_size 84
  177. innodb_ft_min_token_size 3
  178. innodb_ft_num_word_optimize 2000
  179. innodb_ft_result_cache_limit 2000000000
  180. innodb_ft_server_stopword_table
  181. innodb_ft_sort_pll_degree 2
  182. innodb_ft_total_cache_size 640000000
  183. innodb_ft_user_stopword_table
  184. innodb_idle_flush_pct 100
  185. innodb_io_capacity 200
  186. innodb_io_capacity_max 2000
  187. innodb_lock_wait_timeout 120
  188. innodb_log_buffer_size 8388608
  189. innodb_log_checksums ON
  190. innodb_log_compressed_pages ON
  191. innodb_log_file_size 1073741824
  192. innodb_log_files_in_group 2
  193. innodb_log_group_home_dir .\
  194. innodb_log_spin_cpu_abs_lwm 80
  195. innodb_log_spin_cpu_pct_hwm 50
  196. innodb_log_wait_for_flush_spin_hwm 400
  197. innodb_log_write_ahead_size 8192
  198. innodb_lru_scan_depth 1024
  199. innodb_max_dirty_pages_pct 90.000000
  200. innodb_max_dirty_pages_pct_lwm 10.000000
  201. innodb_max_purge_lag 0
  202. innodb_max_purge_lag_delay 0
  203. innodb_max_undo_log_size 1073741824
  204. innodb_monitor_disable
  205. innodb_monitor_enable
  206. innodb_monitor_reset
  207. innodb_monitor_reset_all
  208. innodb_old_blocks_pct 37
  209. innodb_old_blocks_time 1000
  210. innodb_online_alter_log_max_size 134217728
  211. innodb_open_files 4000
  212. innodb_optimize_fulltext_only OFF
  213. innodb_page_cleaners 8
  214. innodb_page_size 16384
  215. innodb_parallel_read_threads 4
  216. innodb_print_all_deadlocks OFF
  217. innodb_print_ddl_logs OFF
  218. innodb_purge_batch_size 300
  219. innodb_purge_rseg_truncate_frequency 128
  220. innodb_purge_threads 4
  221. innodb_random_read_ahead OFF
  222. innodb_read_ahead_threshold 56
  223. innodb_read_io_threads 8
  224. innodb_read_only OFF
  225. innodb_redo_log_archive_dirs
  226. innodb_redo_log_encrypt OFF
  227. innodb_replication_delay 0
  228. innodb_rollback_on_timeout OFF
  229. innodb_rollback_segments 128
  230. innodb_sort_buffer_size 1048576
  231. innodb_spin_wait_delay 6
  232. innodb_spin_wait_pause_multiplier 50
  233. innodb_stats_auto_recalc ON
  234. innodb_stats_include_delete_marked OFF
  235. innodb_stats_method nulls_equal
  236. innodb_stats_on_metadata OFF
  237. innodb_stats_persistent ON
  238. innodb_stats_persistent_sample_pages 20
  239. innodb_stats_transient_sample_pages 8
  240. innodb_status_output OFF
  241. innodb_status_output_locks OFF
  242. innodb_strict_mode ON
  243. innodb_sync_array_size 1
  244. innodb_sync_spin_loops 30
  245. innodb_table_locks ON
  246. innodb_temp_data_file_path ibtmp1:12M:autoextend
  247. innodb_temp_tablespaces_dir .\#innodb_temp\
  248. innodb_thread_concurrency 64
  249. innodb_thread_sleep_delay 0
  250. innodb_tmpdir
  251. innodb_undo_directory .\
  252. innodb_undo_log_encrypt OFF
  253. innodb_undo_log_truncate ON
  254. innodb_undo_tablespaces 2
  255. innodb_use_native_aio ON
  256. innodb_version 8.0.20
  257. innodb_write_io_threads 8
  258. interactive_timeout 28800
  259. internal_tmp_mem_storage_engine MEMORY
  260. join_buffer_size 262144
  261. keep_files_on_create OFF
  262. key_buffer_size 1073741824
  263. key_cache_age_threshold 300
  264. key_cache_block_size 1024
  265. key_cache_division_limit 100
  266. keyring_operations ON
  267. large_files_support ON
  268. large_page_size 0
  269. large_pages OFF
  270. lc_messages en_US
  271. lc_messages_dir c:\wamp64\bin\mysql\mysql8.0.20\share\
  272. lc_time_names en_US
  273. license GPL
  274. local_infile OFF
  275. lock_wait_timeout 31536000
  276. log_bin OFF
  277. log_bin_basename
  278. log_bin_index
  279. log_bin_trust_function_creators OFF
  280. log_bin_use_v1_row_events OFF
  281. log_error c:\wamp64\logs\mysql.log
  282. log_error_services log_filter_internal; log_sink_internal
  283. log_error_suppression_list
  284. log_error_verbosity 2
  285. log_output FILE
  286. log_queries_not_using_indexes OFF
  287. log_raw OFF
  288. log_slave_updates OFF
  289. log_slow_admin_statements OFF
  290. log_slow_extra OFF
  291. log_slow_slave_statements OFF
  292. log_statements_unsafe_for_binlog ON
  293. log_throttle_queries_not_using_indexes 0
  294. log_timestamps UTC
  295. long_query_time 10.000000
  296. low_priority_updates OFF
  297. lower_case_file_system ON
  298. lower_case_table_names 1
  299. mandatory_roles
  300. master_info_repository TABLE
  301. master_verify_checksum OFF
  302. max_allowed_packet 1048576
  303. max_binlog_cache_size 18446744073709547520
  304. max_binlog_size 1073741824
  305. max_binlog_stmt_cache_size 18446744073709547520
  306. max_connect_errors 100000
  307. max_connections 400
  308. max_delayed_threads 20
  309. max_digest_length 1024
  310. max_error_count 1024
  311. max_execution_time 0
  312. max_heap_table_size 16777216
  313. max_insert_delayed_threads 20
  314. max_join_size 18446744073709551615
  315. max_length_for_sort_data 4096
  316. max_points_in_geometry 65536
  317. max_prepared_stmt_count 16382
  318. max_relay_log_size 0
  319. max_seeks_for_key 4294967295
  320. max_sort_length 1024
  321. max_sp_recursion_depth 0
  322. max_user_connections 0
  323. max_write_lock_count 4294967295
  324. min_examined_row_limit 0
  325. myisam_data_pointer_size 6
  326. myisam_max_sort_file_size 2146435072
  327. myisam_mmap_size 18446744073709551615
  328. myisam_recover_options OFF
  329. myisam_repair_threads 1
  330. myisam_sort_buffer_size 1073741824
  331. myisam_stats_method nulls_unequal
  332. myisam_use_mmap OFF
  333. mysql_native_password_proxy_users OFF
  334. mysqlx_bind_address *
  335. mysqlx_compression_algorithms DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM
  336. mysqlx_connect_timeout 30
  337. mysqlx_deflate_default_compression_level 3
  338. mysqlx_deflate_max_client_compression_level 5
  339. mysqlx_document_id_unique_prefix 0
  340. mysqlx_enable_hello_notice ON
  341. mysqlx_idle_worker_thread_timeout 60
  342. mysqlx_interactive_timeout 28800
  343. mysqlx_lz4_default_compression_level 2
  344. mysqlx_lz4_max_client_compression_level 8
  345. mysqlx_max_allowed_packet 67108864
  346. mysqlx_max_connections 100
  347. mysqlx_min_worker_threads 2
  348. mysqlx_port 33060
  349. mysqlx_port_open_timeout 0
  350. mysqlx_read_timeout 30
  351. mysqlx_socket /tmp/mysqlx.sock
  352. mysqlx_ssl_ca
  353. mysqlx_ssl_capath
  354. mysqlx_ssl_cert
  355. mysqlx_ssl_cipher
  356. mysqlx_ssl_crl
  357. mysqlx_ssl_crlpath
  358. mysqlx_ssl_key
  359. mysqlx_wait_timeout 28800
  360. mysqlx_write_timeout 60
  361. mysqlx_zstd_default_compression_level 3
  362. mysqlx_zstd_max_client_compression_level 11
  363. named_pipe OFF
  364. named_pipe_full_access_group *everyone*
  365. net_buffer_length 8192
  366. net_read_timeout 30
  367. net_retry_count 10
  368. net_write_timeout 60
  369. new OFF
  370. ngram_token_size 2
  371. offline_mode OFF
  372. old OFF
  373. old_alter_table OFF
  374. open_files_limit 10458
  375. optimizer_prune_level 1
  376. optimizer_search_depth 62
  377. 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,loosesc...
  378. optimizer_trace enabled=off,one_line=off
  379. optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  380. optimizer_trace_limit 1
  381. optimizer_trace_max_mem_size 1048576
  382. optimizer_trace_offset -1
  383. parser_max_mem_size 18446744073709551615
  384. partial_revokes OFF
  385. password_history 0
  386. password_require_current OFF
  387. password_reuse_interval 0
  388. performance_schema ON
  389. performance_schema_accounts_size -1
  390. performance_schema_digests_size 10000
  391. performance_schema_error_size 4697
  392. performance_schema_events_stages_history_long_size 10000
  393. performance_schema_events_stages_history_size 10
  394. performance_schema_events_statements_history_long_size 10000
  395. performance_schema_events_statements_history_size 10
  396. performance_schema_events_transactions_history_long_size 10000
  397. performance_schema_events_transactions_history_size 10
  398. performance_schema_events_waits_history_long_size 10000
  399. performance_schema_events_waits_history_size 10
  400. performance_schema_hosts_size -1
  401. performance_schema_max_cond_classes 100
  402. performance_schema_max_cond_instances -1
  403. performance_schema_max_digest_length 1024
  404. performance_schema_max_digest_sample_age 60
  405. performance_schema_max_file_classes 80
  406. performance_schema_max_file_handles 32768
  407. performance_schema_max_file_instances -1
  408. performance_schema_max_index_stat -1
  409. performance_schema_max_memory_classes 450
  410. performance_schema_max_metadata_locks -1
  411. performance_schema_max_mutex_classes 300
  412. performance_schema_max_mutex_instances -1
  413. performance_schema_max_prepared_statements_instances -1
  414. performance_schema_max_program_instances -1
  415. performance_schema_max_rwlock_classes 60
  416. performance_schema_max_rwlock_instances -1
  417. performance_schema_max_socket_classes 10
  418. performance_schema_max_socket_instances -1
  419. performance_schema_max_sql_text_length 1024
  420. performance_schema_max_stage_classes 175
  421. performance_schema_max_statement_classes 218
  422. performance_schema_max_statement_stack 10
  423. performance_schema_max_table_handles -1
  424. performance_schema_max_table_instances -1
  425. performance_schema_max_table_lock_stat -1
  426. performance_schema_max_thread_classes 100
  427. performance_schema_max_thread_instances -1
  428. performance_schema_session_connect_attrs_size 512
  429. performance_schema_setup_actors_size -1
  430. performance_schema_setup_objects_size -1
  431. performance_schema_users_size -1
  432. persist_only_admin_x509_subject
  433. persisted_globals_load ON
  434. pid_file c:\wamp64\bin\mysql\mysql8.0.20\data\MIS-VIS2-VM3.pid
  435. plugin_dir c:\wamp64\bin\mysql\mysql8.0.20\lib\plugin\
  436. port 3306
  437. preload_buffer_size 32768
  438. print_identified_with_as_hex OFF
  439. profiling OFF
  440. profiling_history_size 15
  441. protocol_compression_algorithms zlib,zstd,uncompressed
  442. protocol_version 10
  443. query_alloc_block_size 8192
  444. query_prealloc_size 8192
  445. range_alloc_block_size 4096
  446. range_optimizer_max_mem_size 8388608
  447. rbr_exec_mode STRICT
  448. read_buffer_size 2097152
  449. read_only OFF
  450. read_rnd_buffer_size 2097152
  451. regexp_stack_limit 8000000
  452. regexp_time_limit 32
  453. relay_log MIS-VIS2-VM3-relay-bin
  454. relay_log_basename c:\wamp64\bin\mysql\mysql8.0.20\data\MIS-VIS2-VM3-relay-bin
  455. relay_log_index c:\wamp64\bin\mysql\mysql8.0.20\data\MIS-VIS2-VM3-relay-bin.index
  456. relay_log_info_file relay-log.info
  457. relay_log_info_repository TABLE
  458. relay_log_purge ON
  459. relay_log_recovery OFF
  460. relay_log_space_limit 0
  461. report_host
  462. report_password
  463. report_port 3306
  464. report_user
  465. require_secure_transport OFF
  466. rpl_read_size 8192
  467. rpl_stop_slave_timeout 31536000
  468. schema_definition_cache 256
  469. secondary_engine_cost_threshold 100000.000000
  470. secure_file_priv c:\wamp64\tmp\
  471. server_id 1
  472. server_id_bits 32
  473. server_uuid 9895a8b9-aca8-11ea-bcff-00155d0e1420
  474. session_track_gtids OFF
  475. session_track_schema ON
  476. session_track_state_change OFF
  477. session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  478. session_track_transaction_info OFF
  479. sha256_password_auto_generate_rsa_keys ON
  480. sha256_password_private_key_path private_key.pem
  481. sha256_password_proxy_users OFF
  482. sha256_password_public_key_path public_key.pem
  483. shared_memory OFF
  484. shared_memory_base_name MYSQL
  485. show_create_table_verbosity OFF
  486. show_old_temporals OFF
  487. skip_external_locking ON
  488. skip_name_resolve OFF
  489. skip_networking OFF
  490. skip_show_database OFF
  491. slave_allow_batching OFF
  492. slave_checkpoint_group 512
  493. slave_checkpoint_period 300
  494. slave_compressed_protocol OFF
  495. slave_exec_mode STRICT
  496. slave_load_tmpdir C:\Windows\TEMP
  497. slave_max_allowed_packet 1073741824
  498. slave_net_timeout 60
  499. slave_parallel_type DATABASE
  500. slave_parallel_workers 0
  501. slave_pending_jobs_size_max 134217728
  502. slave_preserve_commit_order OFF
  503. slave_rows_search_algorithms INDEX_SCAN,HASH_SCAN
  504. slave_skip_errors OFF
  505. slave_sql_verify_checksum ON
  506. slave_transaction_retries 10
  507. slave_type_conversions
  508. slow_launch_time 2
  509. slow_query_log OFF
  510. slow_query_log_file c:\wamp64\bin\mysql\mysql8.0.20\data\MIS-VIS2-VM3-slow.log
  511. socket /tmp/mysql.sock
  512. sort_buffer_size 4194304
  513. sql_auto_is_null OFF
  514. sql_big_selects ON
  515. sql_buffer_result OFF
  516. sql_log_off OFF
  517. sql_mode
  518. sql_notes ON
  519. sql_quote_show_create ON
  520. sql_require_primary_key OFF
  521. sql_safe_updates OFF
  522. sql_select_limit 18446744073709551615
  523. sql_slave_skip_counter 0
  524. sql_warnings OFF
  525. ssl_ca
  526. ssl_capath
  527. ssl_cert
  528. ssl_cipher
  529. ssl_crl
  530. ssl_crlpath
  531. ssl_fips_mode OFF
  532. ssl_key
  533. stored_program_cache 256
  534. stored_program_definition_cache 256
  535. super_read_only OFF
  536. sync_binlog 1
  537. sync_master_info 10000
  538. sync_relay_log 10000
  539. sync_relay_log_info 10000
  540. system_time_zone Malay Peninsula Standard Time
  541. table_definition_cache 600
  542. table_encryption_privilege_check OFF
  543. table_open_cache 4000
  544. table_open_cache_instances 16
  545. tablespace_definition_cache 256
  546. temptable_max_ram 1073741824
  547. temptable_use_mmap ON
  548. thread_cache_size 12
  549. thread_handling one-thread-per-connection
  550. thread_stack 286720
  551. time_zone SYSTEM
  552. tls_ciphersuites
  553. tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
  554. tmp_table_size 16777216
  555. tmpdir C:\Windows\TEMP
  556. transaction_alloc_block_size 8192
  557. transaction_isolation REPEATABLE-READ
  558. transaction_prealloc_size 4096
  559. transaction_read_only OFF
  560. transaction_write_set_extraction XXHASH64
  561. unique_checks ON
  562. updatable_views_with_limit YES
  563. version 8.0.20
  564. version_comment MySQL Community Server - GPL
  565. version_compile_machine x86_64
  566. version_compile_os Win64
  567. version_compile_zlib 1.2.11
  568. wait_timeout 28800
  569. windowing_use_high_precision ON
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement