API tools faq
paste
Advertisement
Guest User

MySQL Globals - new server

a guest
Apr 30th, 2019
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.12 KB | None | 0 0
raw download clone embed print report
  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
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!