Last active
July 20, 2019 03:10
-
-
Save vrkansagara/3531b5b7f18368cebfcd71b8dae105cc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
percona-mysql-router.x86_64 8.0.15-6.1.el6 installed | |
cat my.cnf | |
# Percona Server template configuration | |
# | |
# For advice on how to change settings please see | |
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html | |
[mysqld] | |
# | |
# Remove leading # and set to the amount of RAM for the most important data | |
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. | |
# innodb_buffer_pool_size = 128M | |
# | |
# Remove the leading "# " to disable binary logging | |
# Binary logging captures changes between backups and is enabled by | |
# default. It's default setting is log_bin=binlog | |
# disable_log_bin | |
# | |
# Remove leading # to set options mainly useful for reporting servers. | |
# The server defaults are faster for transactions and fast SELECTs. | |
# Adjust sizes as needed, experiment to find the optimal values. | |
# join_buffer_size = 128M | |
# sort_buffer_size = 2M | |
# read_rnd_buffer_size = 2M | |
sql_mode=STRICT_ALL_TABLES | |
innodb_buffer_pool_size=512M | |
thread_handling=pool-of-threads | |
# | |
# Remove leading # to revert to previous value for default_authentication_plugin, | |
# this will increase compatibility with older clients. For background, see: | |
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin | |
# default-authentication-plugin=mysql_native_password | |
datadir=/var/lib/mysql | |
socket=/var/lib/mysql/mysql.sock | |
log-error=/var/log/mysqld.log | |
pid-file=/var/run/mysqld/mysqld.pid | |
[mysqld_safe] | |
thp-setting=never |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment