SHARE
TWEET

MySQL Globals - old server

a guest Apr 30th, 2019 12 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # global variables from OLD server
  2.  
  3. Variable_name   Value
  4. auto_increment_increment    1
  5. auto_increment_offset   1
  6. autocommit  ON
  7. automatic_sp_privileges ON
  8. back_log    50
  9. basedir /usr
  10. big_tables  OFF
  11. binlog_cache_size   32768
  12. binlog_direct_non_transactional_updates OFF
  13. binlog_format   STATEMENT
  14. binlog_stmt_cache_size  32768
  15. bulk_insert_buffer_size 8388608
  16. character_set_client    utf8
  17. character_set_connection    utf8
  18. character_set_database  utf8
  19. character_set_filesystem    binary
  20. character_set_results   utf8
  21. character_set_server    utf8
  22. character_set_system    utf8
  23. character_sets_dir  /usr/share/mysql/charsets/
  24. collation_connection    utf8_general_ci
  25. collation_database  utf8_general_ci
  26. collation_server    utf8_general_ci
  27. completion_type NO_CHAIN
  28. concurrent_insert   AUTO
  29. connect_timeout 10
  30. datadir /var/lib/mysql/
  31. date_format %Y-%m-%d
  32. datetime_format %Y-%m-%d %H:%i:%s
  33. default_storage_engine  MyISAM
  34. default_week_format 0
  35. delay_key_write ON
  36. delayed_insert_limit    100
  37. delayed_insert_timeout  300
  38. delayed_queue_size  1000
  39. div_precision_increment 4
  40. engine_condition_pushdown   ON
  41. event_scheduler OFF
  42. expire_logs_days    10
  43. flush   OFF
  44. flush_time  0
  45. foreign_key_checks  ON
  46. ft_boolean_syntax   + -><()~*:""&|
  47. ft_max_word_len 84
  48. ft_min_word_len 4
  49. ft_query_expansion_limit    20
  50. ft_stopword_file    (built-in)
  51. general_log OFF
  52. general_log_file    /var/log/mysql/mysql.log
  53. group_concat_max_len    1024
  54. have_compress   YES
  55. have_crypt  YES
  56. have_csv    YES
  57. have_dynamic_loading    YES
  58. have_geometry   YES
  59. have_innodb YES
  60. have_ndbcluster NO
  61. have_openssl    DISABLED
  62. have_partitioning   YES
  63. have_profiling  YES
  64. have_query_cache    YES
  65. have_rtree_keys YES
  66. have_ssl    DISABLED
  67. have_symlink    YES
  68. hostname    reactomerelease
  69. ignore_builtin_innodb   OFF
  70. init_connect    SET NAMES utf8
  71. init_file  
  72. init_slave 
  73. innodb_adaptive_flushing    ON
  74. innodb_adaptive_hash_index  ON
  75. innodb_additional_mem_pool_size 8388608
  76. innodb_autoextend_increment 8
  77. innodb_autoinc_lock_mode    1
  78. innodb_buffer_pool_instances    1
  79. innodb_buffer_pool_size 134217728
  80. innodb_change_buffering all
  81. innodb_checksums    ON
  82. innodb_commit_concurrency   0
  83. innodb_concurrency_tickets  500
  84. innodb_data_file_path   ibdata1:10M:autoextend
  85. innodb_data_home_dir   
  86. innodb_doublewrite  ON
  87. innodb_fast_shutdown    1
  88. innodb_file_format  Antelope
  89. innodb_file_format_check    ON
  90. innodb_file_format_max  Antelope
  91. innodb_file_per_table   OFF
  92. innodb_flush_log_at_trx_commit  1
  93. innodb_flush_method
  94. innodb_force_load_corrupted OFF
  95. innodb_force_recovery   0
  96. innodb_io_capacity  200
  97. innodb_large_prefix OFF
  98. innodb_lock_wait_timeout    50
  99. innodb_locks_unsafe_for_binlog  OFF
  100. innodb_log_buffer_size  8388608
  101. innodb_log_file_size    5242880
  102. innodb_log_files_in_group   2
  103. innodb_log_group_home_dir   ./
  104. innodb_max_dirty_pages_pct  75
  105. innodb_max_purge_lag    0
  106. innodb_mirrored_log_groups  1
  107. innodb_old_blocks_pct   37
  108. innodb_old_blocks_time  0
  109. innodb_open_files   300
  110. innodb_print_all_deadlocks  OFF
  111. innodb_purge_batch_size 20
  112. innodb_purge_threads    0
  113. innodb_random_read_ahead    OFF
  114. innodb_read_ahead_threshold 56
  115. innodb_read_io_threads  4
  116. innodb_replication_delay    0
  117. innodb_rollback_on_timeout  OFF
  118. innodb_rollback_segments    128
  119. innodb_spin_wait_delay  6
  120. innodb_stats_method nulls_equal
  121. innodb_stats_on_metadata    ON
  122. innodb_stats_sample_pages   8
  123. innodb_strict_mode  OFF
  124. innodb_support_xa   ON
  125. innodb_sync_spin_loops  30
  126. innodb_table_locks  ON
  127. innodb_thread_concurrency   0
  128. innodb_thread_sleep_delay   10000
  129. innodb_use_native_aio   ON
  130. innodb_use_sys_malloc   ON
  131. innodb_version  5.5.55
  132. innodb_write_io_threads 4
  133. interactive_timeout 28800
  134. join_buffer_size    131072
  135. keep_files_on_create    OFF
  136. key_buffer_size 16777216
  137. key_cache_age_threshold 300
  138. key_cache_block_size    1024
  139. key_cache_division_limit    100
  140. large_files_support ON
  141. large_page_size 0
  142. large_pages OFF
  143. lc_messages en_US
  144. lc_messages_dir /usr/share/mysql/english/
  145. lc_time_names   en_US
  146. license GPL
  147. local_infile    ON
  148. lock_wait_timeout   31536000
  149. locked_in_memory    OFF
  150. log OFF
  151. log_bin OFF
  152. log_bin_trust_function_creators OFF
  153. log_error  
  154. log_output  FILE
  155. log_queries_not_using_indexes   OFF
  156. log_slave_updates   OFF
  157. log_slow_queries    OFF
  158. log_warnings    1
  159. long_query_time 10.000000
  160. low_priority_updates    OFF
  161. lower_case_file_system  OFF
  162. lower_case_table_names  0
  163. max_allowed_packet  16777216
  164. max_binlog_cache_size   18446744073709547520
  165. max_binlog_size 104857600
  166. max_binlog_stmt_cache_size  18446744073709547520
  167. max_connect_errors  10
  168. max_connections 151
  169. max_delayed_threads 20
  170. max_error_count 64
  171. max_heap_table_size 16777216
  172. max_insert_delayed_threads  20
  173. max_join_size   18446744073709551615
  174. max_length_for_sort_data    1024
  175. max_long_data_size  16777216
  176. max_prepared_stmt_count 16382
  177. max_relay_log_size  0
  178. max_seeks_for_key   18446744073709551615
  179. max_sort_length 1024
  180. max_sp_recursion_depth  0
  181. max_tmp_tables  32
  182. max_user_connections    0
  183. max_write_lock_count    18446744073709551615
  184. metadata_locks_cache_size   1024
  185. min_examined_row_limit  0
  186. multi_range_count   256
  187. myisam_data_pointer_size    6
  188. myisam_max_sort_file_size   9223372036853727232
  189. myisam_mmap_size    18446744073709551615
  190. myisam_recover_options  BACKUP
  191. myisam_repair_threads   1
  192. myisam_sort_buffer_size 8388608
  193. myisam_stats_method nulls_unequal
  194. myisam_use_mmap OFF
  195. net_buffer_length   16384
  196. net_read_timeout    30
  197. net_retry_count 10
  198. net_write_timeout   60
  199. new OFF
  200. old OFF
  201. old_alter_table OFF
  202. old_passwords   OFF
  203. open_files_limit    1024
  204. optimizer_prune_level   1
  205. optimizer_search_depth  62
  206. optimizer_switch    index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
  207. performance_schema  OFF
  208. performance_schema_events_waits_history_long_size   10000
  209. performance_schema_events_waits_history_size    10
  210. performance_schema_max_cond_classes 80
  211. performance_schema_max_cond_instances   1000
  212. performance_schema_max_file_classes 50
  213. performance_schema_max_file_handles 32768
  214. performance_schema_max_file_instances   10000
  215. performance_schema_max_mutex_classes    200
  216. performance_schema_max_mutex_instances  1000000
  217. performance_schema_max_rwlock_classes   30
  218. performance_schema_max_rwlock_instances 1000000
  219. performance_schema_max_table_handles    100000
  220. performance_schema_max_table_instances  50000
  221. performance_schema_max_thread_classes   50
  222. performance_schema_max_thread_instances 1000
  223. pid_file    /var/run/mysqld/mysqld.pid
  224. plugin_dir  /usr/lib/mysql/plugin/
  225. port    3306
  226. preload_buffer_size 32768
  227. profiling   OFF
  228. profiling_history_size  15
  229. protocol_version    10
  230. query_alloc_block_size  8192
  231. query_cache_limit   1048576
  232. query_cache_min_res_unit    4096
  233. query_cache_size    16777216
  234. query_cache_type    ON
  235. query_cache_wlock_invalidate    OFF
  236. query_prealloc_size 8192
  237. range_alloc_block_size  4096
  238. read_buffer_size    131072
  239. read_only   OFF
  240. read_rnd_buffer_size    262144
  241. relay_log  
  242. relay_log_index
  243. relay_log_info_file relay-log.info
  244. relay_log_purge ON
  245. relay_log_recovery  OFF
  246. relay_log_space_limit   0
  247. report_host
  248. report_password
  249. report_port 3306
  250. report_user
  251. rpl_recovery_rank   0
  252. secure_auth OFF
  253. secure_file_priv    /var/lib/mysql-files/
  254. server_id   0
  255. skip_external_locking   ON
  256. skip_name_resolve   OFF
  257. skip_networking OFF
  258. skip_show_database  OFF
  259. slave_compressed_protocol   OFF
  260. slave_exec_mode STRICT
  261. slave_load_tmpdir   /tmp
  262. slave_max_allowed_packet    1073741824
  263. slave_net_timeout   3600
  264. slave_skip_errors   OFF
  265. slave_transaction_retries   10
  266. slave_type_conversions 
  267. slow_launch_time    2
  268. slow_query_log  OFF
  269. slow_query_log_file /var/lib/mysql/reactomerelease-slow.log
  270. socket  /var/run/mysqld/mysqld.sock
  271. sort_buffer_size    2097152
  272. sql_auto_is_null    OFF
  273. sql_big_selects ON
  274. sql_big_tables  OFF
  275. sql_buffer_result   OFF
  276. sql_log_bin ON
  277. sql_log_off OFF
  278. sql_low_priority_updates    OFF
  279. sql_max_join_size   18446744073709551615
  280. sql_mode   
  281. sql_notes   ON
  282. sql_quote_show_create   ON
  283. sql_safe_updates    OFF
  284. sql_select_limit    18446744073709551615
  285. sql_slave_skip_counter  0
  286. sql_warnings    OFF
  287. ssl_ca 
  288. ssl_capath 
  289. ssl_cert   
  290. ssl_cipher 
  291. ssl_key
  292. storage_engine  MyISAM
  293. stored_program_cache    256
  294. sync_binlog 0
  295. sync_frm    ON
  296. sync_master_info    0
  297. sync_relay_log  0
  298. sync_relay_log_info 0
  299. system_time_zone    EDT
  300. table_definition_cache  400
  301. table_open_cache    400
  302. thread_cache_size   8
  303. thread_concurrency  10
  304. thread_handling one-thread-per-connection
  305. thread_stack    196608
  306. time_format %H:%i:%s
  307. time_zone   SYSTEM
  308. timed_mutexes   OFF
  309. tmp_table_size  16777216
  310. tmpdir  /tmp
  311. transaction_alloc_block_size    8192
  312. transaction_prealloc_size   4096
  313. tx_isolation    REPEATABLE-READ
  314. unique_checks   ON
  315. updatable_views_with_limit  YES
  316. version 5.5.55-0+deb8u1
  317. version_comment (Debian)
  318. version_compile_machine x86_64
  319. version_compile_os  debian-linux-gnu
  320. 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