summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <serg@sergbook.mysql.com>2002-11-06 09:52:13 +0100
committerunknown <serg@sergbook.mysql.com>2002-11-06 09:52:13 +0100
commitf9b7e3abc8bb0b3440fd2a10e0b201cefb587f4a (patch)
tree80b3f1d019ca187e40e729161a67c9b7941a047c /Docs
parent781c7901cbe120bec3776fcec23fe6fc13ca1e64 (diff)
parent0e56af0744cb2d66cc44ee9685f6e94bf6e6a946 (diff)
downloadmariadb-git-f9b7e3abc8bb0b3440fd2a10e0b201cefb587f4a.tar.gz
Merge
Docs/manual.texi: SCCS merged sql/field.h: SCCS merged sql/ha_innodb.cc: SCCS merged sql/handler.cc: SCCS merged sql/item_cmpfunc.cc: SCCS merged sql/mysqld.cc: SCCS merged
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi14
1 files changed, 9 insertions, 5 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index f3c790c8fb2..283ad00d80f 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -23510,17 +23510,21 @@ will be logged in the execution order.
Updates to non-transactional tables are stored in the binary log
immediately after execution. For transactional tables such as @code{BDB}
or @code{InnoDB} tables, all updates (@code{UPDATE}, @code{DELETE}
-or @code{INSERT}) that change tables are cached until a @code{COMMIT}.
+or @code{INSERT}) that change tables are cached until a @code{COMMIT} command
+is sent to the server. At this point mysqld writes the whole transaction to
+the binary log before the @code{COMMIT} is executed.
Every thread will, on start, allocate a buffer of @code{binlog_cache_size}
to buffer queries. If a query is bigger than this, the thread will open
-a temporary file to handle the bigger cache. The temporary file will
+a temporary file to store the transcation. The temporary file will
be deleted when the thread ends.
-The @code{max_binlog_cache_size} can be used to restrict the total size used
-to cache a multi-query transaction.
+The @code{max_binlog_cache_size} (default 4G) can be used to restrict
+the total size used to cache a multi-query transaction. If a transaction is
+bigger than this it will fail and roll back.
If you are using the update or binary log, concurrent inserts will
-not work together with @code{CREATE ... SELECT} and @code{INSERT ... SELECT}.
+be converted to normal inserts when using @code{CREATE ... SELECT} and
+@code{INSERT ... SELECT}.
This is to ensure that you can recreate an exact copy of your tables by
applying the log on a backup.