diff options
Diffstat (limited to 'abs/core/mysql/my.cnf')
| -rwxr-xr-x | abs/core/mysql/my.cnf | 31 |
1 files changed, 16 insertions, 15 deletions
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf index 6d24cfa..da26759 100755 --- a/abs/core/mysql/my.cnf +++ b/abs/core/mysql/my.cnf @@ -1,8 +1,7 @@ -# MySQL config file for medium systems. +# Example MySQL config file for very large systems. # -# This is for a system with little memory (32M - 64M) where MySQL plays -# an important part, or systems up to 128M where MySQL is used together with -# other programs (such as a web server) +# This is for a large system with memory of 1G-2G where the system runs mainly +# MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. @@ -27,21 +26,23 @@ socket = /var/run/mysqld/mysqld.sock port = 3306 socket = /var/run/mysqld/mysqld.sock datadir = /data/srv/mysql + skip-external-locking net_buffer_length = 8K -key_buffer_size = 80M +key_buffer_size = 96M max_allowed_packet = 1M -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 +tmp_table_size = 128M +max_heap_table_size = 128M +sort_buffer_size = 2M +read_buffer_size = 2M +read_rnd_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache_size = 8 -query_cache_size = 16M -join_buffer_size = 128K +query_cache_type = 1 +query_cache_size = 64M +query_cache_limit = 2M +join_buffer_size = 2M # Don't listen on a TCP/IP port at all. This can be a security enhancement, @@ -143,8 +144,8 @@ no-auto-rehash #safe-updates [myisamchk] -key_buffer_size = 20M -sort_buffer_size = 20M +key_buffer_size = 256M +sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M |