Created
February 8, 2017 14:58
-
-
Save elisska/cfcac48435cfb25d3277e412c441a9a6 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[client] | |
port = 3306 | |
socket = /var/lib/mysql/mysql.sock | |
[mysqld] | |
port = 3306 | |
socket = /var/lib/mysql/mysql.sock | |
skip-external-locking | |
key_buffer = 32M | |
key_buffer_size = 64M | |
max_allowed_packet = 32M | |
thread_stack = 256K | |
thread_cache_size = 64 | |
query_cache_limit = 16M | |
query_cache_size = 64M | |
query_cache_type = 1 | |
max_connections = 700 | |
table_open_cache = 256 | |
sort_buffer_size = 8M | |
join_buffer_size = 8M | |
net_buffer_length = 8K | |
read_buffer_size = 2M | |
read_rnd_buffer_size = 16M | |
myisam_sort_buffer_size = 64M | |
thread_concurrency = 8 | |
log-bin = mysql-bin # for replication | |
server-id = 1 # replication ID (Master is 1) | |
innodb_file_per_table = 1 | |
innodb_flush_log_at_trx_commit = 1 # supports replication[?] | |
innodb_log_buffer_size = 64M | |
innodb_buffer_pool_size = 2G | |
innodb_thread_concurrency = 16 | |
innodb_flush_method = O_DIRECT | |
innodb_log_file_size = 512M | |
sync_binlog = 1 # supports replication | |
[mysqldump] | |
quick | |
max_allowed_packet = 16M | |
[mysql] | |
no-auto-rehash | |
[myisamchk] | |
key_buffer_size = 128M | |
sort_buffer_size = 128M | |
read_buffer = 2M | |
write_buffer = 2M | |
[mysqlhotcopy] | |
interactive-timeout | |
[mysqld_safe] | |
log-error=/var/log/mysqld.log | |
pid-file=/var/run/mysqld/mysqld.pid | |
datadir=/var/lib/mysql | |
user=mysql | |
# Disabling symbolic-links is recommended to prevent assorted security risks | |
# symbolic-links=0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment