diff options
Diffstat (limited to 'support-files/Attic/my-large.cfg.sh')
| -rw-r--r-- | support-files/Attic/my-large.cfg.sh | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/support-files/Attic/my-large.cfg.sh b/support-files/Attic/my-large.cfg.sh new file mode 100644 index 00000000000..01e830ae16c --- /dev/null +++ b/support-files/Attic/my-large.cfg.sh @@ -0,0 +1,60 @@ +# Example mysql config file for large systems. +# +# This is for large system with memory = 512M where the system runs mainly +# MySQL. +# +# 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@ +#tmpdir = /tmp/ # Put this on a dedicated disk +skip-locking +set-variable = key_buffer=256M +set-variable = max_allowed_packet=1M +set-variable = table_cache=256 +set-variable = sort_buffer=1M +set-variable = record_buffer=1M +set-variable = myisam_sort_buffer_size=64M +set-variable = thread_cache=8 +set-variable = thread_concurrency=8 # Try number of CPU's*2 +#set-variable = bdb_cache_size=64M +# Only log updates +log-update + +[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=128M +set-variable = sort_buffer=128M +set-variable = read-buffer=2M +set-variable = write-buffer=2M + +[myisamchk] +set-variable = key_buffer=128M +set-variable = sort_buffer=128M +set-variable = read-buffer=2M +set-variable = write-buffer=2M |