API tools faq
paste
belgiumwebnet

GLOBAL_VARIABLES

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