API tools faq
paste
Guest User

show_global_Variables

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