Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.92 KB | None | 0 0
  1. Variable_name Value
  2. auto_increment_increment 1
  3. auto_increment_offset 1
  4. autocommit ON
  5. automatic_sp_privileges ON
  6. back_log 200
  7. basedir /usr
  8. big_tables OFF
  9. bind_address *
  10. binlog_cache_size 32768
  11. binlog_checksum CRC32
  12. binlog_direct_non_transactional_updates OFF
  13. binlog_format ROW
  14. binlog_max_flush_queue_time 0
  15. binlog_order_commits ON
  16. binlog_row_image FULL
  17. binlog_rows_query_log_events OFF
  18. binlog_stmt_cache_size 32768
  19. block_encryption_mode aes-128-ecb
  20. bulk_insert_buffer_size 8388608
  21. character_set_client utf8
  22. character_set_connection utf8
  23. character_set_database latin1
  24. character_set_filesystem binary
  25. character_set_results utf8
  26. character_set_server latin1
  27. character_set_system utf8
  28. character_sets_dir /usr/share/mysql/charsets/
  29. collation_connection utf8_general_ci
  30. collation_database latin1_swedish_ci
  31. collation_server latin1_swedish_ci
  32. completion_type NO_CHAIN
  33. concurrent_insert AUTO
  34. connect_timeout 10
  35. core_file OFF
  36. datadir /var/lib/mysql/
  37. date_format %Y-%m-%d
  38. datetime_format %Y-%m-%d %H:%i:%s
  39. default_storage_engine InnoDB
  40. default_tmp_storage_engine InnoDB
  41. default_week_format 0
  42. delay_key_write ON
  43. delayed_insert_limit 100
  44. delayed_insert_timeout 300
  45. delayed_queue_size 1000
  46. disconnect_on_expired_password ON
  47. div_precision_increment 4
  48. end_markers_in_json OFF
  49. enforce_gtid_consistency ON
  50. eq_range_index_dive_limit 10
  51. error_count 0
  52. event_scheduler OFF
  53. expire_logs_days 0
  54. explicit_defaults_for_timestamp OFF
  55. external_user
  56. flush OFF
  57. flush_time 0
  58. foreign_key_checks ON
  59. ft_boolean_syntax + -><()~*:""&|
  60. ft_max_word_len 84
  61. ft_min_word_len 4
  62. ft_query_expansion_limit 20
  63. ft_stopword_file (built-in)
  64. general_log OFF
  65. general_log_file /var/lib/mysql/xxxx.log
  66. group_concat_max_len 1024
  67. gtid_executed
  68. gtid_mode ON
  69. gtid_next AUTOMATIC
  70. gtid_owned
  71. gtid_purged
  72. have_compress YES
  73. have_crypt YES
  74. have_dynamic_loading YES
  75. have_geometry YES
  76. have_openssl DISABLED
  77. have_profiling YES
  78. have_query_cache YES
  79. have_rtree_keys YES
  80. have_ssl DISABLED
  81. have_symlink DISABLED
  82. host_cache_size 640
  83. hostname xxxx
  84. identity 0
  85. ignore_builtin_innodb OFF
  86. ignore_db_dirs
  87. init_connect
  88. init_file
  89. init_slave
  90. innodb_adaptive_flushing ON
  91. innodb_adaptive_flushing_lwm 10
  92. innodb_adaptive_hash_index ON
  93. innodb_adaptive_max_sleep_delay 150000
  94. innodb_additional_mem_pool_size 8388608
  95. innodb_api_bk_commit_interval 5
  96. innodb_api_disable_rowlock OFF
  97. innodb_api_enable_binlog OFF
  98. innodb_api_enable_mdl OFF
  99. innodb_api_trx_level 0
  100. innodb_autoextend_increment 64
  101. innodb_autoinc_lock_mode 1
  102. innodb_buffer_pool_dump_at_shutdown OFF
  103. innodb_buffer_pool_dump_now OFF
  104. innodb_buffer_pool_filename ib_buffer_pool
  105. innodb_buffer_pool_instances 8
  106. innodb_buffer_pool_load_abort OFF
  107. innodb_buffer_pool_load_at_startup OFF
  108. innodb_buffer_pool_load_now OFF
  109. innodb_buffer_pool_size 42949672960
  110. innodb_change_buffer_max_size 25
  111. innodb_change_buffering all
  112. innodb_checksum_algorithm innodb
  113. innodb_checksums ON
  114. innodb_cmp_per_index_enabled OFF
  115. innodb_commit_concurrency 0
  116. innodb_compression_failure_threshold_pct 5
  117. innodb_compression_level 6
  118. innodb_compression_pad_pct_max 50
  119. innodb_concurrency_tickets 5000
  120. innodb_data_file_path ibdata1:12M:autoextend
  121. innodb_data_home_dir
  122. innodb_disable_sort_file_cache OFF
  123. innodb_doublewrite OFF
  124. innodb_fast_shutdown 1
  125. innodb_file_format Antelope
  126. innodb_file_format_check ON
  127. innodb_file_format_max Antelope
  128. innodb_file_per_table ON
  129. innodb_flush_log_at_timeout 1
  130. innodb_flush_log_at_trx_commit 2
  131. innodb_flush_method O_DIRECT
  132. innodb_flush_neighbors 0
  133. innodb_flushing_avg_loops 30
  134. innodb_force_load_corrupted OFF
  135. innodb_force_recovery 0
  136. innodb_ft_aux_table
  137. innodb_ft_cache_size 8000000
  138. innodb_ft_enable_diag_print OFF
  139. innodb_ft_enable_stopword ON
  140. innodb_ft_max_token_size 84
  141. innodb_ft_min_token_size 3
  142. innodb_ft_num_word_optimize 2000
  143. innodb_ft_result_cache_limit 2000000000
  144. innodb_ft_server_stopword_table
  145. innodb_ft_sort_pll_degree 2
  146. innodb_ft_total_cache_size 640000000
  147. innodb_ft_user_stopword_table
  148. innodb_io_capacity 200
  149. innodb_io_capacity_max 2000
  150. innodb_large_prefix OFF
  151. innodb_lock_wait_timeout 50
  152. innodb_locks_unsafe_for_binlog OFF
  153. innodb_log_buffer_size 8388608
  154. innodb_log_compressed_pages ON
  155. innodb_log_file_size 104857600
  156. innodb_log_files_in_group 2
  157. innodb_log_group_home_dir ./
  158. innodb_lru_scan_depth 1024
  159. innodb_max_dirty_pages_pct 75
  160. innodb_max_dirty_pages_pct_lwm 0
  161. innodb_max_purge_lag 0
  162. innodb_max_purge_lag_delay 0
  163. innodb_mirrored_log_groups 1
  164. innodb_monitor_disable
  165. innodb_monitor_enable
  166. innodb_monitor_reset
  167. innodb_monitor_reset_all
  168. innodb_old_blocks_pct 37
  169. innodb_old_blocks_time 1000
  170. innodb_online_alter_log_max_size 134217728
  171. innodb_open_files 2000
  172. innodb_optimize_fulltext_only OFF
  173. innodb_page_size 16384
  174. innodb_print_all_deadlocks OFF
  175. innodb_purge_batch_size 300
  176. innodb_purge_threads 1
  177. innodb_random_read_ahead OFF
  178. innodb_read_ahead_threshold 56
  179. innodb_read_io_threads 16
  180. innodb_read_only OFF
  181. innodb_replication_delay 0
  182. innodb_rollback_on_timeout OFF
  183. innodb_rollback_segments 128
  184. innodb_sort_buffer_size 1048576
  185. innodb_spin_wait_delay 6
  186. innodb_stats_auto_recalc ON
  187. innodb_stats_method nulls_equal
  188. innodb_stats_on_metadata OFF
  189. innodb_stats_persistent ON
  190. innodb_stats_persistent_sample_pages 20
  191. innodb_stats_sample_pages 8
  192. innodb_stats_transient_sample_pages 8
  193. innodb_status_output OFF
  194. innodb_status_output_locks OFF
  195. innodb_strict_mode OFF
  196. innodb_support_xa ON
  197. innodb_sync_array_size 1
  198. innodb_sync_spin_loops 30
  199. innodb_table_locks ON
  200. innodb_thread_concurrency 0
  201. innodb_thread_sleep_delay 10000
  202. innodb_undo_directory .
  203. innodb_undo_logs 128
  204. innodb_undo_tablespaces 0
  205. innodb_use_native_aio ON
  206. innodb_use_sys_malloc ON
  207. innodb_version 5.6.19
  208. innodb_write_io_threads 16
  209. insert_id 0
  210. interactive_timeout 28800
  211. join_buffer_size 262144
  212. keep_files_on_create OFF
  213. key_buffer_size 8388608
  214. key_cache_age_threshold 300
  215. key_cache_block_size 1024
  216. key_cache_division_limit 100
  217. large_files_support ON
  218. large_page_size 0
  219. large_pages OFF
  220. last_insert_id 0
  221. lc_messages en_US
  222. lc_messages_dir /usr/share/mysql/
  223. lc_time_names en_US
  224. license GPL
  225. local_infile ON
  226. lock_wait_timeout 31536000
  227. locked_in_memory OFF
  228. log_bin ON
  229. log_bin_basename /var/lib/mysql/xxxx-db1-bin
  230. log_bin_index /var/lib/mysql/xxxx-db1-bin.index
  231. log_bin_trust_function_creators OFF
  232. log_bin_use_v1_row_events OFF
  233. log_error /var/log/mysqld.log
  234. log_output FILE
  235. log_queries_not_using_indexes OFF
  236. log_slave_updates ON
  237. log_slow_admin_statements OFF
  238. log_slow_slave_statements OFF
  239. log_throttle_queries_not_using_indexes 0
  240. log_warnings 1
  241. long_query_time 10.000000
  242. low_priority_updates OFF
  243. lower_case_file_system OFF
  244. lower_case_table_names 0
  245. master_info_repository TABLE
  246. master_verify_checksum OFF
  247. max_allowed_packet 4194304
  248. max_binlog_cache_size 18446744073709547520
  249. max_binlog_size 1073741824
  250. max_binlog_stmt_cache_size 18446744073709547520
  251. max_connect_errors 100
  252. max_connections 750
  253. max_delayed_threads 20
  254. max_error_count 64
  255. max_heap_table_size 16777216
  256. max_insert_delayed_threads 20
  257. max_join_size 18446744073709551615
  258. max_length_for_sort_data 1024
  259. max_prepared_stmt_count 16382
  260. max_relay_log_size 0
  261. max_seeks_for_key 18446744073709551615
  262. max_sort_length 1024a
  263. max_sp_recursion_depth 0
  264. max_tmp_tables 32
  265. max_user_connections 0
  266. max_write_lock_count 18446744073709551615
  267. metadata_locks_cache_size 1024
  268. metadata_locks_hash_instances 8
  269. min_examined_row_limit 0
  270. multi_range_count 256
  271. myisam_data_pointer_size 6
  272. myisam_max_sort_file_size 9223372036853727232
  273. myisam_mmap_size 18446744073709551615
  274. myisam_recover_options OFF
  275. myisam_repair_threads 1
  276. myisam_sort_buffer_size 8388608
  277. myisam_stats_method nulls_unequal
  278. myisam_use_mmap OFF
  279. net_buffer_length 16384
  280. net_read_timeout 30
  281. net_retry_count 10
  282. net_write_timeout 60
  283. new OFF
  284. old OFF
  285. old_alter_table OFF
  286. old_passwords 0
  287. open_files_limit 5000
  288. optimizer_prune_level 1
  289. optimizer_search_depth 62
  290. 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,subquery_materialization_cost_based=on,use_index_extensions=on
  291. optimizer_trace enabled=off,one_line=off
  292. optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  293. optimizer_trace_limit 1
  294. optimizer_trace_max_mem_size 16384
  295. optimizer_trace_offset -1
  296. performance_schema ON
  297. performance_schema_accounts_size 100
  298. performance_schema_digests_size 10000
  299. performance_schema_events_stages_history_long_size 10000
  300. performance_schema_events_stages_history_size 10
  301. performance_schema_events_statements_history_long_size 10000
  302. performance_schema_events_statements_history_size 10
  303. performance_schema_events_waits_history_long_size 10000
  304. performance_schema_events_waits_history_size 10
  305. performance_schema_hosts_size 100
  306. performance_schema_max_cond_classes 80
  307. performance_schema_max_cond_instances 5900
  308. performance_schema_max_file_classes 50
  309. performance_schema_max_file_handles 32768
  310. performance_schema_max_file_instances 7693
  311. performance_schema_max_mutex_classes 200
  312. performance_schema_max_mutex_instances 19500
  313. performance_schema_max_rwlock_classes 40
  314. performance_schema_max_rwlock_instances 10300
  315. performance_schema_max_socket_classes 10
  316. performance_schema_max_socket_instances 1520
  317. performance_schema_max_stage_classes 150
  318. performance_schema_max_statement_classes 168
  319. performance_schema_max_table_handles 4000
  320. performance_schema_max_table_instances 12500
  321. performance_schema_max_thread_classes 50
  322. performance_schema_max_thread_instances 1600
  323. performance_schema_session_connect_attrs_size 512
  324. performance_schema_setup_actors_size 100
  325. performance_schema_setup_objects_size 100
  326. performance_schema_users_size 100
  327. pid_file /var/run/mysqld/mysqld.pid
  328. plugin_dir /usr/lib64/mysql/plugin/
  329. port 3306
  330. preload_buffer_size 32768
  331. profiling OFF
  332. profiling_history_size 15
  333. protocol_version 10
  334. proxy_user
  335. pseudo_slave_mode OFF
  336. pseudo_thread_id 2018
  337. query_alloc_block_size 8192
  338. query_cache_limit 1048576
  339. query_cache_min_res_unit 4096
  340. query_cache_size 1048576000
  341. query_cache_type ON
  342. query_cache_wlock_invalidate OFF
  343. query_prealloc_size 8192
  344. rand_seed1 0
  345. rand_seed2 0
  346. range_alloc_block_size 4096
  347. read_buffer_size 131072
  348. read_only OFF
  349. read_rnd_buffer_size 262144
  350. relay_log
  351. relay_log_basename
  352. relay_log_index
  353. relay_log_info_file relay-log.info
  354. relay_log_info_repository TABLE
  355. relay_log_purge ON
  356. relay_log_recovery OFF
  357. relay_log_space_limit 0
  358. report_host 10.129.156.251
  359. report_password
  360. report_port 3306
  361. report_user
  362. rpl_stop_slave_timeout 31536000
  363. secure_auth ON
  364. secure_file_priv
  365. server_id 1
  366. server_id_bits 32
  367. server_uuid 96bcdb70-44c5-11e5-8df9-0401654ee301
  368. skip_external_locking ON
  369. skip_name_resolve OFF
  370. skip_networking OFF
  371. skip_show_database OFF
  372. slave_allow_batching OFF
  373. slave_checkpoint_group 512
  374. slave_checkpoint_period 300
  375. slave_compressed_protocol OFF
  376. slave_exec_mode STRICT
  377. slave_load_tmpdir /tmp
  378. slave_max_allowed_packet 1073741824
  379. slave_net_timeout 3600
  380. slave_parallel_workers 0
  381. slave_pending_jobs_size_max 16777216
  382. slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN
  383. slave_skip_errors ALL
  384. slave_sql_verify_checksum ON
  385. slave_transaction_retries 10
  386. slave_type_conversions
  387. slow_launch_time 2
  388. slow_query_log OFF
  389. slow_query_log_file /var/lib/mysql/xxxx-slow.log
  390. socket /var/lib/mysql/mysql.sock
  391. sort_buffer_size 262144
  392. sql_auto_is_null OFF
  393. sql_big_selects ON
  394. sql_buffer_result OFF
  395. sql_log_bin ON
  396. sql_log_off OFF
  397. sql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
  398. sql_notes ON
  399. sql_quote_show_create ON
  400. sql_safe_updates OFF
  401. sql_select_limit 18446744073709551615
  402. sql_slave_skip_counter 0
  403. sql_warnings OFF
  404. ssl_ca
  405. ssl_capath
  406. ssl_cert
  407. ssl_cipher
  408. ssl_crl
  409. ssl_crlpath
  410. ssl_key
  411. storage_engine InnoDB
  412. stored_program_cache 256
  413. sync_binlog 0
  414. sync_frm ON
  415. sync_master_info 1
  416. sync_relay_log 10000
  417. sync_relay_log_info 10000
  418. system_time_zone EST
  419. table_definition_cache 1400
  420. table_open_cache 2000
  421. table_open_cache_instances 1
  422. thread_cache_size 15
  423. thread_concurrency 10
  424. thread_handling one-thread-per-connection
  425. thread_stack 262144
  426. time_format %H:%i:%s
  427. time_zone SYSTEM
  428. timed_mutexes OFF
  429. timestamp 1457343545.452900
  430. tmp_table_size 16777216
  431. tmpdir /tmp
  432. transaction_alloc_block_size 8192
  433. transaction_allow_batching OFF
  434. transaction_prealloc_size 4096
  435. tx_isolation REPEATABLE-READ
  436. tx_read_only OFF
  437. unique_checks ON
  438. updatable_views_with_limit YES
  439. version 5.6.19-log
  440. version_comment MySQL Community Server (GPL)
  441. version_compile_machine x86_64
  442. version_compile_os Linux
  443. wait_timeout 28800
  444. warning_count 0
  445.  
  446. query_cache_size 1048576000
  447. query_cache_type ON
  448.  
  449. innodb_buffer_pool_size = 30G -- you are not using all of the 40G now
  450. key_buffer_size = 2G -- your current 8M is not efficient for writes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement