- enable archive-storage-engine; rel 2

[packages/mysql.git] / mysqld.conf

diff --git a/mysqld.conf b/mysqld.conf
index 9a8dba62da4bf351742e37d25d4e9f7c74e13837..c4f69059f45adc85bf1e7fe790ff38efc9756772 100644 (file)
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -4,16 +4,15 @@
 ; $Id$
 
 ; This section must be the first!
-[mysqld] 
-datadir     = /var/lib/mysql/db
-pid-file    = /var/lib/mysql/mysql.pid
+[mysqld]
+datadir     = /var/lib/mysql/mysqldb/db
+pid-file    = /var/lib/mysql/mysqldb/mysql.pid
 port        = 3306
 socket      = /var/lib/mysql/mysql.sock
 user        = mysql
 
 ;character-set-server=latin2
 ;collation-server=latin2_general_ci
-;init-connect="SET NAMES latin2"
 
 ; Use passwords compatible with old 4.0 mysqld
 ;old-passwords
@@ -21,7 +20,7 @@ user        = mysql
 ; Don't use system locking
 ;skip-locking
 
-; Don't allow connections over the network by default 
+; Don't allow connections over the network by default
 skip-networking
 
 ; Emergency option. Use only if you really need this.
@@ -30,7 +29,7 @@ skip-networking
 ; Log connections and queries. It slows down MySQL so it's disabled by default
 ;log        = /var/log/mysql/log
 
-; Log all updates. 
+; Log all updates.
 ;log-update = /var/log/mysql/update
 ; Log some extra information to update log
 ;log-long-format
@@ -69,6 +68,8 @@ skip-networking
 ;set-variable = tmp_table_size=1M
 ;set-variable = thread_stack=65536
 ;set-variable = wait_timeout=28800
+;set-variable = query_cache_size=8M
+;set-variable = query_cache_limit=1M
 
 
 
@@ -81,14 +82,15 @@ skip-networking
 
 ; Repair automatically on open if the table wasn't closed properly.
 myisam-recover
-; 
+;
 ;set-variable = myisam_sort_buffer_size=4M
 
 
 
 ;
-; InnoDB tables options (see MySQL manual) 
+; InnoDB tables options (see MySQL manual)
 ;
+;skip-innodb
 
 ;innodb_data_home_dir = /var/lib/mysql/innodb/data
 ;innodb_data_file_path = 00:10M;01:20M
@@ -113,7 +115,7 @@ myisam-recover
 ; Don't use berkeley db (saves a lot of memory)
 ;skip-bdb
 
-;bdb-home          =  /var/lib/mysql/db 
+;bdb-home          =  /var/lib/mysql/db
 ;bdb-log-dir       =  /var/lib/mysql/bdb/log
 ;bdb-tmpdir        =  /var/lib/mysql/bdb/tmp
 
@@ -121,21 +123,21 @@ myisam-recover
 ;bdb-lock-detect   =  DEFAULT
 
 ; Don't synchronously flush logs.
-;bdb-no-sync 
+;bdb-no-sync
 
 ; Don't start Berkeley DB in recover mode.
 ;bdb-no-recover
 
-; Start Berkeley DB in multi-process mode (Don't use `DB_PRIVATE' 
+; Start Berkeley DB in multi-process mode (Don't use `DB_PRIVATE'
 ; when initializing Berkeley DB
 ;bdb-shared-data
 
-;set-variable      = bdb_max_lock=1000 
+;set-variable      = bdb_max_lock=1000
 
 
 ; used for logs rotation
 [mysqladmin]
-user        = mysql_logrotate 
-password    = 
+user        = mysql_logrotate
+password    =
 
 ; vim=syn=dosini