Advertisement
Guest User

Fast server

a guest
Nov 19th, 2018
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.00 KB | None | 0 0
  1. "Variable_name" "Value"
  2. "aria_block_size" "8192"
  3. "aria_checkpoint_interval" "30"
  4. "aria_checkpoint_log_activity" "1048576"
  5. "aria_encrypt_tables" "OFF"
  6. "aria_force_start_after_recovery_failures" "0"
  7. "aria_group_commit" "none"
  8. "aria_group_commit_interval" "0"
  9. "aria_log_file_size" "1073741824"
  10. "aria_log_purge_type" "immediate"
  11. "aria_max_sort_file_size" "9223372036853727232"
  12. "aria_page_checksum" "ON"
  13. "aria_pagecache_age_threshold" "300"
  14. "aria_pagecache_buffer_size" "134217728"
  15. "aria_pagecache_division_limit" "100"
  16. "aria_pagecache_file_hash_size" "512"
  17. "aria_recover" "NORMAL"
  18. "aria_repair_threads" "1"
  19. "aria_sort_buffer_size" "268434432"
  20. "aria_stats_method" "nulls_unequal"
  21. "aria_sync_log_dir" "NEWFILE"
  22. "aria_used_for_temp_tables" "ON"
  23. "auto_increment_increment" "1"
  24. "auto_increment_offset" "1"
  25. "autocommit" "ON"
  26. "automatic_sp_privileges" "ON"
  27. "back_log" "254"
  28. "basedir" "/usr"
  29. "big_tables" "OFF"
  30. "binlog_annotate_row_events" "OFF"
  31. "binlog_cache_size" "32768"
  32. "binlog_checksum" "NONE"
  33. "binlog_commit_wait_count" "0"
  34. "binlog_commit_wait_usec" "100000"
  35. "binlog_direct_non_transactional_updates" "OFF"
  36. "binlog_format" "STATEMENT"
  37. "binlog_optimize_thread_scheduling" "ON"
  38. "binlog_row_image" "FULL"
  39. "binlog_stmt_cache_size" "32768"
  40. "bulk_insert_buffer_size" "8388608"
  41. "character_set_client" "utf8"
  42. "character_set_connection" "utf8"
  43. "character_set_database" "latin1"
  44. "character_set_filesystem" "binary"
  45. "character_set_results" "utf8"
  46. "character_set_server" "latin1"
  47. "character_set_system" "utf8"
  48. "character_sets_dir" "/usr/share/mysql/charsets/"
  49. "collation_connection" "utf8_general_ci"
  50. "collation_database" "latin1_swedish_ci"
  51. "collation_server" "latin1_swedish_ci"
  52. "completion_type" "NO_CHAIN"
  53. "concurrent_insert" "AUTO"
  54. "connect_timeout" "5"
  55. "datadir" "/var/lib/mysql0/cl49/"
  56. "date_format" "%Y-%m-%d"
  57. "datetime_format" "%Y-%m-%d %H:%i:%s"
  58. "deadlock_search_depth_long" "15"
  59. "deadlock_search_depth_short" "4"
  60. "deadlock_timeout_long" "50000000"
  61. "deadlock_timeout_short" "10000"
  62. "debug_no_thread_alarm" "OFF"
  63. "default_master_connection" ""
  64. "default_regex_flags" ""
  65. "default_storage_engine" "InnoDB"
  66. "default_tmp_storage_engine" ""
  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. "div_precision_increment" "4"
  73. "encrypt_binlog" "OFF"
  74. "encrypt_tmp_disk_tables" "OFF"
  75. "encrypt_tmp_files" "OFF"
  76. "enforce_storage_engine" ""
  77. "error_count" "0"
  78. "event_scheduler" "OFF"
  79. "expensive_subquery_limit" "100"
  80. "expire_logs_days" "0"
  81. "explicit_defaults_for_timestamp" "OFF"
  82. "external_user" ""
  83. "extra_max_connections" "1"
  84. "extra_port" "0"
  85. "flush" "OFF"
  86. "flush_time" "0"
  87. "foreign_key_checks" "ON"
  88. "ft_boolean_syntax" "+ -><()~*:\"\"&|"
  89. "ft_max_word_len" "84"
  90. "ft_min_word_len" "4"
  91. "ft_query_expansion_limit" "20"
  92. "ft_stopword_file" "(built-in)"
  93. "general_log" "OFF"
  94. "general_log_file" "shareddb18.log"
  95. "group_concat_max_len" "1024"
  96. "gtid_binlog_pos" ""
  97. "gtid_binlog_state" ""
  98. "gtid_current_pos" ""
  99. "gtid_domain_id" "0"
  100. "gtid_ignore_duplicates" "OFF"
  101. "gtid_seq_no" "0"
  102. "gtid_slave_pos" ""
  103. "gtid_strict_mode" "OFF"
  104. "have_compress" "YES"
  105. "have_crypt" "YES"
  106. "have_dynamic_loading" "YES"
  107. "have_geometry" "YES"
  108. "have_openssl" "YES"
  109. "have_profiling" "YES"
  110. "have_query_cache" "YES"
  111. "have_rtree_keys" "YES"
  112. "have_ssl" "DISABLED"
  113. "have_symlink" "YES"
  114. "histogram_size" "0"
  115. "histogram_type" "SINGLE_PREC_HB"
  116. "host_cache_size" "654"
  117. "hostname" "shareddb18.hi.local"
  118. "identity" "0"
  119. "ignore_builtin_innodb" "OFF"
  120. "ignore_db_dirs" ""
  121. "in_transaction" "0"
  122. "init_connect" ""
  123. "init_file" ""
  124. "init_slave" ""
  125. "innodb_adaptive_flushing" "ON"
  126. "innodb_adaptive_flushing_lwm" "10.000000"
  127. "innodb_adaptive_hash_index" "ON"
  128. "innodb_adaptive_hash_index_partitions" "1"
  129. "innodb_adaptive_max_sleep_delay" "150000"
  130. "innodb_additional_mem_pool_size" "8388608"
  131. "innodb_api_bk_commit_interval" "5"
  132. "innodb_api_disable_rowlock" "OFF"
  133. "innodb_api_enable_binlog" "OFF"
  134. "innodb_api_enable_mdl" "OFF"
  135. "innodb_api_trx_level" "0"
  136. "innodb_autoextend_increment" "64"
  137. "innodb_autoinc_lock_mode" "1"
  138. "innodb_background_scrub_data_check_interval" "3600"
  139. "innodb_background_scrub_data_compressed" "OFF"
  140. "innodb_background_scrub_data_interval" "604800"
  141. "innodb_background_scrub_data_uncompressed" "OFF"
  142. "innodb_buf_dump_status_frequency" "0"
  143. "innodb_buffer_pool_dump_at_shutdown" "OFF"
  144. "innodb_buffer_pool_dump_now" "OFF"
  145. "innodb_buffer_pool_dump_pct" "100"
  146. "innodb_buffer_pool_filename" "ib_buffer_pool"
  147. "innodb_buffer_pool_instances" "8"
  148. "innodb_buffer_pool_load_abort" "OFF"
  149. "innodb_buffer_pool_load_at_startup" "OFF"
  150. "innodb_buffer_pool_load_now" "OFF"
  151. "innodb_buffer_pool_populate" "OFF"
  152. "innodb_buffer_pool_size" "19327352832"
  153. "innodb_change_buffer_max_size" "25"
  154. "innodb_change_buffering" "all"
  155. "innodb_checksum_algorithm" "INNODB"
  156. "innodb_checksums" "ON"
  157. "innodb_cleaner_lsn_age_factor" "HIGH_CHECKPOINT"
  158. "innodb_cmp_per_index_enabled" "OFF"
  159. "innodb_commit_concurrency" "0"
  160. "innodb_compression_algorithm" "zlib"
  161. "innodb_compression_failure_threshold_pct" "5"
  162. "innodb_compression_level" "6"
  163. "innodb_compression_pad_pct_max" "50"
  164. "innodb_concurrency_tickets" "5000"
  165. "innodb_corrupt_table_action" "assert"
  166. "innodb_data_file_path" "ibdata1:10M:autoextend:max:175G"
  167. "innodb_data_home_dir" ""
  168. "innodb_default_encryption_key_id" "1"
  169. "innodb_defragment" "OFF"
  170. "innodb_defragment_fill_factor" "0.900000"
  171. "innodb_defragment_fill_factor_n_recs" "20"
  172. "innodb_defragment_frequency" "40"
  173. "innodb_defragment_n_pages" "7"
  174. "innodb_defragment_stats_accuracy" "0"
  175. "innodb_disable_sort_file_cache" "OFF"
  176. "innodb_disallow_writes" "OFF"
  177. "innodb_doublewrite" "ON"
  178. "innodb_empty_free_list_algorithm" "BACKOFF"
  179. "innodb_encrypt_log" "OFF"
  180. "innodb_encrypt_tables" "OFF"
  181. "innodb_encryption_rotate_key_age" "1"
  182. "innodb_encryption_rotation_iops" "100"
  183. "innodb_encryption_threads" "0"
  184. "innodb_fake_changes" "OFF"
  185. "innodb_fast_shutdown" "1"
  186. "innodb_fatal_semaphore_wait_threshold" "600"
  187. "innodb_file_format" "Barracuda"
  188. "innodb_file_format_check" "ON"
  189. "innodb_file_format_max" "Antelope"
  190. "innodb_file_per_table" "OFF"
  191. "innodb_flush_log_at_timeout" "1"
  192. "innodb_flush_log_at_trx_commit" "1"
  193. "innodb_flush_method" ""
  194. "innodb_flush_neighbors" "1"
  195. "innodb_flushing_avg_loops" "30"
  196. "innodb_force_load_corrupted" "OFF"
  197. "innodb_force_primary_key" "OFF"
  198. "innodb_force_recovery" "0"
  199. "innodb_foreground_preflush" "EXPONENTIAL_BACKOFF"
  200. "innodb_ft_aux_table" ""
  201. "innodb_ft_cache_size" "8000000"
  202. "innodb_ft_enable_diag_print" "OFF"
  203. "innodb_ft_enable_stopword" "ON"
  204. "innodb_ft_max_token_size" "84"
  205. "innodb_ft_min_token_size" "3"
  206. "innodb_ft_num_word_optimize" "2000"
  207. "innodb_ft_result_cache_limit" "2000000000"
  208. "innodb_ft_server_stopword_table" ""
  209. "innodb_ft_sort_pll_degree" "2"
  210. "innodb_ft_total_cache_size" "640000000"
  211. "innodb_ft_user_stopword_table" ""
  212. "innodb_idle_flush_pct" "100"
  213. "innodb_immediate_scrub_data_uncompressed" "OFF"
  214. "innodb_instrument_semaphores" "OFF"
  215. "innodb_io_capacity" "200"
  216. "innodb_io_capacity_max" "2000"
  217. "innodb_kill_idle_transaction" "0"
  218. "innodb_large_prefix" "OFF"
  219. "innodb_lock_schedule_algorithm" "fcfs"
  220. "innodb_lock_wait_timeout" "50"
  221. "innodb_locking_fake_changes" "ON"
  222. "innodb_locks_unsafe_for_binlog" "OFF"
  223. "innodb_log_arch_dir" "./"
  224. "innodb_log_arch_expire_sec" "0"
  225. "innodb_log_archive" "OFF"
  226. "innodb_log_block_size" "512"
  227. "innodb_log_buffer_size" "16777216"
  228. "innodb_log_checksum_algorithm" "INNODB"
  229. "innodb_log_compressed_pages" "ON"
  230. "innodb_log_file_size" "268435456"
  231. "innodb_log_files_in_group" "2"
  232. "innodb_log_group_home_dir" "./"
  233. "innodb_lru_scan_depth" "1024"
  234. "innodb_max_bitmap_file_size" "104857600"
  235. "innodb_max_changed_pages" "1000000"
  236. "innodb_max_dirty_pages_pct" "75.000000"
  237. "innodb_max_dirty_pages_pct_lwm" "0.001000"
  238. "innodb_max_purge_lag" "0"
  239. "innodb_max_purge_lag_delay" "0"
  240. "innodb_mirrored_log_groups" "1"
  241. "innodb_monitor_disable" ""
  242. "innodb_monitor_enable" ""
  243. "innodb_monitor_reset" ""
  244. "innodb_monitor_reset_all" ""
  245. "innodb_mtflush_threads" "8"
  246. "innodb_old_blocks_pct" "37"
  247. "innodb_old_blocks_time" "1000"
  248. "innodb_online_alter_log_max_size" "134217728"
  249. "innodb_open_files" "300"
  250. "innodb_optimize_fulltext_only" "OFF"
  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_threads" "1"
  256. "innodb_random_read_ahead" "OFF"
  257. "innodb_read_ahead_threshold" "56"
  258. "innodb_read_io_threads" "4"
  259. "innodb_read_only" "OFF"
  260. "innodb_replication_delay" "0"
  261. "innodb_rollback_on_timeout" "OFF"
  262. "innodb_rollback_segments" "128"
  263. "innodb_sched_priority_cleaner" "19"
  264. "innodb_scrub_log" "OFF"
  265. "innodb_scrub_log_speed" "256"
  266. "innodb_show_locks_held" "10"
  267. "innodb_show_verbose_locks" "0"
  268. "innodb_simulate_comp_failures" "0"
  269. "innodb_sort_buffer_size" "1048576"
  270. "innodb_spin_wait_delay" "6"
  271. "innodb_stats_auto_recalc" "ON"
  272. "innodb_stats_include_delete_marked" "OFF"
  273. "innodb_stats_method" "nulls_equal"
  274. "innodb_stats_modified_counter" "0"
  275. "innodb_stats_on_metadata" "OFF"
  276. "innodb_stats_persistent" "ON"
  277. "innodb_stats_persistent_sample_pages" "20"
  278. "innodb_stats_sample_pages" "8"
  279. "innodb_stats_traditional" "ON"
  280. "innodb_stats_transient_sample_pages" "8"
  281. "innodb_status_output" "OFF"
  282. "innodb_status_output_locks" "OFF"
  283. "innodb_strict_mode" "OFF"
  284. "innodb_support_xa" "ON"
  285. "innodb_sync_array_size" "1"
  286. "innodb_sync_spin_loops" "30"
  287. "innodb_table_locks" "ON"
  288. "innodb_thread_concurrency" "0"
  289. "innodb_thread_sleep_delay" "10000"
  290. "innodb_tmpdir" ""
  291. "innodb_track_changed_pages" "OFF"
  292. "innodb_undo_directory" "."
  293. "innodb_undo_logs" "128"
  294. "innodb_undo_tablespaces" "0"
  295. "innodb_use_atomic_writes" "OFF"
  296. "innodb_use_fallocate" "OFF"
  297. "innodb_use_global_flush_log_at_trx_commit" "ON"
  298. "innodb_use_mtflush" "OFF"
  299. "innodb_use_native_aio" "ON"
  300. "innodb_use_stacktrace" "OFF"
  301. "innodb_use_sys_malloc" "ON"
  302. "innodb_use_trim" "OFF"
  303. "innodb_version" "5.6.36-82.2"
  304. "innodb_write_io_threads" "4"
  305. "insert_id" "0"
  306. "interactive_timeout" "1800"
  307. "join_buffer_size" "67108864"
  308. "join_buffer_space_limit" "67108864"
  309. "join_cache_level" "2"
  310. "keep_files_on_create" "OFF"
  311. "key_buffer_size" "25769803776"
  312. "key_cache_age_threshold" "300"
  313. "key_cache_block_size" "1024"
  314. "key_cache_division_limit" "100"
  315. "key_cache_file_hash_size" "512"
  316. "key_cache_segments" "0"
  317. "large_files_support" "ON"
  318. "large_page_size" "0"
  319. "large_pages" "OFF"
  320. "last_gtid" ""
  321. "last_insert_id" "0"
  322. "lc_messages" "en_US"
  323. "lc_messages_dir" ""
  324. "lc_time_names" "en_US"
  325. "license" "GPL"
  326. "local_infile" "ON"
  327. "lock_wait_timeout" "31536000"
  328. "locked_in_memory" "OFF"
  329. "log_bin" "OFF"
  330. "log_bin_basename" ""
  331. "log_bin_index" ""
  332. "log_bin_trust_function_creators" "OFF"
  333. "log_error" "/var/lib/mysql0/cl49/shareddb18.hi.local.err"
  334. "log_output" "FILE"
  335. "log_queries_not_using_indexes" "OFF"
  336. "log_slave_updates" "OFF"
  337. "log_slow_admin_statements" "OFF"
  338. "log_slow_filter" "admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk"
  339. "log_slow_rate_limit" "1"
  340. "log_slow_slave_statements" "OFF"
  341. "log_slow_verbosity" ""
  342. "log_tc_size" "24576"
  343. "log_warnings" "1"
  344. "long_query_time" "10.000000"
  345. "low_priority_updates" "OFF"
  346. "lower_case_file_system" "OFF"
  347. "lower_case_table_names" "0"
  348. "master_verify_checksum" "OFF"
  349. "max_allowed_packet" "67108864"
  350. "max_binlog_cache_size" "18446744073709547520"
  351. "max_binlog_size" "1073741824"
  352. "max_binlog_stmt_cache_size" "18446744073709547520"
  353. "max_connect_errors" "10000"
  354. "max_connections" "1024"
  355. "max_delayed_threads" "20"
  356. "max_digest_length" "1024"
  357. "max_error_count" "64"
  358. "max_heap_table_size" "536870912"
  359. "max_insert_delayed_threads" "20"
  360. "max_join_size" "18446744073709551615"
  361. "max_length_for_sort_data" "1024"
  362. "max_long_data_size" "67108864"
  363. "max_prepared_stmt_count" "16382"
  364. "max_relay_log_size" "1073741824"
  365. "max_seeks_for_key" "4294967295"
  366. "max_session_mem_used" "9223372036854775807"
  367. "max_sort_length" "1024"
  368. "max_sp_recursion_depth" "0"
  369. "max_statement_time" "0.000000"
  370. "max_tmp_tables" "32"
  371. "max_user_connections" "25"
  372. "max_write_lock_count" "4294967295"
  373. "metadata_locks_cache_size" "1024"
  374. "metadata_locks_hash_instances" "8"
  375. "min_examined_row_limit" "0"
  376. "mrr_buffer_size" "262144"
  377. "multi_range_count" "256"
  378. "myisam_block_size" "1024"
  379. "myisam_data_pointer_size" "6"
  380. "myisam_max_sort_file_size" "9223372036853727232"
  381. "myisam_mmap_size" "18446744073709551615"
  382. "myisam_recover_options" "DEFAULT"
  383. "myisam_repair_threads" "1"
  384. "myisam_sort_buffer_size" "134216704"
  385. "myisam_stats_method" "NULLS_UNEQUAL"
  386. "myisam_use_mmap" "OFF"
  387. "mysql56_temporal_format" "ON"
  388. "net_buffer_length" "16384"
  389. "net_read_timeout" "30"
  390. "net_retry_count" "10"
  391. "net_write_timeout" "60"
  392. "old" "OFF"
  393. "old_alter_table" "OFF"
  394. "old_mode" ""
  395. "old_passwords" "OFF"
  396. "open_files_limit" "786432"
  397. "optimizer_prune_level" "1"
  398. "optimizer_search_depth" "62"
  399. "optimizer_selectivity_sampling_limit" "100"
  400. "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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off"
  401. "optimizer_use_condition_selectivity" "1"
  402. "performance_schema" "OFF"
  403. "performance_schema_accounts_size" "-1"
  404. "performance_schema_digests_size" "-1"
  405. "performance_schema_events_stages_history_long_size" "-1"
  406. "performance_schema_events_stages_history_size" "-1"
  407. "performance_schema_events_statements_history_long_size" "-1"
  408. "performance_schema_events_statements_history_size" "-1"
  409. "performance_schema_events_waits_history_long_size" "-1"
  410. "performance_schema_events_waits_history_size" "-1"
  411. "performance_schema_hosts_size" "-1"
  412. "performance_schema_max_cond_classes" "80"
  413. "performance_schema_max_cond_instances" "-1"
  414. "performance_schema_max_digest_length" "1024"
  415. "performance_schema_max_file_classes" "50"
  416. "performance_schema_max_file_handles" "32768"
  417. "performance_schema_max_file_instances" "-1"
  418. "performance_schema_max_mutex_classes" "200"
  419. "performance_schema_max_mutex_instances" "-1"
  420. "performance_schema_max_rwlock_classes" "40"
  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_stage_classes" "150"
  425. "performance_schema_max_statement_classes" "178"
  426. "performance_schema_max_table_handles" "-1"
  427. "performance_schema_max_table_instances" "-1"
  428. "performance_schema_max_thread_classes" "50"
  429. "performance_schema_max_thread_instances" "-1"
  430. "performance_schema_session_connect_attrs_size" "-1"
  431. "performance_schema_setup_actors_size" "100"
  432. "performance_schema_setup_objects_size" "100"
  433. "performance_schema_users_size" "-1"
  434. "pid_file" "/var/lib/mysql0/cl49/shareddb18.hi.local.pid"
  435. "plugin_dir" "/usr/lib64/mysql/plugin/"
  436. "plugin_maturity" "unknown"
  437. "port" "10049"
  438. "preload_buffer_size" "32768"
  439. "profiling" "OFF"
  440. "profiling_history_size" "15"
  441. "progress_report_time" "5"
  442. "protocol_version" "10"
  443. "proxy_user" ""
  444. "pseudo_slave_mode" "OFF"
  445. "pseudo_thread_id" "746557879"
  446. "query_alloc_block_size" "16384"
  447. "query_cache_limit" "0"
  448. "query_cache_min_res_unit" "4096"
  449. "query_cache_size" "0"
  450. "query_cache_strip_comments" "OFF"
  451. "query_cache_type" "OFF"
  452. "query_cache_wlock_invalidate" "OFF"
  453. "query_prealloc_size" "24576"
  454. "rand_seed1" "775124117"
  455. "rand_seed2" "505115083"
  456. "range_alloc_block_size" "4096"
  457. "read_buffer_size" "131072"
  458. "read_only" "OFF"
  459. "read_rnd_buffer_size" "262144"
  460. "relay_log" ""
  461. "relay_log_basename" ""
  462. "relay_log_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" "OFF"
  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" "10049"
  478. "report_user" ""
  479. "rowid_merge_buff_size" "8388608"
  480. "secure_auth" "ON"
  481. "secure_file_priv" ""
  482. "server_id" "0"
  483. "skip_external_locking" "ON"
  484. "skip_name_resolve" "ON"
  485. "skip_networking" "OFF"
  486. "skip_parallel_replication" "OFF"
  487. "skip_replication" "OFF"
  488. "skip_show_database" "OFF"
  489. "slave_compressed_protocol" "OFF"
  490. "slave_ddl_exec_mode" "IDEMPOTENT"
  491. "slave_domain_parallel_threads" "0"
  492. "slave_exec_mode" "STRICT"
  493. "slave_load_tmpdir" "/dev/shm/cl49/"
  494. "slave_max_allowed_packet" "1073741824"
  495. "slave_net_timeout" "3600"
  496. "slave_parallel_max_queued" "131072"
  497. "slave_parallel_mode" "conservative"
  498. "slave_parallel_threads" "0"
  499. "slave_run_triggers_for_rbr" "NO"
  500. "slave_skip_errors" "OFF"
  501. "slave_sql_verify_checksum" "ON"
  502. "slave_transaction_retries" "10"
  503. "slave_type_conversions" ""
  504. "slow_launch_time" "2"
  505. "slow_query_log" "OFF"
  506. "slow_query_log_file" "shareddb18-slow.log"
  507. "socket" "/var/lib/mysql/mysql0-cluster49.sock"
  508. "sort_buffer_size" "8388608"
  509. "sql_auto_is_null" "OFF"
  510. "sql_big_selects" "ON"
  511. "sql_buffer_result" "OFF"
  512. "sql_log_bin" "ON"
  513. "sql_log_off" "OFF"
  514. "sql_mode" ""
  515. "sql_notes" "ON"
  516. "sql_quote_show_create" "ON"
  517. "sql_safe_updates" "OFF"
  518. "sql_select_limit" "18446744073709551615"
  519. "sql_slave_skip_counter" "0"
  520. "sql_warnings" "OFF"
  521. "ssl_ca" ""
  522. "ssl_capath" ""
  523. "ssl_cert" ""
  524. "ssl_cipher" ""
  525. "ssl_crl" ""
  526. "ssl_crlpath" ""
  527. "ssl_key" ""
  528. "storage_engine" "InnoDB"
  529. "stored_program_cache" "256"
  530. "strict_password_validation" "ON"
  531. "sync_binlog" "0"
  532. "sync_frm" "ON"
  533. "sync_master_info" "10000"
  534. "sync_relay_log" "10000"
  535. "sync_relay_log_info" "10000"
  536. "system_time_zone" "GMT"
  537. "table_definition_cache" "2048"
  538. "table_open_cache" "512"
  539. "thread_cache_size" "128"
  540. "thread_concurrency" "10"
  541. "thread_handling" "one-thread-per-connection"
  542. "thread_pool_idle_timeout" "60"
  543. "thread_pool_max_threads" "1000"
  544. "thread_pool_oversubscribe" "3"
  545. "thread_pool_size" "16"
  546. "thread_pool_stall_limit" "500"
  547. "thread_stack" "295936"
  548. "time_format" "%H:%i:%s"
  549. "time_zone" "SYSTEM"
  550. "timed_mutexes" "OFF"
  551. "timestamp" "1542622983.560675"
  552. "tmp_table_size" "536870912"
  553. "tmpdir" "/dev/shm/cl49/"
  554. "transaction_alloc_block_size" "8192"
  555. "transaction_prealloc_size" "4096"
  556. "tx_isolation" "REPEATABLE-READ"
  557. "tx_read_only" "OFF"
  558. "unique_checks" "ON"
  559. "updatable_views_with_limit" "YES"
  560. "use_stat_tables" "NEVER"
  561. "userstat" "OFF"
  562. "version" "10.1.27-MariaDB"
  563. "version_comment" "MariaDB Server"
  564. "version_compile_machine" "x86_64"
  565. "version_compile_os" "Linux"
  566. "version_malloc_library" "system jemalloc"
  567. "version_ssl_library" "OpenSSL 1.0.1e-fips 11 Feb 2013"
  568. "wait_timeout" "28800"
  569. "warning_count" "0"
  570. "wsrep_osu_method" "TOI"
  571. "wsrep_auto_increment_control" "ON"
  572. "wsrep_causal_reads" "OFF"
  573. "wsrep_certify_nonpk" "ON"
  574. "wsrep_cluster_address" ""
  575. "wsrep_cluster_name" "my_wsrep_cluster"
  576. "wsrep_convert_lock_to_trx" "OFF"
  577. "wsrep_data_home_dir" "/var/lib/mysql0/cl49/"
  578. "wsrep_dbug_option" ""
  579. "wsrep_debug" "OFF"
  580. "wsrep_desync" "OFF"
  581. "wsrep_dirty_reads" "OFF"
  582. "wsrep_drupal_282555_workaround" "OFF"
  583. "wsrep_forced_binlog_format" "NONE"
  584. "wsrep_gtid_domain_id" "0"
  585. "wsrep_gtid_mode" "OFF"
  586. "wsrep_load_data_splitting" "ON"
  587. "wsrep_log_conflicts" "OFF"
  588. "wsrep_max_ws_rows" "0"
  589. "wsrep_max_ws_size" "2147483647"
  590. "wsrep_mysql_replication_bundle" "0"
  591. "wsrep_node_address" ""
  592. "wsrep_node_incoming_address" "AUTO"
  593. "wsrep_node_name" "shareddb18.hi.local"
  594. "wsrep_notify_cmd" ""
  595. "wsrep_on" "OFF"
  596. "wsrep_patch_version" "wsrep_25.20"
  597. "wsrep_provider" "none"
  598. "wsrep_provider_options" ""
  599. "wsrep_recover" "OFF"
  600. "wsrep_replicate_myisam" "OFF"
  601. "wsrep_restart_slave" "OFF"
  602. "wsrep_retry_autocommit" "1"
  603. "wsrep_slave_fk_checks" "ON"
  604. "wsrep_slave_uk_checks" "OFF"
  605. "wsrep_slave_threads" "1"
  606. "wsrep_sst_auth" ""
  607. "wsrep_sst_donor" ""
  608. "wsrep_sst_donor_rejects_queries" "OFF"
  609. "wsrep_sst_method" "rsync"
  610. "wsrep_sst_receive_address" "AUTO"
  611. "wsrep_start_position" "00000000-0000-0000-0000-000000000000:-1"
  612. "wsrep_sync_wait" "0"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement