Guest User

Untitled

a guest
Jan 30th, 2014
64
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysql]
  2.  
  3. # CLIENT #
  4. port = 3306
  5. socket = /var/lib/mysql/mysql.sock
  6.  
  7. [mysqld]
  8.  
  9. # GENERAL #
  10. user = mysql
  11. default-storage-engine = InnoDB
  12. socket = /var/lib/mysql/mysql.sock
  13. pid-file = /var/lib/mysql/mysql.pid
  14.  
  15. # MyISAM #
  16. key-buffer-size = 32M
  17. myisam-recover = FORCE,BACKUP
  18.  
  19. # SAFETY #
  20. max-allowed-packet = 16M
  21. max-connect-errors = 1000000
  22. skip-name-resolve
  23. #sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
  24. sysdate-is-now = 1
  25. innodb = FORCE
  26. innodb-strict-mode = 1
  27.  
  28. # DATA STORAGE #
  29. datadir = /var/lib/mysql/
  30.  
  31. # BINARY LOGGING #
  32. log-bin = /var/lib/mysql/mysql-bin
  33. expire-logs-days = 3
  34. sync-binlog = 1
  35.  
  36. # CACHES AND LIMITS #
  37. tmp-table-size = 32M
  38. max-heap-table-size = 32M
  39. query-cache-type = 0
  40. query-cache-size = 0
  41. max-connections = 500
  42. thread-cache-size = 50
  43. open-files-limit = 65535
  44. table-definition-cache = 4096
  45. table-open-cache = 10240
  46.  
  47. # INNODB #
  48. innodb-flush-method = O_DIRECT
  49. innodb-log-files-in-group = 2
  50. innodb-log-file-size = 512M
  51. innodb-flush-log-at-trx-commit = 1
  52. innodb-file-per-table = 1
  53. innodb-buffer-pool-size = 40G
  54.  
  55. # LOGGING #
  56. log-error = /var/lib/mysql/mysql-error.log
  57. log-queries-not-using-indexes = 0
  58. slow-query-log = 0
  59. slow-query-log-file = /var/lib/mysql/mysql-slow.log
  60.  
  61. [mysqld_safe]
  62. numa-interleave
RAW Paste Data