diff options
Diffstat (limited to 'support-files/my-medium.cnf.sh')
| -rw-r--r-- | support-files/my-medium.cnf.sh | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/support-files/my-medium.cnf.sh b/support-files/my-medium.cnf.sh new file mode 100644 index 00000000000..13bf8e739ec --- /dev/null +++ b/support-files/my-medium.cnf.sh @@ -0,0 +1,63 @@ +# Example mysql config file for medium systems. +# +# This is for a system with little memory (32M - 64M) where MySQL plays +# a important part and systems up to 128M very MySQL is used together with +# other programs (like a web server) +# +# You can copy this file to +# /etc/mf.cnf to set global options, +# mysql-data-dir/my.cnf to set server-specific options (in this +# installation this directory is @localstatedir@) or +# ~/.my.cnf to set user-specific options. +# +# One can in this file use all long options that the program supports. +# If you want to know which options a program support, run the program +# with --help option. + +# The following options will be passed to all MySQL clients +[client] +#password = your_password +port = @MYSQL_TCP_PORT@ +socket = @MYSQL_UNIX_ADDR@ + +# Here follows entries for some specific programs + +# The MySQL server +[mysqld] +port = @MYSQL_TCP_PORT@ +socket = @MYSQL_UNIX_ADDR@ +skip-locking +set-variable = key_buffer=16M +set-variable = max_allowed_packet=1M +set-variable = table_cache=64 +set-variable = sort_buffer=512K +set-variable = net_buffer_length=8K +set-variable = myisam_sort_buffer_size=8M +log-update + +# Uncomment the following if you are using BDB tables +#set-variable = bdb_cache_size=4M + +# Point the following paths to different dedicated disks +#tmpdir = /tmp/ +#log-update = /path-to-dedicated-directory/hostname + +[mysqldump] +quick +set-variable = max_allowed_packet=16M + +[mysql] +no-auto-rehash +#safe-updates # Remove the comment character if you are not familiar with SQL + +[isamchk] +set-variable = key_buffer=20M +set-variable = sort_buffer=20M +set-variable = read_buffer=2M +set-variable = write_buffer=2M + +[myisamchk] +set-variable = key_buffer=20M +set-variable = sort_buffer=20M +set-variable = read_buffer=2M +set-variable = write_buffer=2M |