SHARE
TWEET

MySQL Globals - new server

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