1 # The MySQL server configuration file.
4 # One can use all long options that the mysqld supports.
5 # Run mysqld with --help to get a whole list of available options
7 # This section must be the first!
9 datadir = @clusterdir@/mysqldb/db
10 pid-file = @clusterdir@/mysqldb/mysql.pid
11 socket = @clusterdir@/mysqldb/mysql.sock
16 #ssl-ca = /etc/ssl/certs/mysql-@mysqlversion@/ca-cert.pem
17 #ssl-cert = /etc/ssl/certs/mysql-@mysqlversion@/server-cert.pem
18 #ssl-key = /etc/ssl/certs/mysql-@mysqlversion@/server-key.pem
19 #ssl-cipher = DHE-RSA-AES256-SHA
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.
26 # IP address to bind to
27 #bind-address=127.0.0.1
32 # Emergency option. Use only if you really need this.
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
45 # mysqld error log (stderr)
46 log-error = /var/log/mysql/@mysqlversion@/mysqld.log
47 log-error-verbosity = 2
51 slow-query-log-file = /var/log/mysql/@mysqlversion@/slow.log
53 # Log connections and queries. It slows down MySQL so it's disabled by default
55 #general-log-file = /var/log/mysql/@mysqlversion/query.log
58 #log-update = /var/log/mysql/@mysqlversion@/update
59 # Log some extra information to update log
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.
69 # used for logs rotation or status check for replications