API tools faq
paste
Advertisement
clickround

show global variable

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