Skip to content

Instantly share code, notes, and snippets.

@likid0 likid0/server.conf
Created Aug 27, 2019

Embed
What would you like to do?
Mysql server configuration file using during RHCS Performance testing
# MariaDB Server configuration
#
# Please do not change this file directly since it is managed by Ansible and will be overwritten
[mariadb]
socket = /var/lib/mysql/mysql.sock
port = 3306
default_storage_engine = InnoDB
character_set_server = utf8
collation_server = utf8_general_ci
sysdate_is_now = 1
log_warnings = 1
slow_query_log = 0
long_query_time = 10
expire_logs_days = 10
sync_binlog = 1
max_connections = 2505
max_connect_errors = 100
max_user_connections = 2500
thread_concurrency = 16
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0
# User is ignored when systemd is used (fedora >= 15).
user = mysql
# http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html
;performance_schema
# Memory settings.
key_buffer_size = 256M
max_allowed_packet = 64M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_type = 0
query_cache_size = 16M
query_cache_limit = 1M
max_connections = 151
tmp_table_size = 16M
max_heap_table_size = 16M
group_concat_max_len = 1024
join_buffer_size = 262144
# Other settings.
wait_timeout = 28800
lower_case_table_names = 0
event_scheduler = OFF
# InnoDB settings.
innodb_file_per_table = 1
innodb_buffer_pool_size = 10G
innodb_buffer_pool_instances = 5
innodb_log_file_size = 2146435072
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.