Advertisement
keith_shannon

my.cnf.erb

May 18th, 2015
527
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. [client]
  2. port = <%= port %>
  3. socket = <%= socket %>
  4. [mysqld_safe]
  5. socket = <%= socket %>
  6. nice = 0
  7. <% if log_error == 'syslog' -%>
  8. syslog
  9. <% end -%>
  10. [mysqld]
  11. user = mysql
  12. pid-file = <%= pidfile %>
  13. socket = <%= socket %>
  14. port = <%= port %>
  15. basedir = <%= basedir %>
  16. datadir = <%= datadir %>
  17. tmpdir = /tmp
  18. skip-external-locking
  19.  
  20. <% if bind_address %>
  21. bind-address = <%= bind_address %>
  22. <% end %>
  23.  
  24. key_buffer = 16M
  25. max_allowed_packet = 16M
  26. thread_stack = 192K
  27. thread_cache_size = 8
  28. myisam-recover = BACKUP
  29. query_cache_limit = 1M
  30. query_cache_size = 16M
  31. <% if log_error != 'syslog' -%>
  32. log_error = <%= log_error %>
  33. <% end -%>
  34. expire_logs_days = 10
  35. max_binlog_size = 100M
  36. <% if default_engine != 'UNSET' %>
  37. default-storage-engine = <%= default_engine %>
  38. <% end %>
  39. <% if ssl == true %>
  40. ssl-ca = <%= ssl_ca %>
  41. ssl-cert = <%= ssl_cert %>
  42. ssl-key = <%= ssl_key %>
  43. <% end %>
  44.  
  45. [mysqldump]
  46. quick
  47. quote-names
  48. max_allowed_packet = 16M
  49. [mysql]
  50. [isamchk]
  51. key_buffer = 16M
  52. !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement