#
# Sightly customised my.cnf for GitLab
#
# Notes: this is tuned for a 2GiB of RAM GitLab instance with Percona Server
#

[mysqld]
bind-address=127.0.0.1
socket=/tmp/mysql.sock

# MyISAM settings
key_buffer_size = 16M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M

skip-external-locking
max_allowed_packet = 1M
table_open_cache = 1024
net_buffer_length = 2K
thread_stack = 128K


innodb_buffer_pool_size = 256M
innodb_log_file_size = 400M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_file_per_table
innodb_doublewrite = 0
innodb_io_capacity = 1500
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_buffer_pool_instances = 1

thread_concurrency = 32
tmpdir = /tmp
max_connections = 50
max_allowed_packet = 24M
max_join_size = 4294967295
net_buffer_length = 2K
thread_stack = 128K
tmp_table_size = 64M
max_heap_table_size = 64M

query_cache_type = 1
query_cache_size = 128M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout