diff options
Diffstat (limited to 'abs/core/mysql/my.cnf')
| -rwxr-xr-x | abs/core/mysql/my.cnf | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf index 6d24cfa..f0b87da 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,20 +26,21 @@ 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 = 384M 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 +tmp_table_size = 32M +max_heap_table_size = 32M +sort_buffer_size = 2M +read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 -query_cache_size = 16M +query_cache_size = 32M join_buffer_size = 128K @@ -143,8 +143,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 |