# Beyond Hosting # Baseline 128GB Configuration # Modified 8/6/2014 [mysql] # CLIENT # port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL # user = mysql default-storage-engine = InnoDB socket = /var/lib/mysql/mysql.sock pid-file = /var/lib/mysql/mysql.pid # MyISAM # key-buffer-size = 256M myisam-sort-buffer-size = 64M myisam-recover-options = FORCE # SAFETY # skip-external-locking max-allowed-packet = 16M max-connect-errors = 1000000 innodb = FORCE # DATA STORAGE # datadir = /var/lib/mysql/ # CACHES AND LIMITS # tmp-table-size = 64M max-heap-table-size = 64M query-cache-type = 0 query-cache-size = 0 max-connections = 800 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 8192 table-open-cache = 4096 group-concat-max-len = 10485760 # INNODB # #innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 512M innodb-log-buffer-size = 16M innodb-flush-log-at-trx-commit = 2 innodb-file-per-table = 1 innodb-buffer-pool-size = 96G # LOGGING # # log-queries-not-using-indexes = 1 # slow-query-log = 1 # slow-query-log-file = /var/lib/mysql/mysql-slow.log [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout