summaryrefslogtreecommitdiffstats
path: root/abs/core/mysql/my.cnf
diff options
context:
space:
mode:
authorBritney Fransen <brfransen@gmail.com>2014-12-10 14:26:40 (GMT)
committerBritney Fransen <brfransen@gmail.com>2014-12-10 14:26:40 (GMT)
commit8570bfa9cd30521c86e27984f34a3a81456a9c25 (patch)
tree7b901c088531a50b6ec1637040cebb66b34abfe8 /abs/core/mysql/my.cnf
parent050fb48e107e7f0aa78d3a0c0b6b937bd3b6c563 (diff)
downloadlinhes_pkgbuild-8570bfa9cd30521c86e27984f34a3a81456a9c25.zip
linhes_pkgbuild-8570bfa9cd30521c86e27984f34a3a81456a9c25.tar.gz
linhes_pkgbuild-8570bfa9cd30521c86e27984f34a3a81456a9c25.tar.bz2
mysql: update to 5.6.21
Diffstat (limited to 'abs/core/mysql/my.cnf')
-rwxr-xr-xabs/core/mysql/my.cnf24
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