OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Ralf S. Engelschall
Root: /v/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-src Date: 11-Oct-2006 23:31:50
Branch: HEAD Handle: 2006101122315000
Modified files:
openpkg-src/mysql51 my.cnf
Log:
as we now touched the contents of the my.cnf file anyway, finally do
what I wanted to do since a longer time: cleanup the text from a
cosmetical point of view to be more aligned and concise
Summary:
Revision Changes Path
1.3 +45 -69 openpkg-src/mysql51/my.cnf
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-src/mysql51/my.cnf
============================================================================
$ cvs diff -u -r1.2 -r1.3 my.cnf
--- openpkg-src/mysql51/my.cnf 11 Oct 2006 18:29:02 -0000 1.2
+++ openpkg-src/mysql51/my.cnf 11 Oct 2006 21:31:50 -0000 1.3
@@ -3,83 +3,59 @@
##
[client]
-socket = @l_prefix@/var/mysql/mysql.sock
-port = 3306
-[mysqld]
-#
-# Network settings
-#
+socket = @l_prefix@/var/mysql/mysql.sock
+port = 3306
-bind-address = 127.0.0.1
-port = 3306
+[mysqld]
-# Unix domain socket only, disables TCP/IP
+bind-address = 127.0.0.1
+port = 3306
#skip-networking
-#
-# Log file settings
-#
-
-# log file destinations (must be in sync with settings in rc.conf)
-log = @l_prefix@/var/mysql/common.log
-# binary log (use instead of log-update, server-id must be unique for
-# replication)
-#log-bin = @l_prefix@/var/mysql/binary.log
-#server-id = 1
-
-#
-# Performance settings
-#
-
-# most important tuning parameters for mysqld
-key_buffer_size=64M
-table_cache=256
-
-# less important tuning parameters (change if special problems occur)
-join_buffer_size=1M
-max_connections=1000
-max_connect_errors=10
-max_delayed_threads=20
-max_heap_table_size=16777216
-max_sort_length=1024
-max_user_connections=1000
-record_buffer=131072
-sort_buffer=4M
-key_buffer=1M
-tmp_table_size=32M
-
-# permanent query caching
-query_cache_type=1
-# maximum caching size of an individual query
-query_cache_limit=1M
-# maximum query cache size
-query_cache_size=32M
-
-# minimum chars for full-text search (FTS) index
-#ft_min_word_len=3
+tmpdir = @l_prefix@/var/mysql/tmp
+log = @l_prefix@/var/mysql/common.log
+#log-bin = @l_prefix@/var/mysql/binary.log
+#server-id = 1
+
+# most important tuning parameters
+key_buffer_size = 64M
+table_cache = 256
+
+# less important tuning parameters
+join_buffer_size = 1M
+max_connections = 1000
+max_connect_errors = 10
+max_delayed_threads = 20
+max_heap_table_size = 16777216
+max_sort_length = 1024
+max_user_connections = 1000
+record_buffer = 131072
+sort_buffer = 4M
+key_buffer = 1M
+tmp_table_size = 32M
+ft_min_word_len = 3
+
+# query cache
+query_cache_type = 1
+query_cache_limit = 1M
+query_cache_size = 32M
<with_innobase>
-# Innobase DB
-innodb_buffer_pool_size=70M
-innodb_additional_mem_pool_size=2M
-innodb_log_files_in_group=3
-innodb_log_file_size=20M
-innodb_log_buffer_size=8M
-innodb_lock_wait_timeout=50
+# Innobase DB storage engine
+innodb_buffer_pool_size = 70M
+innodb_additional_mem_pool_size = 2M
+innodb_log_files_in_group = 3
+innodb_log_file_size = 20M
+innodb_log_buffer_size = 8M
+innodb_lock_wait_timeout = 50
</with_innobase>
-#
-# Miscellaneous
-#
-
-# directory for temporary tables
[EMAIL PROTECTED]@/var/mysql/tmp
-
[mysqld_safe]
-datadir = @l_prefix@/var/mysql
-socket = @l_prefix@/var/mysql/mysql.sock
-pid_file = @l_prefix@/var/mysql/mysqld.pid
-user = @l_rusr@
-basedir = @l_prefix@
+
+datadir = @l_prefix@/var/mysql
+socket = @l_prefix@/var/mysql/mysql.sock
+pid_file = @l_prefix@/var/mysql/mysqld.pid
+user = @l_rusr@
+basedir = @l_prefix@
@@ .
______________________________________________________________________
The OpenPKG Project www.openpkg.org
CVS Repository Commit List [email protected]
