diff options
Diffstat (limited to 'support-files/my-huge.cnf.sh')
| -rw-r--r-- | support-files/my-huge.cnf.sh | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/support-files/my-huge.cnf.sh b/support-files/my-huge.cnf.sh new file mode 100644 index 00000000000..fd0d70b2d04 --- /dev/null +++ b/support-files/my-huge.cnf.sh @@ -0,0 +1,64 @@ +# Example mysql config file for very large systems. +# +# This is for large system with memory of 1G-2G 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@ +skip-locking +set-variable = key_buffer=384M +set-variable = max_allowed_packet=1M +set-variable = table_cache=512 +set-variable = sort_buffer=2M +set-variable = record_buffer=2M +set-variable = thread_cache=8 +set-variable = thread_concurrency=8 # Try number of CPU's*2 +set-variable = myisam_sort_buffer_size=64M +log-update + +# Uncomment the following if you are using BDB tables +#set-variable = bdb_cache_size=384M + +# 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=256M +set-variable = sort_buffer=256M +set-variable = read_buffer=2M +set-variable = write_buffer=2M + +[myisamchk] +set-variable = key_buffer=256M +set-variable = sort_buffer=256M +set-variable = read_buffer=2M +set-variable = write_buffer=2M |