# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
+# Default storage engine is InnoDB since 5.5.5
+# You may revert to previous behaviour by specifiying MyISAM here
+#default-storage-engine=InnoDB
+
# 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.
# Emergency option. Use only if you really need this.
#skip-grant-tables
-# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_default-storage-engine
-# Default storage engine is InnoDB since 5.5.5
-# You may revert to previous behaviour by specifiying MyISAM here
+# http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-storage-engine
#default-storage-engine=MyISAM
# Replication Master Server (default)
# mysqld error log (stderr)
log-error = /var/log/mysql/mysqld.log
-log-warnings = 2
+log-error-verbosity = 2
# Log slow queries
slow-query-log
# Internal server variables
#
-explicit_defaults_for_timestamp = true
#back_log=5
#connect_timeout=5
#delayed_insert_timeout=300
# Fulltext search options
#ft_min_word_len=2
-# Turn off nonstandard TIMESTAMP behaviors
-# http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
-explicit_defaults_for_timestamp = true
-
#
# MyISAM tables options
#
#delay-key-write-for-all-tables
# Repair automatically on open if the table wasn't closed properly.
-# http://dev.mysql.com/doc/refman/5.6/en/server-options.html#option_mysqld_myisam-recover-options
+# http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_myisam-recover-options
myisam-recover-options
-#
-#myisam_sort_buffer_size=4M
+#myisam_sort_buffer_size=4M
# To completely disable InnoDB, use this option
# this makes all innodb options being unknown options (including skip-innodb)
# these are actual defaults (as of 5.0.26)
innodb_data_home_dir = @clusterdir@/mysqldb/db
-innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = @clusterdir@/mysqldb/db
innodb_log_files_in_group=2
-innodb_log_file_size=5M
-innodb_log_buffer_size=1M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = @clusterdir@/innodb/log