Mysql server configuration file using during RHCS Performance testing

server.conf

# 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