Savvoy

Sample sql set

Nov 26th, 2020 (edited)
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.85 KB | None | 0 0
  1. key-buffer-size                = 64G
  2. read_buffer_size              = 1M
  3. join_buffer_size               = 4294967295
  4. read_rnd_buffer_size           = 2M
  5. key_cache_age_threshold        = 400
  6. key_cache_block_size          = 800
  7. myisam_data_pointer_size       = 7
  8. preload_buffer_size            = 2M
  9. sort_buffer_size               = 2M
  10. myisam_sort_buffer_size        = 10G
  11. bulk_insert_buffer_size        = 2M
  12. myisam_repair_threads          = 8
  13. myisam_max_sort_file_size      = 30G
  14. max-allowed-packet             = 256M
  15. tmp-table-size                 = 32M
  16. max-heap-table-size            = 32M
  17. query-cache-type               = 0
  18. query-cache-size               = 0
  19. max-connections                = 500
  20. thread-cache-size              = 150
  21. open-files-limit               = 65535
  22. table-definition-cache         = 1024
  23. table-open-cache               = 2048
Add Comment
Please, Sign In to add comment