Guest User

my.cnf for 48G Linode Fabric Percona 5.6

a guest
May 13th, 2015
256
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. #Connection timeout
  16. wait_timeout = 600
  17. interactive_timeout = 600
  18.  
  19. # MyISAM #
  20. key-buffer-size = 32M
  21. myisam-recover = FORCE,BACKUP
  22.  
  23. # SAFETY #
  24. max-allowed-packet = 16M
  25. max-connect-errors = 1000000
  26. sysdate-is-now = 1
  27. innodb = FORCE
  28.  
  29. # DATA STORAGE #
  30. datadir = /var/lib/mysql/
  31.  
  32. # BINARY LOGGING #
  33. log-bin = /var/lib/mysql/mysql-bin
  34. expire-logs-days = 14
  35. sync-binlog = 1
  36.  
  37. # REPLICATION #
  38. server-id = 34
  39. read-only = 0
  40. #skip-slave-start = 1
  41. log-slave-updates = 1
  42. relay-log = /var/lib/mysql/relay-bin
  43. slave-net-timeout = 60
  44. sync-master-info = 1
  45. sync-relay-log = 1
  46. sync-relay-log-info = 1
  47.  
  48. #temporary for fabric prep dat acleanup
  49. #slave-skip-errors = 1032
  50.  
  51. #binlog-do-db = serpsalpha
  52. binlog-format = 'ROW'
  53.  
  54. #Fabric:
  55. #skip-slave-start (=0), binlog-do-db (empty), & binlog-format (ROW) above are changed for Fabric.
  56. #additionally, sync-master-info must be on for Fabric, and the following:
  57. gtid-mode = 'ON'
  58. enforce-gtid-consistency = 'ON'
  59. simplified_binlog_gtid_recovery = 'ON' #Note: this variable has been changing name a lot. It can fail under special circumstances. See details at http://v.gd/2XcOhf
  60. master-info-repository = TABLE
  61. relay-log-info-repository = TABLE
  62. #report-host= might want to set this for fabric
  63. #report-port #no need to set, as it's reported correctly as of 5.5 or 5.6...
  64.  
  65. # CACHES AND LIMITS #
  66. tmp-table-size = 32M
  67. max-heap-table-size = 32M
  68. query-cache-type = 0
  69. query-cache-size = 0
  70. max-connections = 500
  71. thread-cache-size = 50
  72. open-files-limit = 65535
  73. table-definition-cache = 1024
  74. table-open-cache = 55
  75.  
  76. # INNODB #
  77. innodb-flush-method = O_DIRECT
  78. innodb-log-files-in-group = 2
  79. innodb-log-file-size = 512M
  80. innodb-flush-log-at-trx-commit = 2
  81. innodb-file-per-table = 1
  82. innodb-buffer-pool-size = 40G
  83. innodb-rollback-on-timeout = ON
  84. transaction-isolation = READ-COMMITTED
  85. low-priority-updates = 1
  86.  
  87. # LOGGING #
  88. log-error = /var/log/mysql/mysql-error.log
  89. log-queries-not-using-indexes = 0
  90. slow-query-log = 1
  91. slow-query-log-file = /var/log/mysql/mysql-slow.log
  92. long-query-time = 10
RAW Paste Data