Guest User

Untitled

a guest
Dec 17th, 2020
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.60 KB | None | 0 0
  1. Variable_name Value
  2. alter_algorithm DEFAULT
  3. analyze_sample_percentage 100.000000
  4. aria_block_size 8192
  5. aria_checkpoint_interval 30
  6. aria_checkpoint_log_activity 1048576
  7. aria_encrypt_tables OFF
  8. aria_force_start_after_recovery_failures 0
  9. aria_group_commit none
  10. aria_group_commit_interval 0
  11. aria_log_file_size 1073741824
  12. aria_log_purge_type immediate
  13. aria_max_sort_file_size 9223372036853727232
  14. aria_page_checksum ON
  15. aria_pagecache_age_threshold 300
  16. aria_pagecache_buffer_size 134217728
  17. aria_pagecache_division_limit 100
  18. aria_pagecache_file_hash_size 512
  19. aria_recover_options BACKUP,QUICK
  20. aria_repair_threads 1
  21. aria_sort_buffer_size 268434432
  22. aria_stats_method nulls_unequal
  23. aria_sync_log_dir NEWFILE
  24. aria_used_for_temp_tables ON
  25. auto_increment_increment 1
  26. auto_increment_offset 1
  27. autocommit ON
  28. automatic_sp_privileges ON
  29. back_log 80
  30. basedir ./
  31. big_tables OFF
  32. bind_address 0.0.0.0
  33. binlog_annotate_row_events OFF
  34. binlog_cache_size 32768
  35. binlog_checksum CRC32
  36. binlog_commit_wait_count 0
  37. binlog_commit_wait_usec 100000
  38. binlog_direct_non_transactional_updates OFF
  39. binlog_file_cache_size 16384
  40. binlog_format ROW
  41. binlog_optimize_thread_scheduling ON
  42. binlog_row_image FULL
  43. binlog_row_metadata NO_LOG
  44. binlog_stmt_cache_size 32768
  45. bulk_insert_buffer_size 8388608
  46. character_set_client utf8
  47. character_set_connection utf8
  48. character_set_database utf8
  49. character_set_filesystem binary
  50. character_set_results utf8
  51. character_set_server utf8
  52. character_set_system utf8
  53. character_sets_dir /usr/share/mysql/charsets/
  54. check_constraint_checks ON
  55. collation_connection utf8_general_ci
  56. collation_database utf8_general_ci
  57. collation_server utf8_general_ci
  58. column_compression_threshold 100
  59. column_compression_zlib_level 6
  60. column_compression_zlib_strategy DEFAULT_STRATEGY
  61. column_compression_zlib_wrap OFF
  62. completion_type NO_CHAIN
  63. concurrent_insert AUTO
  64. connect_timeout 10
  65. core_file OFF
  66. date_format %Y-%m-%d
  67. datetime_format %Y-%m-%d %H:%i:%s
  68. deadlock_search_depth_long 15
  69. deadlock_search_depth_short 4
  70. deadlock_timeout_long 50000000
  71. deadlock_timeout_short 10000
  72. debug_no_thread_alarm OFF
  73. default_password_lifetime 0
  74. default_regex_flags
  75. default_storage_engine InnoDB
  76. default_tmp_storage_engine
  77. default_week_format 0
  78. delay_key_write ON
  79. delayed_insert_limit 100
  80. delayed_insert_timeout 300
  81. delayed_queue_size 1000
  82. disconnect_on_expired_password OFF
  83. div_precision_increment 4
  84. encrypt_binlog OFF
  85. encrypt_tmp_disk_tables OFF
  86. encrypt_tmp_files OFF
  87. enforce_storage_engine
  88. eq_range_index_dive_limit 200
  89. event_scheduler OFF
  90. expensive_subquery_limit 100
  91. expire_logs_days 0
  92. explicit_defaults_for_timestamp OFF
  93. extra_max_connections 1
  94. extra_port 0
  95. flush OFF
  96. flush_time 0
  97. foreign_key_checks ON
  98. ft_boolean_syntax + -><()~*:""&|
  99. ft_max_word_len 84
  100. ft_min_word_len 2
  101. ft_query_expansion_limit 20
  102. ft_stopword_file (built-in)
  103. general_log OFF
  104. general_log_file master-server-name.log
  105. group_concat_max_len 1048576
  106. gtid_binlog_pos 0-1936251580-21211509
  107. gtid_binlog_state 0-1936045951-11119024,0-1936251580-21211509
  108. gtid_cleanup_batch_size 64
  109. gtid_current_pos 0-1936251580-21211509
  110. gtid_domain_id 0
  111. gtid_ignore_duplicates OFF
  112. gtid_pos_auto_engines
  113. gtid_slave_pos 0-1936045951-11119024
  114. gtid_strict_mode OFF
  115. have_compress YES
  116. have_crypt YES
  117. have_dynamic_loading YES
  118. have_geometry YES
  119. have_openssl YES
  120. have_profiling YES
  121. have_query_cache YES
  122. have_rtree_keys YES
  123. have_ssl DISABLED
  124. have_symlink YES
  125. histogram_size 254
  126. histogram_type DOUBLE_PREC_HB
  127. host_cache_size 278
  128. hostname master-server-name
  129. idle_readonly_transaction_timeout 0
  130. idle_transaction_timeout 0
  131. idle_write_transaction_timeout 0
  132. ignore_builtin_innodb OFF
  133. ignore_db_dirs
  134. in_predicate_conversion_threshold 1000
  135. init_connect
  136. init_file
  137. init_slave
  138. innodb_adaptive_flushing ON
  139. innodb_adaptive_flushing_lwm 10.000000
  140. innodb_adaptive_hash_index OFF
  141. innodb_adaptive_hash_index_parts 8
  142. innodb_adaptive_max_sleep_delay 0
  143. innodb_autoextend_increment 64
  144. innodb_autoinc_lock_mode 1
  145. innodb_background_scrub_data_check_interval 0
  146. innodb_background_scrub_data_compressed OFF
  147. innodb_background_scrub_data_interval 0
  148. innodb_background_scrub_data_uncompressed OFF
  149. innodb_buf_dump_status_frequency 0
  150. innodb_buffer_pool_chunk_size 16777216
  151. innodb_buffer_pool_dump_at_shutdown ON
  152. innodb_buffer_pool_dump_now OFF
  153. innodb_buffer_pool_dump_pct 25
  154. innodb_buffer_pool_filename ib_buffer_pool
  155. innodb_buffer_pool_instances 1
  156. innodb_buffer_pool_load_abort OFF
  157. innodb_buffer_pool_load_at_startup ON
  158. innodb_buffer_pool_load_now OFF
  159. innodb_buffer_pool_size 16777216
  160. innodb_change_buffer_max_size 25
  161. innodb_change_buffering all
  162. innodb_checksum_algorithm full_crc32
  163. innodb_cmp_per_index_enabled OFF
  164. innodb_commit_concurrency 0
  165. innodb_compression_algorithm zlib
  166. innodb_compression_default OFF
  167. innodb_compression_failure_threshold_pct 5
  168. innodb_compression_level 6
  169. innodb_compression_pad_pct_max 50
  170. innodb_concurrency_tickets 0
  171. innodb_data_file_path ibdata1:12M:autoextend
  172. innodb_data_home_dir
  173. innodb_deadlock_detect ON
  174. innodb_default_encryption_key_id 1
  175. innodb_default_row_format dynamic
  176. innodb_defragment OFF
  177. innodb_defragment_fill_factor 0.900000
  178. innodb_defragment_fill_factor_n_recs 20
  179. innodb_defragment_frequency 40
  180. innodb_defragment_n_pages 7
  181. innodb_defragment_stats_accuracy 0
  182. innodb_disable_sort_file_cache OFF
  183. innodb_disallow_writes OFF
  184. innodb_doublewrite ON
  185. innodb_encrypt_log OFF
  186. innodb_encrypt_tables OFF
  187. innodb_encrypt_temporary_tables OFF
  188. innodb_encryption_rotate_key_age 1
  189. innodb_encryption_rotation_iops 100
  190. innodb_encryption_threads 0
  191. innodb_fast_shutdown 1
  192. innodb_fatal_semaphore_wait_threshold 600
  193. innodb_file_format
  194. innodb_file_per_table ON
  195. innodb_fill_factor 100
  196. innodb_flush_log_at_timeout 1
  197. innodb_flush_log_at_trx_commit 2
  198. innodb_flush_method O_DIRECT
  199. innodb_flush_neighbors 0
  200. innodb_flush_sync ON
  201. innodb_flushing_avg_loops 30
  202. innodb_force_load_corrupted OFF
  203. innodb_force_primary_key OFF
  204. innodb_force_recovery 0
  205. innodb_ft_aux_table
  206. innodb_ft_cache_size 8000000
  207. innodb_ft_enable_diag_print OFF
  208. innodb_ft_enable_stopword ON
  209. innodb_ft_max_token_size 84
  210. innodb_ft_min_token_size 3
  211. innodb_ft_num_word_optimize 2000
  212. innodb_ft_result_cache_limit 2000000000
  213. innodb_ft_server_stopword_table
  214. innodb_ft_sort_pll_degree 2
  215. innodb_ft_total_cache_size 640000000
  216. innodb_ft_user_stopword_table
  217. innodb_idle_flush_pct 100
  218. innodb_immediate_scrub_data_uncompressed OFF
  219. innodb_instant_alter_column_allowed add_drop_reorder
  220. innodb_io_capacity 200
  221. innodb_io_capacity_max 2000
  222. innodb_large_prefix
  223. innodb_lock_schedule_algorithm fcfs
  224. innodb_lock_wait_timeout 50
  225. innodb_log_buffer_size 16777216
  226. innodb_log_checksums ON
  227. innodb_log_compressed_pages ON
  228. innodb_log_file_size 33554432
  229. innodb_log_files_in_group 1
  230. innodb_log_group_home_dir ./
  231. innodb_log_optimize_ddl OFF
  232. innodb_log_write_ahead_size 8192
  233. innodb_lru_flush_size 32
  234. innodb_lru_scan_depth 1536
  235. innodb_max_dirty_pages_pct 90.000000
  236. innodb_max_dirty_pages_pct_lwm 0.000000
  237. innodb_max_purge_lag 0
  238. innodb_max_purge_lag_delay 0
  239. innodb_max_purge_lag_wait 4294967295
  240. innodb_max_undo_log_size 10485760
  241. innodb_monitor_disable
  242. innodb_monitor_enable
  243. innodb_monitor_reset
  244. innodb_monitor_reset_all
  245. innodb_old_blocks_pct 37
  246. innodb_old_blocks_time 1000
  247. innodb_online_alter_log_max_size 134217728
  248. innodb_open_files 2000
  249. innodb_optimize_fulltext_only OFF
  250. innodb_page_cleaners 1
  251. innodb_page_size 16384
  252. innodb_prefix_index_cluster_optimization OFF
  253. innodb_print_all_deadlocks OFF
  254. innodb_purge_batch_size 300
  255. innodb_purge_rseg_truncate_frequency 128
  256. innodb_purge_threads 4
  257. innodb_random_read_ahead OFF
  258. innodb_read_ahead_threshold 56
  259. innodb_read_io_threads 4
  260. innodb_read_only OFF
  261. innodb_replication_delay 0
  262. innodb_rollback_on_timeout OFF
  263. innodb_scrub_log OFF
  264. innodb_scrub_log_speed 256
  265. innodb_sort_buffer_size 1048576
  266. innodb_spin_wait_delay 4
  267. innodb_stats_auto_recalc ON
  268. innodb_stats_include_delete_marked OFF
  269. innodb_stats_method nulls_equal
  270. innodb_stats_modified_counter 0
  271. innodb_stats_on_metadata OFF
  272. innodb_stats_persistent ON
  273. innodb_stats_persistent_sample_pages 20
  274. innodb_stats_traditional ON
  275. innodb_stats_transient_sample_pages 8
  276. innodb_status_output OFF
  277. innodb_status_output_locks OFF
  278. innodb_strict_mode ON
  279. innodb_sync_array_size 1
  280. innodb_sync_spin_loops 30
  281. innodb_table_locks ON
  282. innodb_temp_data_file_path ibtmp1:12M:autoextend
  283. innodb_thread_concurrency 0
  284. innodb_thread_sleep_delay 0
  285. innodb_tmpdir
  286. innodb_undo_directory ./
  287. innodb_undo_log_truncate OFF
  288. innodb_undo_logs 128
  289. innodb_undo_tablespaces 0
  290. innodb_use_atomic_writes ON
  291. innodb_use_native_aio ON
  292. innodb_version 10.5.8
  293. innodb_write_io_threads 4
  294. interactive_timeout 31536000
  295. join_buffer_size 16777216
  296. join_buffer_space_limit 2097152
  297. join_cache_level 2
  298. keep_files_on_create OFF
  299. key_buffer_size 1073741824
  300. key_cache_age_threshold 300
  301. key_cache_block_size 1024
  302. key_cache_division_limit 100
  303. key_cache_file_hash_size 512
  304. key_cache_segments 0
  305. large_files_support ON
  306. large_page_size 0
  307. large_pages OFF
  308. lc_messages en_US
  309. lc_messages_dir
  310. lc_time_names en_US
  311. license GPL
  312. local_infile ON
  313. lock_wait_timeout 86400
  314. locked_in_memory OFF
  315. log_bin ON
  316. log_bin_basename /mnt/binlog/mysql-bin
  317. log_bin_compress OFF
  318. log_bin_compress_min_len 256
  319. log_bin_index /mnt/binlog/mysql-bin.index
  320. log_bin_trust_function_creators OFF
  321. log_disabled_statements sp
  322. log_error
  323. log_output FILE
  324. log_queries_not_using_indexes OFF
  325. log_slave_updates ON
  326. log_slow_admin_statements ON
  327. log_slow_disabled_statements sp
  328. log_slow_filter admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  329. log_slow_rate_limit 1
  330. log_slow_slave_statements ON
  331. log_slow_verbosity
  332. log_tc_size 24576
  333. log_warnings 2
  334. long_query_time 10.000000
  335. low_priority_updates OFF
  336. lower_case_file_system OFF
  337. lower_case_table_names 0
  338. master_verify_checksum OFF
  339. max_allowed_packet 33554432
  340. max_binlog_cache_size 18446744073709547520
  341. max_binlog_size 1073741824
  342. max_binlog_stmt_cache_size 18446744073709547520
  343. max_connect_errors 100
  344. max_connections 150
  345. max_delayed_threads 20
  346. max_digest_length 1024
  347. max_error_count 64
  348. max_heap_table_size 134217728
  349. max_insert_delayed_threads 20
  350. max_join_size 18446744073709551615
  351. max_length_for_sort_data 1024
  352. max_password_errors 4294967295
  353. max_prepared_stmt_count 16382
  354. max_recursive_iterations 4294967295
  355. max_relay_log_size 1073741824
  356. max_rowid_filter_size 131072
  357. max_seeks_for_key 4294967295
  358. max_session_mem_used 9223372036854775807
  359. max_sort_length 1024
  360. max_sp_recursion_depth 0
  361. max_statement_time 0.000000
  362. max_tmp_tables 32
  363. max_user_connections 0
  364. max_write_lock_count 4294967295
  365. metadata_locks_cache_size 1024
  366. metadata_locks_hash_instances 8
  367. min_examined_row_limit 0
  368. mrr_buffer_size 262144
  369. myisam_block_size 1024
  370. myisam_data_pointer_size 6
  371. myisam_max_sort_file_size 9223372036853727232
  372. myisam_mmap_size 18446744073709551615
  373. myisam_recover_options BACKUP,QUICK
  374. myisam_repair_threads 1
  375. myisam_sort_buffer_size 134216704
  376. myisam_stats_method NULLS_UNEQUAL
  377. myisam_use_mmap OFF
  378. mysql56_temporal_format ON
  379. net_buffer_length 16384
  380. net_read_timeout 30
  381. net_retry_count 10
  382. net_write_timeout 60
  383. old OFF
  384. old_alter_table DEFAULT
  385. old_mode
  386. old_passwords OFF
  387. open_files_limit 32183
  388. optimizer_prune_level 1
  389. optimizer_search_depth 62
  390. optimizer_selectivity_sampling_limit 100
  391. optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
  392. optimizer_trace enabled=off
  393. optimizer_trace_max_mem_size 1048576
  394. optimizer_use_condition_selectivity 4
  395. performance_schema ON
  396. performance_schema_accounts_size -1
  397. performance_schema_digests_size 5000
  398. performance_schema_events_stages_history_long_size 1000
  399. performance_schema_events_stages_history_size 10
  400. performance_schema_events_statements_history_long_size 1000
  401. performance_schema_events_statements_history_size 10
  402. performance_schema_events_transactions_history_long_size 1000
  403. performance_schema_events_transactions_history_size 10
  404. performance_schema_events_waits_history_long_size 1000
  405. performance_schema_events_waits_history_size 10
  406. performance_schema_hosts_size -1
  407. performance_schema_max_cond_classes 90
  408. performance_schema_max_cond_instances -1
  409. performance_schema_max_digest_length 1024
  410. performance_schema_max_file_classes 80
  411. performance_schema_max_file_handles 32768
  412. performance_schema_max_file_instances -1
  413. performance_schema_max_index_stat -1
  414. performance_schema_max_memory_classes 320
  415. performance_schema_max_metadata_locks -1
  416. performance_schema_max_mutex_classes 210
  417. performance_schema_max_mutex_instances -1
  418. performance_schema_max_prepared_statements_instances -1
  419. performance_schema_max_program_instances -1
  420. performance_schema_max_rwlock_classes 50
  421. performance_schema_max_rwlock_instances -1
  422. performance_schema_max_socket_classes 10
  423. performance_schema_max_socket_instances -1
  424. performance_schema_max_sql_text_length 1024
  425. performance_schema_max_stage_classes 160
  426. performance_schema_max_statement_classes 222
  427. performance_schema_max_statement_stack 10
  428. performance_schema_max_table_handles -1
  429. performance_schema_max_table_instances -1
  430. performance_schema_max_table_lock_stat -1
  431. performance_schema_max_thread_classes 50
  432. performance_schema_max_thread_instances -1
  433. performance_schema_session_connect_attrs_size 512
  434. performance_schema_setup_actors_size -1
  435. performance_schema_setup_objects_size -1
  436. performance_schema_users_size -1
  437. pid_file /mnt/data-dir/mysql.pid
  438. plugin_dir /usr//lib64/mysql/plugin/
  439. plugin_maturity gamma
  440. port 3306
  441. preload_buffer_size 32768
  442. profiling OFF
  443. profiling_history_size 15
  444. progress_report_time 5
  445. protocol_version 10
  446. proxy_protocol_networks
  447. query_alloc_block_size 16384
  448. query_cache_limit 256000
  449. query_cache_min_res_unit 4096
  450. query_cache_size 67108864
  451. query_cache_strip_comments OFF
  452. query_cache_type ON
  453. query_cache_wlock_invalidate OFF
  454. query_prealloc_size 24576
  455. range_alloc_block_size 4096
  456. read_binlog_speed_limit 0
  457. read_buffer_size 131072
  458. read_only OFF
  459. read_rnd_buffer_size 262144
  460. relay_log /mnt/binlog/relay-bin
  461. relay_log_basename /mnt/binlog/relay-bin
  462. relay_log_index /mnt/binlog/relay-bin.index
  463. relay_log_info_file relay-log.info
  464. relay_log_purge ON
  465. relay_log_recovery OFF
  466. relay_log_space_limit 0
  467. replicate_annotate_row_events ON
  468. replicate_do_db
  469. replicate_do_table
  470. replicate_events_marked_for_skip REPLICATE
  471. replicate_ignore_db
  472. replicate_ignore_table
  473. replicate_wild_do_table
  474. replicate_wild_ignore_table
  475. report_host
  476. report_password
  477. report_port 3306
  478. report_user
  479. require_secure_transport OFF
  480. rowid_merge_buff_size 8388608
  481. rpl_semi_sync_master_enabled OFF
  482. rpl_semi_sync_master_timeout 10000
  483. rpl_semi_sync_master_trace_level 32
  484. rpl_semi_sync_master_wait_no_slave ON
  485. rpl_semi_sync_master_wait_point AFTER_COMMIT
  486. rpl_semi_sync_slave_delay_master OFF
  487. rpl_semi_sync_slave_enabled OFF
  488. rpl_semi_sync_slave_kill_conn_timeout 5
  489. rpl_semi_sync_slave_trace_level 32
  490. secure_auth ON
  491. secure_file_priv
  492. secure_timestamp NO
  493. server_id 1936251580
  494. session_track_schema ON
  495. session_track_state_change OFF
  496. session_track_system_variables autocommit,character_set_client,character_set_connection,character_set_results,time_zone
  497. session_track_transaction_info OFF
  498. skip_external_locking ON
  499. skip_name_resolve OFF
  500. skip_networking OFF
  501. skip_show_database OFF
  502. slave_compressed_protocol OFF
  503. slave_ddl_exec_mode IDEMPOTENT
  504. slave_domain_parallel_threads 0
  505. slave_exec_mode STRICT
  506. slave_load_tmpdir /tmp
  507. slave_max_allowed_packet 1073741824
  508. slave_net_timeout 60
  509. slave_parallel_max_queued 131072
  510. slave_parallel_mode optimistic
  511. slave_parallel_threads 0
  512. slave_parallel_workers 0
  513. slave_run_triggers_for_rbr NO
  514. slave_skip_errors OFF
  515. slave_sql_verify_checksum OFF
  516. slave_transaction_retries 10
  517. slave_transaction_retry_errors 1158,1159,1160,1161,1205,1213,1429,2013,12701
  518. slave_transaction_retry_interval 0
  519. slave_type_conversions
  520. slow_launch_time 2
  521. slow_query_log ON
  522. slow_query_log_file /mnt/binlog/slow-queries
  523. socket /tmp/mysql.sock
  524. sort_buffer_size 2097152
  525. sql_auto_is_null OFF
  526. sql_big_selects ON
  527. sql_buffer_result OFF
  528. sql_if_exists OFF
  529. sql_log_bin ON
  530. sql_log_off OFF
  531. sql_mode NO_ENGINE_SUBSTITUTION
  532. sql_notes ON
  533. sql_quote_show_create ON
  534. sql_safe_updates OFF
  535. sql_select_limit 18446744073709551615
  536. sql_slave_skip_counter 0
  537. sql_warnings OFF
  538. ssl_ca
  539. ssl_capath
  540. ssl_cert
  541. ssl_cipher
  542. ssl_crl
  543. ssl_crlpath
  544. ssl_key
  545. standard_compliant_cte ON
  546. storage_engine InnoDB
  547. stored_program_cache 256
  548. strict_password_validation ON
  549. sync_binlog 0
  550. sync_frm ON
  551. sync_master_info 0
  552. sync_relay_log 0
  553. sync_relay_log_info 0
  554. system_time_zone UTC
  555. system_versioning_alter_history ERROR
  556. system_versioning_asof DEFAULT
  557. table_definition_cache 400
  558. table_open_cache 2000
  559. table_open_cache_instances 8
  560. tcp_keepalive_interval 0
  561. tcp_keepalive_probes 0
  562. tcp_keepalive_time 0
  563. tcp_nodelay ON
  564. thread_cache_size 16
  565. thread_handling one-thread-per-connection
  566. thread_pool_dedicated_listener OFF
  567. thread_pool_exact_stats OFF
  568. thread_pool_idle_timeout 60
  569. thread_pool_max_threads 65536
  570. thread_pool_oversubscribe 3
  571. thread_pool_prio_kickup_timer 1000
  572. thread_pool_priority auto
  573. thread_pool_size 2
  574. thread_pool_stall_limit 500
  575. thread_stack 299008
  576. time_format %H:%i:%s
  577. time_zone SYSTEM
  578. tls_version TLSv1.1,TLSv1.2,TLSv1.3
  579. tmp_disk_table_size 18446744073709551615
  580. tmp_memory_table_size 134217728
  581. tmp_table_size 134217728
  582. tmpdir /tmp
  583. transaction_alloc_block_size 8192
  584. transaction_prealloc_size 4096
  585. tx_isolation REPEATABLE-READ
  586. tx_read_only OFF
  587. unique_checks ON
  588. updatable_views_with_limit YES
  589. use_stat_tables PREFERABLY_FOR_QUERIES
  590. userstat OFF
  591. version 10.5.8-MariaDB-log
  592. version_comment MariaDB Server
  593. version_compile_machine x86_64
  594. version_compile_os Linux
  595. version_malloc_library system
  596. version_source_revision 7da6353b1558adce73320c803f0413c9bbd81185
  597. version_ssl_library OpenSSL 1.0.2k-fips 26 Jan 2017
  598. wait_timeout 31536000
  599. wsrep_osu_method TOI
  600. wsrep_sr_store table
  601. wsrep_auto_increment_control ON
  602. wsrep_causal_reads OFF
  603. wsrep_certification_rules strict
  604. wsrep_certify_nonpk ON
  605. wsrep_cluster_address
  606. wsrep_cluster_name my_wsrep_cluster
  607. wsrep_convert_lock_to_trx OFF
  608. wsrep_data_home_dir /mnt/data-dir/
  609. wsrep_dbug_option
  610. wsrep_debug NONE
  611. wsrep_desync OFF
  612. wsrep_dirty_reads OFF
  613. wsrep_drupal_282555_workaround OFF
  614. wsrep_forced_binlog_format NONE
  615. wsrep_gtid_domain_id 0
  616. wsrep_gtid_mode OFF
  617. wsrep_ignore_apply_errors 7
  618. wsrep_load_data_splitting OFF
  619. wsrep_log_conflicts OFF
  620. wsrep_max_ws_rows 0
  621. wsrep_max_ws_size 2147483647
  622. wsrep_mysql_replication_bundle 0
  623. wsrep_node_address
  624. wsrep_node_incoming_address AUTO
  625. wsrep_node_name master-server-name
  626. wsrep_notify_cmd
  627. wsrep_on OFF
  628. wsrep_patch_version wsrep_26.22
  629. wsrep_provider none
  630. wsrep_provider_options
  631. wsrep_recover OFF
  632. wsrep_reject_queries NONE
  633. wsrep_replicate_myisam OFF
  634. wsrep_restart_slave OFF
  635. wsrep_retry_autocommit 1
  636. wsrep_slave_fk_checks ON
  637. wsrep_slave_uk_checks OFF
  638. wsrep_slave_threads 1
  639. wsrep_sst_auth
  640. wsrep_sst_donor
  641. wsrep_sst_donor_rejects_queries OFF
  642. wsrep_sst_method rsync
  643. wsrep_sst_receive_address AUTO
  644. wsrep_start_position 00000000-0000-0000-0000-000000000000:-1
  645. wsrep_strict_ddl OFF
  646. wsrep_sync_wait 0
  647. wsrep_trx_fragment_size 0
  648. wsrep_trx_fragment_unit bytes
Add Comment
Please, Sign In to add comment