diff options
| author | Britney Fransen <brfransen@gmail.com> | 2014-12-10 20:16:25 (GMT) |
|---|---|---|
| committer | Britney Fransen <brfransen@gmail.com> | 2014-12-10 20:16:25 (GMT) |
| commit | 5c9d6e7ec4c9d5c167c5846eabfd717e4b0d6c3a (patch) | |
| tree | e89fea689c2749a8dbe9989f214d979c3b96f907 /abs/core/mysql/my.cnf | |
| parent | 8570bfa9cd30521c86e27984f34a3a81456a9c25 (diff) | |
| download | linhes_pkgbuild-5c9d6e7ec4c9d5c167c5846eabfd717e4b0d6c3a.zip linhes_pkgbuild-5c9d6e7ec4c9d5c167c5846eabfd717e4b0d6c3a.tar.gz linhes_pkgbuild-5c9d6e7ec4c9d5c167c5846eabfd717e4b0d6c3a.tar.bz2 | |
mysql: update to 5.6.22.
adjust some my.cnf 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, |