summaryrefslogtreecommitdiff
path: root/support-files/my-small.cnf.sh
diff options
context:
space:
mode:
Diffstat (limited to 'support-files/my-small.cnf.sh')
-rw-r--r--support-files/my-small.cnf.sh7
1 files changed, 7 insertions, 0 deletions
diff --git a/support-files/my-small.cnf.sh b/support-files/my-small.cnf.sh
index c0a86ae9671..99274cd1306 100644
--- a/support-files/my-small.cnf.sh
+++ b/support-files/my-small.cnf.sh
@@ -51,6 +51,13 @@ server-id = 1
# binary logging format - mixed recommended
#binlog_format=mixed
+# Causes updates to non-transactional engines using statement format to be
+# written directly to binary log. Before using this option make sure that
+# there are no dependencies between transactional and non-transactional
+# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
+# t_innodb; otherwise, slaves may diverge from the master.
+#binlog_direct_non_transactional_updates=TRUE
+
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = @localstatedir@/
#innodb_data_file_path = ibdata1:10M:autoextend