Guest User

Untitled

a guest
Aug 20th, 2017
216
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. tmpdir=/home/mysqltmp
  5. tokudb_tmp_dir=/home/mysqltmp
  6. skip-networking
  7. bind-address = 127.0.0.1
  8. innodb = ON
  9.  
  10. default_storage_engine = tokudb
  11. key_buffer_size = 2048M
  12. key_cache_block_size = 2048M
  13. key_cache_age_threshold = 500
  14. key_cache_division_limit = 50
  15. query_cache_size = 32
  16. query_cache_limit = 128M
  17. max_connections = 500
  18. thread_cache_size = 10000
  19. query_cache_min_res_unit = 0
  20. tmp_table_size = 128M
  21. max_heap_table_size = 128M
  22. table_definition_cache = 16384
  23. concurrent_insert = 2
  24. max_allowed_packet = 500M
  25. net_buffer_length = 2K
  26. wait_timeout = 300
  27. table_definition_cache = 2000
  28. thread-handling = pool-of-threads
  29. thread_pool_size = 100
  30. key_cache_segments = 64
  31. back_log = 150
  32. table_open_cache = 2024
  33.  
  34. aria_pagecache_buffer_size = 536870912
  35. aria_pagecache_age_threshold = 400
  36. aria_pagecache_division_limit = 90
  37.  
  38. innodb_thread_concurrency = 8 #recommend 2x core quantity
  39. innodb_commit_concurrency = 16 #recommend 4x num disks
  40. innodb_flush_method = O_DIRECT #O_DIRECT = local/DAS, O_DSYNC = SAN/iSCSI
  41. #innodb_buffer_pool_size = 10G #global buffer
  42. innodb_log_file_size = 256m
  43. innodb_log_buffer_size = 4M
  44.  
  45. ## Per-Thread Buffers * (max_connections) = total per-thread mem usage
  46. thread_stack = 256K #default: 32bit: 192K, 64bit: 256K
  47. sort_buffer_size = 1M #default: 2M, larger may cause perf issues
  48. read_buffer_size = 256k #default: 128K, change in increments of 4K
  49. read_rnd_buffer_size = 512k #default: 256K
  50. join_buffer_size = 512K #default: 128K
  51. ## total per-thread buffer memory usage: 8832000K = 8.625GB
  52.  
  53. optimizer_switch = "mrr=on,mrr_cost_based=on,mrr_sort_keys=on,optimize_join_buffer_size=on,exists_to_in=on"
  54.  
  55. deadlock_search_depth_short = 3
  56. deadlock_search_depth_long = 10
  57. deadlock_timeout_long = 10000000
  58. deadlock_timeout_short = 5000
  59.  
  60. thread_pool_idle_timeout = 300
  61.  
  62. # TokuDB Cache should be set to at least half of available RAM
  63. tokudb_cache_size = 9GB
  64. tokudb_row_format = tokudb_lzma
  65. tokudb_directio = OFF
  66. tokudb_empty_scan = disabled
  67. tokudb_read_block_size = 16K
  68. tokudb_commit_sync = ON
  69. tokudb_checkpointing_period = 900
  70. tokudb_block_size = 4M
  71. tokudb_cleaner_iterations = 10000
  72. tokudb_fanout = 128
RAW Paste Data