diff options
author | James Meyer <james.meyer@operamail.com> | 2010-10-03 01:23:54 (GMT) |
---|---|---|
committer | James Meyer <james.meyer@operamail.com> | 2010-10-03 01:23:54 (GMT) |
commit | 97c41b16d5d9ecbf1138380edbe480ae04b8fa58 (patch) | |
tree | acb5c5686d8e2f959f1d3263a13b57934b8b8d89 /abs/core-testing/mysql/my.cnf | |
parent | 4b5705e93f9be197a4ab40bd91e0368d45a95fd9 (diff) | |
download | linhes_pkgbuild-97c41b16d5d9ecbf1138380edbe480ae04b8fa58.zip linhes_pkgbuild-97c41b16d5d9ecbf1138380edbe480ae04b8fa58.tar.gz linhes_pkgbuild-97c41b16d5d9ecbf1138380edbe480ae04b8fa58.tar.bz2 |
mysql: using unmodified arch pkgbuild.
only my.cnf is modified to reflect new data dir since the init scripts no longer allow for dynmic setting of this value.
cache and memory values are back at their default, they can be restored at a later date when things are stable.
Diffstat (limited to 'abs/core-testing/mysql/my.cnf')
-rw-r--r-- | abs/core-testing/mysql/my.cnf | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/abs/core-testing/mysql/my.cnf b/abs/core-testing/mysql/my.cnf index e13331e..4eaeaa0 100644 --- a/abs/core-testing/mysql/my.cnf +++ b/abs/core-testing/mysql/my.cnf @@ -1,4 +1,8 @@ -# mysql config file for LinHES. +# 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) # # 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 @@ -8,27 +12,22 @@ [client] #password = your_password port = 3306 -socket = /tmp/mysql.sock +socket = /var/run/mysqld/mysqld.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 -socket = /tmp/mysql.sock +socket = /var/run/mysqld/mysqld.sock datadir = /data/srv/mysql -skip-locking +skip-external-locking key_buffer = 16M max_allowed_packet = 1M 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. @@ -114,7 +113,6 @@ server-id = 1 #innodb_data_home_dir = /var/lib/mysql #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql -#innodb_log_arch_dir = /var/lib/mysql # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M |