SHARE
TWEET

Untitled

a guest Aug 20th, 2017 154 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
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