[packages/mysql.git] / mysqld.conf

# The MySQL server configuration file.
# vim:ft=mycnf
#
# One can use all long options that the mysqld supports.
# Run mysqld with --help to get a whole list of available options

# This section must be the first!
[mysqld]
datadir     = @clusterdir@/mysqldb/db
pid-file    = @clusterdir@/mysqldb/mysql.pid
socket      = @clusterdir@/mysqldb/mysql.sock
port        = 3306
user        = mysql

# ssl options
#ssl-ca = /etc/ssl/certs/mysql{MYSQL_MAJOR}/ca-cert.pem
#ssl-cert = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-cert.pem
#ssl-key = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-key.pem
#ssl-cipher = DHE-RSA-AES256-SHA

# Don't listen on a TCP/IP port at all. This is a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets.
skip-networking

# IP address to bind to
#bind-address=127.0.0.1

# no dns
#skip-name-resolve

# Emergency option. Use only if you really need this.
#skip-grant-tables

# https://dev.mysql.com/doc/refman/5.6/en/log-destinations.html
# global option where logs be written
# affects slow-query-log, general-log direcives
# Possible values: FILE, TABLE
# NOTE: when using table, you can switch to MyISAM, but the contents is still
# not replicated, also mysqldump will not dump data, only create table
# statements
#log-output = TABLE
log-output = FILE

# mysqld error log (stderr)
log-error = /var/log/mysql{MYSQL_MAJOR}/mysqld.log
log-error-verbosity = 2

# Log slow queries
slow-query-log
slow-query-log-file = /var/log/mysql{MYSQL_MAJOR}/slow.log

# Log connections and queries. It slows down MySQL so it's disabled by default
#general-log
#general-log-file = /var/log/mysql{MYSQL_MAJOR}/query.log

# Log all updates.
#log-update = /var/log/mysql{MYSQL_MAJOR}/update
# Log some extra information to update log
#log-long-format

# Language
#lc-messages = pl_PL

# Path for temporary files. Several paths may be specified, separated by a
# colon (:), in this case they are used in a round-robin fashion.
#tmpdir      = /var/tmp

# used for logs rotation or status check for replications
[client]
user        = mysql_sysadmin
password    =
Commit	Line	Data
	1	# The MySQL server configuration file.
	2	# vim:ft=mycnf
	3	#
	4	# One can use all long options that the mysqld supports.
	5	# Run mysqld with --help to get a whole list of available options
	6
	7	# This section must be the first!
	8	[mysqld]
	9	datadir = @clusterdir@/mysqldb/db
	10	pid-file = @clusterdir@/mysqldb/mysql.pid
	11	socket = @clusterdir@/mysqldb/mysql.sock
	12	port = 3306
	13	user = mysql
	14
	15	# ssl options
	16	#ssl-ca = /etc/ssl/certs/mysql{MYSQL_MAJOR}/ca-cert.pem
	17	#ssl-cert = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-cert.pem
	18	#ssl-key = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-key.pem
	19	#ssl-cipher = DHE-RSA-AES256-SHA
	20
	21	# Don't listen on a TCP/IP port at all. This is a security enhancement,
	22	# if all processes that need to connect to mysqld run on the same host.
	23	# All interaction with mysqld must be made via Unix sockets.
	24	skip-networking
	25
	26	# IP address to bind to
	27	#bind-address=127.0.0.1
	28
	29	# no dns
	30	#skip-name-resolve
	31
	32	# Emergency option. Use only if you really need this.
	33	#skip-grant-tables
	34
	35	# https://dev.mysql.com/doc/refman/5.6/en/log-destinations.html
	36	# global option where logs be written
	37	# affects slow-query-log, general-log direcives
	38	# Possible values: FILE, TABLE
	39	# NOTE: when using table, you can switch to MyISAM, but the contents is still
	40	# not replicated, also mysqldump will not dump data, only create table
	41	# statements
	42	#log-output = TABLE
	43	log-output = FILE
	44
	45	# mysqld error log (stderr)
	46	log-error = /var/log/mysql{MYSQL_MAJOR}/mysqld.log
	47	log-error-verbosity = 2
	48
	49	# Log slow queries
	50	slow-query-log
	51	slow-query-log-file = /var/log/mysql{MYSQL_MAJOR}/slow.log
	52
	53	# Log connections and queries. It slows down MySQL so it's disabled by default
	54	#general-log
	55	#general-log-file = /var/log/mysql{MYSQL_MAJOR}/query.log
	56
	57	# Log all updates.
	58	#log-update = /var/log/mysql{MYSQL_MAJOR}/update
	59	# Log some extra information to update log
	60	#log-long-format
	61
	62	# Language
	63	#lc-messages = pl_PL
	64
	65	# Path for temporary files. Several paths may be specified, separated by a
	66	# colon (:), in this case they are used in a round-robin fashion.
	67	#tmpdir = /var/tmp
	68
	69	# used for logs rotation or status check for replications
	70	[client]
	71	user = mysql_sysadmin
	72	password =