SHARE
TWEET

my.cnf

a guest Jun 8th, 2015 227 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysql]
  2. port                           = 3306
  3. socket                         = /var/run/mysqld/mysqld.sock
  4.  
  5. [mysqld]
  6. user                           = mysql
  7. default-storage-engine         = InnoDB
  8. bind-address                   = 0.0.0.0
  9. port                           = 3306
  10. socket                         = /var/run/mysqld/mysqld.sock
  11. pid-file                       = /var/run/mysqld/mysqld.pid
  12. key-buffer-size                = 32M
  13. myisam-recover                 = FORCE,BACKUP
  14. max-allowed-packet             = 16M
  15. max-connect-errors             = 1000000
  16. skip-name-resolve
  17. datadir                        = /var/lib/mysql/
  18. log-bin                        = /var/lib/mysql/mysql-bin
  19. expire-logs-days               = 2
  20. max_binlog_size                = 500M
  21. sync-binlog                    = 1
  22. log-slave-updates              = 1
  23. relay-log                      = /var/lib/mysql/relay-bin
  24. slave-net-timeout              = 60
  25. sync-master-info               = 1
  26. sync-relay-log                 = 1
  27. sync-relay-log-info            = 1
  28. tmp-table-size                 = 32M
  29. max-heap-table-size            = 32M
  30. query-cache-type               = 1
  31. query-cache-size               = 32M
  32. max-connections                = 1000
  33. thread-cache-size              = 100
  34. open-files-limit               = 65535
  35. table-definition-cache         = 4096
  36. table-open-cache               = 10240
  37. innodb-flush-method            = O_DIRECT
  38. innodb-log-files-in-group      = 2
  39. innodb-log-file-size           = 128M
  40. innodb-flush-log-at-trx-commit = 2
  41. innodb-file-per-table          = 1
  42. innodb-buffer-pool-size        = 2G
  43. log-error                      = /var/log/mysql/error.log
  44. log-queries-not-using-indexes  = 1
  45. slow-query-log                 = 1
  46. slow-query-log-file            = /var/log/mysql/slow.log
  47.  
  48. replicate-ignore-db            = mysql
  49.  
  50. ; These settings are essential for $customer
  51. optimizer_search_depth         = 6
  52. character-set-server           = utf8
  53.  
  54. ; Recommended by mysqltuner.pl
  55. join_buffer_size               = 512K
  56. tmp_table_size                 = 64M
  57. max_heap_table_size            = 64M
  58. table_open_cache               = 20KB
  59.  
  60. !includedir /etc/mysql/conf.d/
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