API tools faq
paste
Advertisement
Guest User

MySQL Global Variables

a guest
Aug 2nd, 2022
128
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 122.04 KB | None | 0 0
raw download clone embed print report
  1.  
  2. +----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+
  3. | "Variable_name" | "Value" |
  4. +----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+
  5. | "alter_algorithm" | "DEFAULT" |
  6. | "aria_block_size" | "8192" |
  7. | "aria_checkpoint_interval" | "30" |
  8. | "aria_checkpoint_log_activity" | "1048576" |
  9. | "aria_encrypt_tables" | "OFF" |
  10. | "aria_force_start_after_recovery_failures" | "0" |
  11. | "aria_group_commit" | "none" |
  12. | "aria_group_commit_interval" | "0" |
  13. | "aria_log_file_size" | "1073741824" |
  14. | "aria_log_purge_type" | "immediate" |
  15. | "aria_max_sort_file_size" | "9223372036853727232" |
  16. | "aria_page_checksum" | "ON" |
  17. | "aria_pagecache_age_threshold" | "300" |
  18. | "aria_pagecache_buffer_size" | "134217728" |
  19. | "aria_pagecache_division_limit" | "100" |
  20. | "aria_pagecache_file_hash_size" | "512" |
  21. | "aria_recover_options" | "BACKUP,QUICK" |
  22. | "aria_repair_threads" | "1" |
  23. | "aria_sort_buffer_size" | "268434432" |
  24. | "aria_stats_method" | "nulls_unequal" |
  25. | "aria_sync_log_dir" | "NEWFILE" |
  26. | "aria_used_for_temp_tables" | "ON" |
  27. | "auto_increment_increment" | "1" |
  28. | "auto_increment_offset" | "1" |
  29. | "autocommit" | "ON" |
  30. | "automatic_sp_privileges" | "ON" |
  31. | "back_log" | "80" |
  32. | "basedir" | "/var/lib/mariadb/mysql" |
  33. | "big_tables" | "OFF" |
  34. | "bind_address" | "" |
  35. | "binlog_annotate_row_events" | "ON" |
  36. | "binlog_cache_size" | "32768" |
  37. | "binlog_checksum" | "CRC32" |
  38. | "binlog_commit_wait_count" | "0" |
  39. | "binlog_commit_wait_usec" | "100000" |
  40. | "binlog_direct_non_transactional_updates" | "OFF" |
  41. | "binlog_file_cache_size" | "16384" |
  42. | "binlog_format" | "MIXED" |
  43. | "binlog_optimize_thread_scheduling" | "ON" |
  44. | "binlog_row_image" | "FULL" |
  45. | "binlog_stmt_cache_size" | "32768" |
  46. | "bulk_insert_buffer_size" | "8388608" |
  47. | "character_set_client" | "latin1" |
  48. | "character_set_connection" | "latin1" |
  49. | "character_set_database" | "latin1" |
  50. | "character_set_filesystem" | "binary" |
  51. | "character_set_results" | "latin1" |
  52. | "character_set_server" | "latin1" |
  53. | "character_set_system" | "utf8" |
  54. | "character_sets_dir" | "/var/lib/mariadb/mariadb-10.3.34-linux-systemd-x86_64/share/charsets/" |
  55. | "check_constraint_checks" | "ON" |
  56. | "collation_connection" | "latin1_swedish_ci" |
  57. | "collation_database" | "latin1_swedish_ci" |
  58. | "collation_server" | "latin1_swedish_ci" |
  59. | "column_compression_threshold" | "100" |
  60. | "column_compression_zlib_level" | "6" |
  61. | "column_compression_zlib_strategy" | "DEFAULT_STRATEGY" |
  62. | "column_compression_zlib_wrap" | "OFF" |
  63. | "completion_type" | "NO_CHAIN" |
  64. | "concurrent_insert" | "AUTO" |
  65. | "connect_timeout" | "10" |
  66. | "core_file" | "OFF" |
  67. | "datadir" | "/var/lib/mariadb/data/" |
  68. | "date_format" | "%Y-%m-%d" |
  69. | "datetime_format" | "%Y-%m-%d %H:%i:%s" |
  70. | "deadlock_search_depth_long" | "15" |
  71. | "deadlock_search_depth_short" | "4" |
  72. | "deadlock_timeout_long" | "50000000" |
  73. | "deadlock_timeout_short" | "10000" |
  74. | "debug_no_thread_alarm" | "OFF" |
  75. | "default_regex_flags" | "" |
  76. | "default_storage_engine" | "InnoDB" |
  77. | "default_tmp_storage_engine" | "" |
  78. | "default_week_format" | "0" |
  79. | "delay_key_write" | "ON" |
  80. | "delayed_insert_limit" | "100" |
  81. | "delayed_insert_timeout" | "300" |
  82. | "delayed_queue_size" | "1000" |
  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" | "0" |
  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" | "4" |
  101. | "ft_query_expansion_limit" | "20" |
  102. | "ft_stopword_file" | "(built-in)" |
  103. | "general_log" | "OFF" |
  104. | "general_log_file" | "debian.log" |
  105. | "group_concat_max_len" | "1048576" |
  106. | "gtid_binlog_pos" | "" |
  107. | "gtid_binlog_state" | "" |
  108. | "gtid_current_pos" | "" |
  109. | "gtid_domain_id" | "0" |
  110. | "gtid_ignore_duplicates" | "OFF" |
  111. | "gtid_pos_auto_engines" | "" |
  112. | "gtid_slave_pos" | "" |
  113. | "gtid_strict_mode" | "OFF" |
  114. | "have_compress" | "YES" |
  115. | "have_crypt" | "YES" |
  116. | "have_dynamic_loading" | "YES" |
  117. | "have_geometry" | "YES" |
  118. | "have_openssl" | "NO" |
  119. | "have_profiling" | "YES" |
  120. | "have_query_cache" | "YES" |
  121. | "have_rtree_keys" | "YES" |
  122. | "have_ssl" | "DISABLED" |
  123. | "have_symlink" | "YES" |
  124. | "histogram_size" | "0" |
  125. | "histogram_type" | "SINGLE_PREC_HB" |
  126. | "host_cache_size" | "279" |
  127. | "hostname" | "debian" |
  128. | "idle_readonly_transaction_timeout" | "0" |
  129. | "idle_transaction_timeout" | "0" |
  130. | "idle_write_transaction_timeout" | "0" |
  131. | "ignore_builtin_innodb" | "OFF" |
  132. | "ignore_db_dirs" | "" |
  133. | "in_predicate_conversion_threshold" | "1000" |
  134. | "init_connect" | "" |
  135. | "init_file" | "" |
  136. | "init_slave" | "" |
  137. | "innodb_adaptive_flushing" | "ON" |
  138. | "innodb_adaptive_flushing_lwm" | "10.000000" |
  139. | "innodb_adaptive_hash_index" | "ON" |
  140. | "innodb_adaptive_hash_index_parts" | "8" |
  141. | "innodb_adaptive_max_sleep_delay" | "150000" |
  142. | "innodb_autoextend_increment" | "64" |
  143. | "innodb_autoinc_lock_mode" | "1" |
  144. | "innodb_background_scrub_data_check_interval" | "3600" |
  145. | "innodb_background_scrub_data_compressed" | "OFF" |
  146. | "innodb_background_scrub_data_interval" | "604800" |
  147. | "innodb_background_scrub_data_uncompressed" | "OFF" |
  148. | "innodb_buf_dump_status_frequency" | "0" |
  149. | "innodb_buffer_pool_chunk_size" | "134217728" |
  150. | "innodb_buffer_pool_dump_at_shutdown" | "ON" |
  151. | "innodb_buffer_pool_dump_now" | "OFF" |
  152. | "innodb_buffer_pool_dump_pct" | "25" |
  153. | "innodb_buffer_pool_filename" | "ib_buffer_pool" |
  154. | "innodb_buffer_pool_instances" | "8" |
  155. | "innodb_buffer_pool_load_abort" | "OFF" |
  156. | "innodb_buffer_pool_load_at_startup" | "ON" |
  157. | "innodb_buffer_pool_load_now" | "OFF" |
  158. | "innodb_buffer_pool_size" | "10737418240" |
  159. | "innodb_change_buffer_max_size" | "50" |
  160. | "innodb_change_buffering" | "all" |
  161. | "innodb_checksum_algorithm" | "crc32" |
  162. | "innodb_checksums" | "ON" |
  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" | "5000" |
  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" | "1" |
  198. | "innodb_flush_method" | "O_DIRECT" |
  199. | "innodb_flush_neighbors" | "2" |
  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_last" |
  220. | "innodb_io_capacity" | "500" |
  221. | "innodb_io_capacity_max" | "2000" |
  222. | "innodb_large_prefix" | "" |
  223. | "innodb_lock_schedule_algorithm" | "fcfs" |
  224. | "innodb_lock_wait_timeout" | "50" |
  225. | "innodb_locks_unsafe_for_binlog" | "OFF" |
  226. | "innodb_log_buffer_size" | "3221225472" |
  227. | "innodb_log_checksums" | "ON" |
  228. | "innodb_log_compressed_pages" | "ON" |
  229. | "innodb_log_file_size" | "5368709120" |
  230. | "innodb_log_files_in_group" | "2" |
  231. | "innodb_log_group_home_dir" | "./" |
  232. | "innodb_log_optimize_ddl" | "OFF" |
  233. | "innodb_log_write_ahead_size" | "8192" |
  234. | "innodb_lru_scan_depth" | "100" |
  235. | "innodb_max_dirty_pages_pct" | "75.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" | "4" |
  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" | "16" |
  260. | "innodb_read_only" | "OFF" |
  261. | "innodb_replication_delay" | "0" |
  262. | "innodb_rollback_on_timeout" | "OFF" |
  263. | "innodb_rollback_segments" | "128" |
  264. | "innodb_scrub_log" | "OFF" |
  265. | "innodb_scrub_log_speed" | "256" |
  266. | "innodb_sort_buffer_size" | "1048576" |
  267. | "innodb_spin_wait_delay" | "4" |
  268. | "innodb_stats_auto_recalc" | "ON" |
  269. | "innodb_stats_include_delete_marked" | "OFF" |
  270. | "innodb_stats_method" | "nulls_equal" |
  271. | "innodb_stats_modified_counter" | "0" |
  272. | "innodb_stats_on_metadata" | "OFF" |
  273. | "innodb_stats_persistent" | "ON" |
  274. | "innodb_stats_persistent_sample_pages" | "20" |
  275. | "innodb_stats_sample_pages" | "8" |
  276. | "innodb_stats_traditional" | "ON" |
  277. | "innodb_stats_transient_sample_pages" | "8" |
  278. | "innodb_status_output" | "OFF" |
  279. | "innodb_status_output_locks" | "OFF" |
  280. | "innodb_strict_mode" | "ON" |
  281. | "innodb_sync_array_size" | "1" |
  282. | "innodb_sync_spin_loops" | "30" |
  283. | "innodb_table_locks" | "ON" |
  284. | "innodb_temp_data_file_path" | "ibtmp1:12M:autoextend" |
  285. | "innodb_thread_concurrency" | "4" |
  286. | "innodb_thread_sleep_delay" | "0" |
  287. | "innodb_tmpdir" | "" |
  288. | "innodb_undo_directory" | "./" |
  289. | "innodb_undo_log_truncate" | "OFF" |
  290. | "innodb_undo_logs" | "128" |
  291. | "innodb_undo_tablespaces" | "0" |
  292. | "innodb_use_atomic_writes" | "ON" |
  293. | "innodb_use_native_aio" | "ON" |
  294. | "innodb_version" | "10.3.34" |
  295. | "innodb_write_io_threads" | "16" |
  296. | "interactive_timeout" | "28800" |
  297. | "join_buffer_size" | "262144" |
  298. | "join_buffer_space_limit" | "2097152" |
  299. | "join_cache_level" | "2" |
  300. | "keep_files_on_create" | "OFF" |
  301. | "key_buffer_size" | "134217728" |
  302. | "key_cache_age_threshold" | "300" |
  303. | "key_cache_block_size" | "1024" |
  304. | "key_cache_division_limit" | "100" |
  305. | "key_cache_file_hash_size" | "512" |
  306. | "key_cache_segments" | "0" |
  307. | "large_files_support" | "ON" |
  308. | "large_page_size" | "0" |
  309. | "large_pages" | "OFF" |
  310. | "lc_messages" | "en_US" |
  311. | "lc_messages_dir" | "" |
  312. | "lc_time_names" | "en_US" |
  313. | "license" | "GPL" |
  314. | "local_infile" | "ON" |
  315. | "lock_wait_timeout" | "86400" |
  316. | "locked_in_memory" | "OFF" |
  317. | "log_bin" | "OFF" |
  318. | "log_bin_basename" | "" |
  319. | "log_bin_compress" | "OFF" |
  320. | "log_bin_compress_min_len" | "256" |
  321. | "log_bin_index" | "" |
  322. | "log_bin_trust_function_creators" | "OFF" |
  323. | "log_disabled_statements" | "sp" |
  324. | "log_error" | "/var/lib/mariadb/data/debian.err" |
  325. | "log_output" | "FILE" |
  326. | "log_queries_not_using_indexes" | "OFF" |
  327. | "log_slave_updates" | "OFF" |
  328. | "log_slow_admin_statements" | "ON" |
  329. | "log_slow_disabled_statements" | "sp" |
  330. | "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" |
  331. | "log_slow_rate_limit" | "1" |
  332. | "log_slow_slave_statements" | "ON" |
  333. | "log_slow_verbosity" | "" |
  334. | "log_tc_size" | "24576" |
  335. | "log_warnings" | "2" |
  336. | "long_query_time" | "10.000000" |
  337. | "low_priority_updates" | "OFF" |
  338. | "lower_case_file_system" | "OFF" |
  339. | "lower_case_table_names" | "0" |
  340. | "master_verify_checksum" | "OFF" |
  341. | "max_allowed_packet" | "16777216" |
  342. | "max_binlog_cache_size" | "18446744073709547520" |
  343. | "max_binlog_size" | "1073741824" |
  344. | "max_binlog_stmt_cache_size" | "18446744073709547520" |
  345. | "max_connect_errors" | "100" |
  346. | "max_connections" | "151" |
  347. | "max_delayed_threads" | "20" |
  348. | "max_digest_length" | "1024" |
  349. | "max_error_count" | "64" |
  350. | "max_heap_table_size" | "16777216" |
  351. | "max_insert_delayed_threads" | "20" |
  352. | "max_join_size" | "18446744073709551615" |
  353. | "max_length_for_sort_data" | "1024" |
  354. | "max_long_data_size" | "16777216" |
  355. | "max_prepared_stmt_count" | "16382" |
  356. | "max_recursive_iterations" | "4294967295" |
  357. | "max_relay_log_size" | "1073741824" |
  358. | "max_seeks_for_key" | "4294967295" |
  359. | "max_session_mem_used" | "9223372036854775807" |
  360. | "max_sort_length" | "1024" |
  361. | "max_sp_recursion_depth" | "0" |
  362. | "max_statement_time" | "0.000000" |
  363. | "max_tmp_tables" | "32" |
  364. | "max_user_connections" | "0" |
  365. | "max_write_lock_count" | "4294967295" |
  366. | "metadata_locks_cache_size" | "1024" |
  367. | "metadata_locks_hash_instances" | "8" |
  368. | "min_examined_row_limit" | "0" |
  369. | "mrr_buffer_size" | "262144" |
  370. | "multi_range_count" | "256" |
  371. | "myisam_block_size" | "1024" |
  372. | "myisam_data_pointer_size" | "6" |
  373. | "myisam_max_sort_file_size" | "9223372036853727232" |
  374. | "myisam_mmap_size" | "18446744073709551615" |
  375. | "myisam_recover_options" | "BACKUP,QUICK" |
  376. | "myisam_repair_threads" | "1" |
  377. | "myisam_sort_buffer_size" | "134216704" |
  378. | "myisam_stats_method" | "NULLS_UNEQUAL" |
  379. | "myisam_use_mmap" | "OFF" |
  380. | "mysql56_temporal_format" | "ON" |
  381. | "net_buffer_length" | "16384" |
  382. | "net_read_timeout" | "30" |
  383. | "net_retry_count" | "10" |
  384. | "net_write_timeout" | "60" |
  385. | "old" | "OFF" |
  386. | "old_alter_table" | "DEFAULT" |
  387. | "old_mode" | "" |
  388. | "old_passwords" | "OFF" |
  389. | "open_files_limit" | "32214" |
  390. | "optimizer_prune_level" | "1" |
  391. | "optimizer_search_depth" | "62" |
  392. | "optimizer_selectivity_sampling_limit" | "100" |
  393. | "optimizer_use_condition_selectivity" | "1" |
  394. | "performance_schema" | "OFF" |
  395. | "performance_schema_accounts_size" | "-1" |
  396. | "performance_schema_digests_size" | "-1" |
  397. | "performance_schema_events_stages_history_long_size" | "-1" |
  398. | "performance_schema_events_stages_history_size" | "-1" |
  399. | "performance_schema_events_statements_history_long_size" | "-1" |
  400. | "performance_schema_events_statements_history_size" | "-1" |
  401. | "performance_schema_events_waits_history_long_size" | "-1" |
  402. | "performance_schema_events_waits_history_size" | "-1" |
  403. | "performance_schema_hosts_size" | "-1" |
  404. | "performance_schema_max_cond_classes" | "80" |
  405. | "performance_schema_max_cond_instances" | "-1" |
  406. | "performance_schema_max_digest_length" | "1024" |
  407. | "performance_schema_max_file_classes" | "50" |
  408. | "performance_schema_max_file_handles" | "32768" |
  409. | "performance_schema_max_file_instances" | "-1" |
  410. | "performance_schema_max_mutex_classes" | "200" |
  411. | "performance_schema_max_mutex_instances" | "-1" |
  412. | "performance_schema_max_rwlock_classes" | "40" |
  413. | "performance_schema_max_rwlock_instances" | "-1" |
  414. | "performance_schema_max_socket_classes" | "10" |
  415. | "performance_schema_max_socket_instances" | "-1" |
  416. | "performance_schema_max_stage_classes" | "160" |
  417. | "performance_schema_max_statement_classes" | "200" |
  418. | "performance_schema_max_table_handles" | "-1" |
  419. | "performance_schema_max_table_instances" | "-1" |
  420. | "performance_schema_max_thread_classes" | "50" |
  421. | "performance_schema_max_thread_instances" | "-1" |
  422. | "performance_schema_session_connect_attrs_size" | "-1" |
  423. | "performance_schema_setup_actors_size" | "100" |
  424. | "performance_schema_setup_objects_size" | "100" |
  425. | "performance_schema_users_size" | "-1" |
  426. | "pid_file" | "/var/lib/mariadb/data/debian.pid" |
  427. | "plugin_dir" | "/var/lib/mariadb/mysql/lib/plugin/" |
  428. | "plugin_maturity" | "gamma" |
  429. | "port" | "3306" |
  430. | "preload_buffer_size" | "32768" |
  431. | "profiling" | "OFF" |
  432. | "profiling_history_size" | "15" |
  433. | "progress_report_time" | "5" |
  434. | "protocol_version" | "10" |
  435. | "proxy_protocol_networks" | "" |
  436. | "query_alloc_block_size" | "16384" |
  437. | "query_cache_limit" | "1048576" |
  438. | "query_cache_min_res_unit" | "4096" |
  439. | "query_cache_size" | "1048576" |
  440. | "query_cache_strip_comments" | "OFF" |
  441. | "query_cache_type" | "OFF" |
  442. | "query_cache_wlock_invalidate" | "OFF" |
  443. | "query_prealloc_size" | "24576" |
  444. | "range_alloc_block_size" | "4096" |
  445. | "read_binlog_speed_limit" | "0" |
  446. | "read_buffer_size" | "262144" |
  447. | "read_only" | "OFF" |
  448. | "read_rnd_buffer_size" | "32768" |
  449. | "relay_log" | "" |
  450. | "relay_log_basename" | "" |
  451. | "relay_log_index" | "" |
  452. | "relay_log_info_file" | "relay-log.info" |
  453. | "relay_log_purge" | "ON" |
  454. | "relay_log_recovery" | "OFF" |
  455. | "relay_log_space_limit" | "0" |
  456. | "replicate_annotate_row_events" | "ON" |
  457. | "replicate_do_db" | "" |
  458. | "replicate_do_table" | "" |
  459. | "replicate_events_marked_for_skip" | "REPLICATE" |
  460. | "replicate_ignore_db" | "" |
  461. | "replicate_ignore_table" | "" |
  462. | "replicate_wild_do_table" | "" |
  463. | "replicate_wild_ignore_table" | "" |
  464. | "report_host" | "" |
  465. | "report_password" | "" |
  466. | "report_port" | "3306" |
  467. | "report_user" | "" |
  468. | "rowid_merge_buff_size" | "8388608" |
  469. | "rpl_semi_sync_master_enabled" | "OFF" |
  470. | "rpl_semi_sync_master_timeout" | "10000" |
  471. | "rpl_semi_sync_master_trace_level" | "32" |
  472. | "rpl_semi_sync_master_wait_no_slave" | "ON" |
  473. | "rpl_semi_sync_master_wait_point" | "AFTER_COMMIT" |
  474. | "rpl_semi_sync_slave_delay_master" | "OFF" |
  475. | "rpl_semi_sync_slave_enabled" | "OFF" |
  476. | "rpl_semi_sync_slave_kill_conn_timeout" | "5" |
  477. | "rpl_semi_sync_slave_trace_level" | "32" |
  478. | "secure_auth" | "ON" |
  479. | "secure_file_priv" | "" |
  480. | "secure_timestamp" | "NO" |
  481. | "server_id" | "1" |
  482. | "session_track_schema" | "ON" |
  483. | "session_track_state_change" | "OFF" |
  484. | "session_track_system_variables" | "autocommit,character_set_client,character_set_connection,character_set_results,time_zone" |
  485. | "session_track_transaction_info" | "OFF" |
  486. | "skip_external_locking" | "ON" |
  487. | "skip_name_resolve" | "OFF" |
  488. | "skip_networking" | "OFF" |
  489. | "skip_show_database" | "OFF" |
  490. | "slave_compressed_protocol" | "OFF" |
  491. | "slave_ddl_exec_mode" | "IDEMPOTENT" |
  492. | "slave_domain_parallel_threads" | "0" |
  493. | "slave_exec_mode" | "STRICT" |
  494. | "slave_load_tmpdir" | "/tmp" |
  495. | "slave_max_allowed_packet" | "1073741824" |
  496. | "slave_net_timeout" | "60" |
  497. | "slave_parallel_max_queued" | "131072" |
  498. | "slave_parallel_mode" | "conservative" |
  499. | "slave_parallel_threads" | "0" |
  500. | "slave_parallel_workers" | "0" |
  501. | "slave_run_triggers_for_rbr" | "NO" |
  502. | "slave_skip_errors" | "OFF" |
  503. | "slave_sql_verify_checksum" | "ON" |
  504. | "slave_transaction_retries" | "10" |
  505. | "slave_transaction_retry_errors" | "1213,1205" |
  506. | "slave_transaction_retry_interval" | "0" |
  507. | "slave_type_conversions" | "" |
  508. | "slow_launch_time" | "2" |
  509. | "slow_query_log" | "OFF" |
  510. | "slow_query_log_file" | "debian-slow.log" |
  511. | "socket" | "/tmp/mysql.sock" |
  512. | "sort_buffer_size" | "2097152" |
  513. | "sql_auto_is_null" | "OFF" |
  514. | "sql_big_selects" | "ON" |
  515. | "sql_buffer_result" | "OFF" |
  516. | "sql_log_bin" | "ON" |
  517. | "sql_log_off" | "OFF" |
  518. | "sql_mode" | "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" |
  519. | "sql_notes" | "ON" |
  520. | "sql_quote_show_create" | "ON" |
  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_key" | "" |
  532. | "standard_compliant_cte" | "ON" |
  533. | "storage_engine" | "InnoDB" |
  534. | "stored_program_cache" | "256" |
  535. | "strict_password_validation" | "ON" |
  536. | "sync_binlog" | "0" |
  537. | "sync_frm" | "ON" |
  538. | "sync_master_info" | "10000" |
  539. | "sync_relay_log" | "10000" |
  540. | "sync_relay_log_info" | "10000" |
  541. | "system_time_zone" | "CEST" |
  542. | "system_versioning_alter_history" | "ERROR" |
  543. | "system_versioning_asof" | "DEFAULT" |
  544. | "table_definition_cache" | "400" |
  545. | "table_open_cache" | "2000" |
  546. | "table_open_cache_instances" | "8" |
  547. | "tcp_keepalive_interval" | "0" |
  548. | "tcp_keepalive_probes" | "0" |
  549. | "tcp_keepalive_time" | "0" |
  550. | "thread_cache_size" | "151" |
  551. | "thread_concurrency" | "10" |
  552. | "thread_handling" | "one-thread-per-connection" |
  553. | "thread_pool_idle_timeout" | "60" |
  554. | "thread_pool_max_threads" | "65536" |
  555. | "thread_pool_oversubscribe" | "3" |
  556. | "thread_pool_prio_kickup_timer" | "1000" |
  557. | "thread_pool_priority" | "auto" |
  558. | "thread_pool_size" | "32" |
  559. | "thread_pool_stall_limit" | "500" |
  560. | "thread_stack" | "299008" |
  561. | "time_format" | "%H:%i:%s" |
  562. | "time_zone" | "SYSTEM" |
  563. | "timed_mutexes" | "OFF" |
  564. | "tmp_disk_table_size" | "18446744073709551615" |
  565. | "tmp_memory_table_size" | "16777216" |
  566. | "tmp_table_size" | "16777216" |
  567. | "tmpdir" | "/tmp" |
  568. | "transaction_alloc_block_size" | "8192" |
  569. | "transaction_prealloc_size" | "4096" |
  570. | "tx_isolation" | "REPEATABLE-READ" |
  571. | "tx_read_only" | "OFF" |
  572. | "unique_checks" | "ON" |
  573. | "updatable_views_with_limit" | "YES" |
  574. | "use_stat_tables" | "NEVER" |
  575. | "userstat" | "OFF" |
  576. | "version" | "10.3.34-MariaDB" |
  577. | "version_comment" | "MariaDB Server" |
  578. | "version_compile_machine" | "x86_64" |
  579. | "version_compile_os" | "linux-systemd" |
  580. | "version_malloc_library" | "system" |
  581. | "version_source_revision" | "a36fc80aeb3f835fad02f443d65dc608b74b92d1" |
  582. | "version_ssl_library" | "YaSSL 2.4.4" |
  583. | "wait_timeout" | "28800" |
  584. | "wsrep_osu_method" | "TOI" |
  585. | "wsrep_auto_increment_control" | "ON" |
  586. | "wsrep_causal_reads" | "OFF" |
  587. | "wsrep_certification_rules" | "strict" |
  588. | "wsrep_certify_nonpk" | "ON" |
  589. | "wsrep_cluster_address" | "" |
  590. | "wsrep_cluster_name" | "my_wsrep_cluster" |
  591. | "wsrep_convert_lock_to_trx" | "OFF" |
  592. | "wsrep_data_home_dir" | "/var/lib/mariadb/data/" |
  593. | "wsrep_dbug_option" | "" |
  594. | "wsrep_debug" | "OFF" |
  595. | "wsrep_desync" | "OFF" |
  596. | "wsrep_dirty_reads" | "OFF" |
  597. | "wsrep_drupal_282555_workaround" | "OFF" |
  598. | "wsrep_forced_binlog_format" | "NONE" |
  599. | "wsrep_gtid_domain_id" | "0" |
  600. | "wsrep_gtid_mode" | "OFF" |
  601. | "wsrep_load_data_splitting" | "ON" |
  602. | "wsrep_log_conflicts" | "OFF" |
  603. | "wsrep_max_ws_rows" | "0" |
  604. | "wsrep_max_ws_size" | "2147483647" |
  605. | "wsrep_mysql_replication_bundle" | "0" |
  606. | "wsrep_node_address" | "" |
  607. | "wsrep_node_incoming_address" | "AUTO" |
  608. | "wsrep_node_name" | "debian" |
  609. | "wsrep_notify_cmd" | "" |
  610. | "wsrep_on" | "OFF" |
  611. | "wsrep_patch_version" | "wsrep_25.24" |
  612. | "wsrep_provider" | "none" |
  613. | "wsrep_provider_options" | "" |
  614. | "wsrep_recover" | "OFF" |
  615. | "wsrep_reject_queries" | "NONE" |
  616. | "wsrep_replicate_myisam" | "OFF" |
  617. | "wsrep_restart_slave" | "OFF" |
  618. | "wsrep_retry_autocommit" | "1" |
  619. | "wsrep_slave_fk_checks" | "ON" |
  620. | "wsrep_slave_uk_checks" | "OFF" |
  621. | "wsrep_slave_threads" | "1" |
  622. | "wsrep_sst_auth" | "" |
  623. | "wsrep_sst_donor" | "" |
  624. | "wsrep_sst_donor_rejects_queries" | "OFF" |
  625. | "wsrep_sst_method" | "rsync" |
  626. | "wsrep_sst_receive_address" | "AUTO" |
  627. | "wsrep_start_position" | "00000000-0000-0000-0000-000000000000:-1" |
  628. | "wsrep_sync_wait" | "0" |
  629. +----------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!