Gecko [ www.thearyasamaj.org ]

Name	Size	Permission
client.cnf	337 B	-rw-r--r--
mysql-default-authentication-p...	565 B	-rw-r--r--
mysql-server.cnf	1.94 KB	-rw-r--r--
mysql-server.cnf.rpmsave	864 B	-rw-r--r--
mysql-server.cnf_bak	1.95 KB	-rw-r--r--

Code Editor : mysql-server.cnf_bak

#
# This group are read by MySQL server.
# Use it for options that only the server (but not clients) should see
#
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/en/server-configuration-defaults.html

# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid

default_authentication_plugin=mysql_native_password
collation-server = utf8_unicode_ci
character-set-server = utf8
default_storage_engine=InnoDB
innodb_buffer_pool_size= 10G ###45G###
innodb_log_file_size=1G 
innodb_flush_log_at_trx_commit=0
sync_binlog=0 
innodb_flush_method=O_DIRECT 
innodb_read_io_threads=64
innodb_write_io_threads=64
innodb_log_buffer_size=64M
innodb_thread_concurrency=4
innodb_stats_on_metadata=0 
table_open_cache_instances=4
innodb_checksum_algorithm=crc32 
expire_logs_days=7
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_pct=75 
innodb_adaptive_hash_index_parts=8
join_buffer_size=4M    
read_buffer_size=3M    
read_rnd_buffer_size=4M    
sort_buffer_size=4M    
table_definition_cache=40000 
table_open_cache=40000 
open_files_limit=60000
max_heap_table_size=256M
tmp_table_size=256M
max_allowed_packet=4024M
max_connections= 10300 ###new###
interactive_timeout=120
wait_timeout=180
event_scheduler = OFF

# skip_name_resolve
symbolic-links=0 
log_bin_trust_function_creators=1
sql_mode="NO_ENGINE_SUBSTITUTION"

#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

slow_query_log = 1
slow-query_log_file = /var/log/mysql-slow.log
long_query_time = 1
wait_timeout = 180
#max_execution_time = 0
max_execution_time = 123600

${this.title}

Code Editor : mysql-server.cnf_bak