diff options
| -rw-r--r-- | abs/core/mysql/PKGBUILD | 6 | ||||
| -rw-r--r-- | abs/core/mysql/my.cnf | 39 |
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. |