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 /abs/core-testing/mysql/my.cnf | |
| 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.
Diffstat (limited to 'abs/core-testing/mysql/my.cnf')
| -rw-r--r-- | abs/core-testing/mysql/my.cnf | 11 |
1 files changed, 6 insertions, 5 deletions
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. |