- expire-logs-days sample

[packages/mysql.git] / mysqld.conf

diff --git a/mysqld.conf b/mysqld.conf
index bbc5e5bed3bc38e4fdee0d823a96734176e9c79a..56e35c3af527a2f71624e28f8d88da185d61aa36 100644 (file)
--- a/mysqld.conf
+++ b/mysqld.conf
@@ -11,6 +11,12 @@ socket      = @clusterdir@/mysqldb/mysql.sock
 port        = 3306
 user        = mysql
 
+; ssl options
+;ssl-ca = /etc/ssl/certs/mysql/ca-cert.pem
+;ssl-cert = /etc/ssl/certs/mysql/server-cert.pem
+;ssl-key = /etc/ssl/certs/mysql/server-key.pem
+;ssl-cipher = DHE-RSA-AES256-SHA
+
 ;character-set-server=latin2
 ;collation-server=latin2_general_ci
 ;skip-character-set-client-handshake
@@ -59,6 +65,10 @@ skip-networking
 ; binary logging is required for replication
 ;log-bin=mysql-bin
 
+; If non-zero, binary logs will be purged after expire_logs_days days; possible
+; purges happen at startup and at binary log rotation.
+;expire-logs-days=30
+
 ; Normally, a slave does not log to its own binary log any updates that are
 ; received from a master server. This option tells the slave to log the updates
 ; performed by its SQL thread to its own binary log. For this option to have
@@ -71,17 +81,27 @@ skip-networking
 ; defaults to 1 if master-host is not set but will not function as a master if omitted
 ;server-id=2
 
+; To set up N master servers, set the variables like this:
+; Set auto_increment_increment to N on each master.
+; Set each of the N masters to have a different auto_increment_offset, using the values 1, 2, ..., N
+;auto-increment-offset=1
+;auto-increment-increment=2
+
 ; databases to be included in binlog
 ;binlog-do-db=db1
 ; or excluded
 ;binlog-ignore-db=mysql
 ;binlog-ignore-db=test
 
+; mysqld error log (stderr)
+log-error = /var/log/mysql/mysqld.log
+log-warnings = 2
+
 ; Log slow queries
 log-slow-queries = /var/log/mysql/slow.log
 
 ; Log connections and queries. It slows down MySQL so it's disabled by default
-;log        = /var/log/mysql/log
+;log = /var/log/mysql/query.log
 
 ; Log all updates.
 ;log-update = /var/log/mysql/update
@@ -209,4 +229,4 @@ set-variable = innodb_log_buffer_size=1M
 user        = mysql_sysadmin
 password    =
 
-; vim:syn=dosini
+; vim:ft=dosini