diff options
Diffstat (limited to 'projectroot/etc/mysql/my.cnf')
-rw-r--r-- | projectroot/etc/mysql/my.cnf | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/projectroot/etc/mysql/my.cnf b/projectroot/etc/mysql/my.cnf new file mode 100644 index 000000000..909c0da8c --- /dev/null +++ b/projectroot/etc/mysql/my.cnf @@ -0,0 +1,38 @@ +# For advice on how to change settings please see +# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html + +[mysqld] +innodb_force_recovery = 0 + +# 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 = 8M + +# Remove leading # to turn on a very important data integrity option: logging +# changes to the binary log between backups. +# log_bin + +# Remove leading # to turn on error logging. +# log_error= +# log_error_verbosity= + +# we have a read-only filesystem with one persistent writeable area only +# so point to this single writeable location +datadir = /var/lib/mysql/data + +# These are commonly set, remove the # and set as required. +# lc-messages-dir = ..... +# plugin-dir = ..... +# basedir = ..... +# port = ..... +# server_id = ..... +# socket = ..... + +# 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 = 8M +sort_buffer_size = 2M +read_rnd_buffer_size = 2M + +sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES |