Skip to content

Instantly share code, notes, and snippets.

@tareqy

tareqy/my.cnf

Created June 3, 2018 14:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tareqy/fc0fd0d986d16015cb427467c98cbb4a to your computer and use it in GitHub Desktop.
Save tareqy/fc0fd0d986d16015cb427467c98cbb4a to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Server settings for JIRA server
Raw
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_allowed_packet=1G
query_cache_type=1
query_cache_limit=3000M
query_cache_size=16M
tmp_table_size=256M
max_heap_table_size=256M
table_open_cache=1024
thread_cache_size=18
innodb_buffer_pool_instances=1
innodb_buffer_pool_size=1G
innodb_log_file_size=2GB
transaction-isolation=READ-COMMITTED
binlog_format=row
character-set-server=utf8
collation-server=utf8_bin
default-storage-engine=INNODB
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment