Skip to content

Instantly share code, notes, and snippets.

@eshleebien
Created April 30, 2015 04:30
Show Gist options
  • Save eshleebien/aafa9da5ef402aaa77bd to your computer and use it in GitHub Desktop.
Save eshleebien/aafa9da5ef402aaa77bd to your computer and use it in GitHub Desktop.
my mysql configuration
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
collation-server = utf8_unicode_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
federated
event_scheduler=ON
port = 3306
# * Fine Tuning
key_buffer = 384M
max_allowed_packet = 64M
join_buffer_size = 75M
read_buffer_size = 1M
sort_buffer_size = 2M
thread_stack = 192K
thread_cache_size = 384
myisam-recover = BACKUP
max_connections = 3000
table_cache = 2K
wait_timeout = 5200
connect_timeout = 10
tmp_table_size = 92M
interactive_timeout = 2400
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_type = 1
query_cache_limit = 4M
query_cache_size = 128M
query_prealloc_size = 65536
query_alloc_block_size = 131072
log-queries-not-using-indexes = 0
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
innodb_flush_method=O_DIRECT
innodb_thread_concurrency=2
innodb_buffer_pool_instances=4
innodb_buffer_pool_size = 5G
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment