diff options
Diffstat (limited to 'abs/core/mysql/my.cnf')
-rw-r--r-- | abs/core/mysql/my.cnf | 39 |
1 files changed, 26 insertions, 13 deletions
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf index 4eaeaa0..6f0a683 100644 --- a/abs/core/mysql/my.cnf +++ b/abs/core/mysql/my.cnf @@ -1,12 +1,17 @@ -# mysql config file for medium systems. +# Example MySQL config file for large systems. # -# This is for a system with little memory (32M - 64M) where MySQL plays -# a important part and systems up to 128M where MySQL is used together with -# other programs (like a web server) +# This is for a large system with memory = 512M where the system runs mainly +# MySQL. # -# 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. +# You can copy this file to +# /etc/my.cnf to set global options, +# mysql-data-dir/my.cnf to set server-specific options (in this +# installation this directory is /var) or +# ~/.my.cnf to set user-specific options. +# +# In this file, you can use all long options that a program supports. +# If you want to know which options a program supports, run the program +# with the "--help" option. # The following options will be passed to all MySQL clients [client] @@ -21,13 +26,21 @@ socket = /var/run/mysqld/mysqld.sock port = 3306 socket = /var/run/mysqld/mysqld.sock datadir = /data/srv/mysql -skip-external-locking -key_buffer = 16M +skip-locking +key_buffer_size = 80M max_allowed_packet = 1M -table_cache = 64 -sort_buffer_size = 512K -net_buffer_length = 16K -myisam_sort_buffer_size = 8M +table_open_cache = 256 +tmp_table_size = 16M +max_heap_table_size = 16M +sort_buffer_size = 1M +read_buffer_size = 1M +read_rnd_buffer_size = 4M +myisam_sort_buffer_size = 64M +thread_cache_size = 8 +query_cache_size = 16M +join_buffer_size = 128K +# Try number of CPU's*2 for thread_concurrency +#thread_concurrency = 8 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. |