diff options
Diffstat (limited to 'mysqld.cnf')
| -rw-r--r-- | mysqld.cnf | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysqld.cnf b/mysqld.cnf new file mode 100644 index 0000000..8b54db6 --- /dev/null +++ b/mysqld.cnf @@ -0,0 +1,36 @@ +# GreatSQL 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 +# +# 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 + +# The default mysql directories are as follow +# datadir=/var/lib/mysql +# socket=/var/lib/mysql/mysql.sock +# log-error=/var/log/mysqld.log +# pid-file=/var/run/mysqld/mysqld.pid + +# Keep the same behavior like other MySQL based/series Databases(MariaDB, Percona, GreatSQL, MySQL5.7 and MySQL8.0) +!includedir /etc/my.cnf.d |