daily pastebin goal
92%
SHARE
TWEET

Untitled

a guest Aug 10th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. # Disabling symbolic-links is recommended to prevent assorted security risks;
  3. # to do so, uncomment this line:
  4. # symbolic-links=0
  5.  
  6. key_buffer              = 16M
  7. key_buffer_size         = 32M
  8. max_allowed_packet      = 16M
  9. thread_stack            = 256K
  10. thread_cache_size       = 64
  11. query_cache_limit       = 8M
  12. query_cache_size        = 64M
  13. query_cache_type        = 1
  14. # Important: see Distributing the Databases and Setting max_connections
  15. max_connections         = 600
  16.  
  17. read_buffer_size = 2M
  18. read_rnd_buffer_size = 16M
  19. sort_buffer_size = 8M
  20. join_buffer_size = 8M
  21.  
  22. # InnoDB settings
  23. innodb_file_per_table = 1
  24. innodb_flush_log_at_trx_commit  = 2
  25. innodb_log_buffer_size          = 64M
  26. innodb_buffer_pool_size         = 2G
  27. innodb_thread_concurrency       = 8
  28. innodb_flush_method             = O_DIRECT
  29. innodb_log_file_size = 512M
  30.  
  31. [mysqld_safe]
  32. log-error=/var/log/mysqld.log
  33. pid-file=/var/run/mysqld/mysqld.pid
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