diff options
Diffstat (limited to 'abs/core/mysql/my.cnf')
| -rw-r--r-- | abs/core/mysql/my.cnf | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/abs/core/mysql/my.cnf b/abs/core/mysql/my.cnf index e13331e..4eaeaa0 100644 --- a/abs/core/mysql/my.cnf +++ b/abs/core/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 |