diff options
| author | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-05-17 02:59:11 (GMT) |
|---|---|---|
| committer | Cecil Hugh Watson <knoppmyth@gmail.com> | 2010-05-17 02:59:11 (GMT) |
| commit | ee8ea9e2cca5abc7ab5c185b14caccd7df28fc3a (patch) | |
| tree | 709061cf10037cfd009e92d1ff3823fa31b446b5 | |
| parent | 39e3649d7d9d3b21e69cbbfa610f63e6162d9d3a (diff) | |
| download | linhes_pkgbuild-ee8ea9e2cca5abc7ab5c185b14caccd7df28fc3a.zip linhes_pkgbuild-ee8ea9e2cca5abc7ab5c185b14caccd7df28fc3a.tar.gz linhes_pkgbuild-ee8ea9e2cca5abc7ab5c185b14caccd7df28fc3a.tar.bz2 | |
mysql:changes to my.cnf based on installing and running mysqltuner.pl.
| -rw-r--r-- | abs/core-testing/mysql/PKGBUILD | 8 | ||||
| -rw-r--r-- | abs/core-testing/mysql/__changelog | 5 | ||||
| -rw-r--r-- | abs/core-testing/mysql/my.cnf | 11 |
3 files changed, 18 insertions, 6 deletions
diff --git a/abs/core-testing/mysql/PKGBUILD b/abs/core-testing/mysql/PKGBUILD index 11df8fb..c91ac41 100644 --- a/abs/core-testing/mysql/PKGBUILD +++ b/abs/core-testing/mysql/PKGBUILD @@ -3,7 +3,7 @@ # Contributor: judd <jvinet@zeroflux.org> pkgname=mysql pkgver=5.0.75 -pkgrel=3 +pkgrel=4 pkgdesc="A fast SQL database server" arch=(i686 x86_64) backup=(etc/my.cnf etc/conf.d/mysqld) @@ -48,3 +48,9 @@ build() { install -D -m644 ../mysqld.conf.d ${startdir}/pkg/etc/conf.d/mysqld rm -f ${startdir}/pkg/usr/bin/mysql_config } + +md5sums=('a234f0a60a7f8c290d9875cba3a2c5a2' + 'e892aac36cbeb57f0e003ec0936afb3b' + 'cfff3585dd70cde3ac1ce69e64008733' + '078f6e824d6097d558bcf7c16d508d92' + 'd81d1f51e9ee6941425a63456d07cb21') diff --git a/abs/core-testing/mysql/__changelog b/abs/core-testing/mysql/__changelog index 4fa7078..aa066aa 100644 --- a/abs/core-testing/mysql/__changelog +++ b/abs/core-testing/mysql/__changelog @@ -1,6 +1,11 @@ my.cnf -enable networking -datadir /data/srv/mysql +-query_cache_size +-tmp_table_size +-max_heap_table_size +-thread_cache_size +-table_cache mysqld -redirect output to /dev/null diff --git a/abs/core-testing/mysql/my.cnf b/abs/core-testing/mysql/my.cnf index 7202fcd..e13331e 100644 --- a/abs/core-testing/mysql/my.cnf +++ b/abs/core-testing/mysql/my.cnf @@ -1,8 +1,4 @@ -# mysql config file for medium 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) +# mysql config file for LinHES. # # 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 @@ -28,6 +24,11 @@ table_cache = 64 sort_buffer_size = 512K net_buffer_length = 16K myisam_sort_buffer_size = 8M +query_cache_size = 8M +tmp_table_size = 36M +max_heap_table_size = 24M +thread_cache_size = 4 +table_cache = 96 # 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. |