summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBritney Fransen <brfransen@gmail.com>2011-10-15 23:47:42 (GMT)
committerBritney Fransen <brfransen@gmail.com>2011-10-15 23:47:42 (GMT)
commitee1df8d21bd61872c711ee95a1b56bd261eef082 (patch)
tree46cc14f736cced697600762091a142e243bdf5bd
parent81204ffbed9e519db171c62653b91a170a2ae299 (diff)
downloadlinhes_pkgbuild-ee1df8d21bd61872c711ee95a1b56bd261eef082.zip
linhes_pkgbuild-ee1df8d21bd61872c711ee95a1b56bd261eef082.tar.gz
linhes_pkgbuild-ee1df8d21bd61872c711ee95a1b56bd261eef082.tar.bz2
mysql: update to 5.1.59; change settings for better performance
-rw-r--r--abs/core/mysql/PKGBUILD6
-rw-r--r--abs/core/mysql/my.cnf39
2 files changed, 29 insertions, 16 deletions
diff --git a/abs/core/mysql/PKGBUILD b/abs/core/mysql/PKGBUILD
index 9602157..3ce1aeb 100644
--- a/abs/core/mysql/PKGBUILD
+++ b/abs/core/mysql/PKGBUILD
@@ -5,7 +5,7 @@
pkgbase=mysql
pkgname=('libmysqlclient' 'mysql-clients' 'mysql')
-pkgver=5.1.52
+pkgver=5.1.59
pkgrel=1
arch=('i686' 'x86_64')
license=('GPL')
@@ -103,7 +103,7 @@ package_mysql(){
rm -rf ${pkgdir}/usr/{mysql-test,sql-bench}
rm -f ${pkgdir}/usr/lib/mysql/plugin/*.a
}
-md5sums=('43c11ad3dded693393c4815d24e2b0a5'
+md5sums=('1e89816164692f44f768024db4bc05f6'
'2234207625baa29b2ff7d7b4f088abce'
- '175b269b665019689d786f5af0968046'
+ 'd60099985e68e36b156423fca6b50924'
'a97e574945e19de3908575b956241026')
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf
index 4eaeaa0..6f0a683 100644
--- a/abs/core/mysql/my.cnf
+++ b/abs/core/mysql/my.cnf
@@ -1,12 +1,17 @@
-# mysql config file for medium systems.
+# Example MySQL config file for large systems.
#
-# This is for a system with little memory (32M - 64M) where MySQL plays
-# a important part and systems up to 128M where MySQL is used together with
-# other programs (like a web server)
+# This is for a large system with memory = 512M where the system runs mainly
+# MySQL.
#
-# One can in this file use all long options that the program supports.
-# If you want to know which options a program support, run the program
-# with --help option.
+# You can copy this file to
+# /etc/my.cnf to set global options,
+# mysql-data-dir/my.cnf to set server-specific options (in this
+# installation this directory is /var) or
+# ~/.my.cnf to set user-specific options.
+#
+# In this file, you can use all long options that a program supports.
+# If you want to know which options a program supports, run the program
+# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
@@ -21,13 +26,21 @@ socket = /var/run/mysqld/mysqld.sock
port = 3306
socket = /var/run/mysqld/mysqld.sock
datadir = /data/srv/mysql
-skip-external-locking
-key_buffer = 16M
+skip-locking
+key_buffer_size = 80M
max_allowed_packet = 1M
-table_cache = 64
-sort_buffer_size = 512K
-net_buffer_length = 16K
-myisam_sort_buffer_size = 8M
+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
+myisam_sort_buffer_size = 64M
+thread_cache_size = 8
+query_cache_size = 16M
+join_buffer_size = 128K
+# Try number of CPU's*2 for thread_concurrency
+#thread_concurrency = 8
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.