diff options
author | unknown <serg@sergbook.mysql.com> | 2002-11-06 09:52:13 +0100 |
---|---|---|
committer | unknown <serg@sergbook.mysql.com> | 2002-11-06 09:52:13 +0100 |
commit | f9b7e3abc8bb0b3440fd2a10e0b201cefb587f4a (patch) | |
tree | 80b3f1d019ca187e40e729161a67c9b7941a047c /Docs | |
parent | 781c7901cbe120bec3776fcec23fe6fc13ca1e64 (diff) | |
parent | 0e56af0744cb2d66cc44ee9685f6e94bf6e6a946 (diff) | |
download | mariadb-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.texi | 14 |
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. |