Advertisement
Guest User

my-cnf

a guest
Dec 17th, 2018
255
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.78 KB | None | 0 0
  1. [mysqld]
  2. bulk_insert_buffer_size=64M
  3. datadir="/home/mysql"
  4. innodb_additional_mem_pool_size=16M
  5. innodb_buffer_pool_size=24G
  6. innodb_buffer_pool_instances=4
  7. innodb_file_per_table=1
  8. innodb_log_file_size=256M
  9. join_buffer_size=128M
  10. key_buffer_size=32M
  11. log-warnings=10
  12. max_allowed_packet=128M
  13. max_connect_errors=10
  14. max_connections=1000
  15. max_heap_table_size=512M
  16. myisam_repair_threads=1
  17. myisam_sort_buffer_size=128M
  18. query_cache_limit=2M
  19. query_cache_size=128M
  20. query_cache_type=1
  21. read_buffer_size=8M
  22. read_rnd_buffer_size=16M
  23. sort_buffer_size=128M
  24. thread_cache_size=32
  25. thread_pool_size = 32
  26. thread_concurrency=4
  27. tmpdir="/tmp"
  28. tmp_table_size=512M
  29. open_files_limit = 65535
  30. table_definition_cache = 8000
  31. table_open_cache = 8000
  32. innodb_read_io_threads = 12
  33. innodb_write_io_threads = 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement