Skip to content

Instantly share code, notes, and snippets.

@abg
Last active August 29, 2015 13:57
Show Gist options
  • Select an option

  • Save abg/9532107 to your computer and use it in GitHub Desktop.

Select an option

Save abg/9532107 to your computer and use it in GitHub Desktop.
IUS 5.6 default my.cnf (no extended comments)
## _______________________________________________________________________
## / Rackspace MySQL 5.6 Terse Configuration File \
## | |
## | This is a base configuration file containing the most frequently used |
## | settings with reasonably defined default values for configuring and |
## | tuning MySQL. Note that these settings can likely be further tuned in |
## | order to get optimum performance from MySQL based upon the database |
## | configuration and hardware platform. |
## | |
## | For many deployments, the only variables which need to be modified |
## | below are max-connections and innodb-buffer-pool-size. |
## | |
## \ http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html /
## -----------------------------------------------------------------------
## \ ^__^
## \ (oo)\_______
## (__)\ )\/\
## ||----w |
## || ||
[mysqld]
## General
ignore-db-dir = lost+found
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
tmpdir = /var/lib/mysqltmp
## Cache
table-definition-cache = 4096
table-open-cache = 4096
table-open-cache-instances = 8
#query-cache-size = 32M
#query-cache-type = 1
## Per-thread Buffers
#join-buffer-size = 512K
#read-buffer-size = 512K
#read-rnd-buffer-size = 512K
#sort-buffer-size = 512K
## Temp Tables
#max-heap-table-size = 64M
#tmp-table-size = 32M
## Networking
#interactive-timeout = 3600
max-connections = 200
max-connect-errors = 1000000
max-allowed-packet = 16M
slave-net-timeout = 60
skip-name-resolve
wait-timeout = 600
## MyISAM
key-buffer-size = 32M
#myisam-recover = FORCE,BACKUP
myisam-sort-buffer-size = 256M
## InnoDB
#innodb-autoinc-lock-mode = 2
innodb-buffer-pool-size = 256M
innodb-buffer-pool-load-at-startup = 1
innodb-buffer-pool-dump-at-shutdown = 1
innodb-file-format = Barracuda
innodb-file-per-table = 1
#innodb-flush-method = O_DIRECT
#innodb-log-file-size = 128M
#innodb-large-prefix = 0
#innodb-lru-scan-depth = 1000
#innodb-io-capacity = 1000
innodb-purge-threads = 4
## Replication and PITR
#auto-increment-increment = 2
#auto-increment-offset = 1
#binlog-format = ROW
expire-logs-days = 5
#log-bin = /var/log/mysql/bin-log
#log-slave-updates = 1
max-binlog-size = 128M
#read-only = 1
relay-log = /var/log/mysql/relay-log
relay-log-space-limit = 16G
server-id = 1
#slave-compressed-protocol = 1
#slave-sql-verify-checksum = 1
#sync-binlog = 1
#sync-master-info = 1
#sync-relay-log = 1
#sync-relay-log-info = 1
## Logging
log-output = FILE
log-slow-admin-statements
log-slow-slave-statements
#log-warnings = 0
long-query-time = 2
slow-query-log = 0
slow-query-log-file = /var/log/mysql/slow-log
## SSL
#ssl-ca = /etc/mysql-ssl/ca-cert.pem
#ssl-cert = /etc/mysql-ssl/server-cert.pem
#ssl-key = /etc/mysql-ssl/server-key.pem
[mysqld_safe]
log-error = /var/log/mysqld.log
#malloc-lib = /usr/lib64/libjemalloc.so.1
open-files-limit = 65535
[mysql]
no-auto-rehash
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment