From c3de9ab107904ba953ac676727ebd6463a0695bd Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Wed, 18 Sep 2024 04:46:53 +0000 Subject: automatic import of greatsql --- mysqld.cnf | 36 ++++++++++++++++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 mysqld.cnf (limited to 'mysqld.cnf') 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 -- cgit v1.2.3