diff options
Diffstat (limited to 'abs/core/mysql/my.cnf')
| -rwxr-xr-x | abs/core/mysql/my.cnf | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf index f0b87da..da26759 100755 --- a/abs/core/mysql/my.cnf +++ b/abs/core/mysql/my.cnf @@ -30,18 +30,19 @@ datadir = /data/srv/mysql skip-external-locking net_buffer_length = 8K -key_buffer_size = 384M +key_buffer_size = 96M max_allowed_packet = 1M -table_open_cache = 256 -tmp_table_size = 32M -max_heap_table_size = 32M +tmp_table_size = 128M +max_heap_table_size = 128M sort_buffer_size = 2M read_buffer_size = 2M -read_rnd_buffer_size = 4M +read_rnd_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache_size = 8 -query_cache_size = 32M -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, |