vitess.io/vitess@v0.16.2/config/mycnf/default.cnf (about) 1 # Global configuration that is auto-included for all MySQL/MariaDB versions 2 3 datadir = {{.DataDir}} 4 innodb_data_home_dir = {{.InnodbDataHomeDir}} 5 innodb_log_group_home_dir = {{.InnodbLogGroupHomeDir}} 6 log-error = {{.ErrorLogPath}} 7 log-bin = {{.BinLogPath}} 8 relay-log = {{.RelayLogPath}} 9 relay-log-index = {{.RelayLogIndexPath}} 10 pid-file = {{.PidFile}} 11 port = {{.MysqlPort}} 12 13 {{if .SecureFilePriv}} 14 secure-file-priv = {{.SecureFilePriv}} 15 {{end}} 16 17 # all db instances should start in read-only mode - once the db is started and 18 # fully functional, we'll push it into read-write mode 19 read-only 20 server-id = {{.ServerID}} 21 22 # all db instances should skip starting replication threads - that way we can do any 23 # additional configuration (like enabling semi-sync) before we connect to 24 # the source. 25 skip_slave_start 26 socket = {{.SocketFile}} 27 tmpdir = {{.TmpDir}} 28 29 slow-query-log-file = {{.SlowLogPath}} 30 31 # These are sensible defaults that apply to all MySQL/MariaDB versions 32 33 long_query_time = 2 34 slow-query-log 35 skip-name-resolve 36 connect_timeout = 30 37 innodb_lock_wait_timeout = 20 38 max_allowed_packet = 64M 39 max_connections = 500 40 41