Author: paul
Date: 2006-01-23 22:26:53 +0100 (Mon, 23 Jan 2006)
New Revision: 1005
Log:
r2448@kite-hub: paul | 2006-01-23 14:32:58 -0600
Revise transaction_alloc_block_size/transaction_prealloc_size
descriptions.
Modified:
trunk/
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6574
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2447
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6574
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2448
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2006-01-23 21:26:35 UTC (rev 1004)
+++ trunk/refman-4.1/database-administration.xml 2006-01-23 21:26:53 UTC (rev 1005)
@@ -5271,9 +5271,9 @@
</para>
<para>
- The allocation size of memory blocks that are allocated
- for storing queries that are part of a transaction to be
- stored in the binary log when doing a commit. This
+ The amount in bytes by which to increase a per-transaction
+ memory pool which needs memory. See the description of
+ <literal>transaction_prealloc_size</literal>. This
variable was added in MySQL 4.0.16.
</para>
</listitem>
@@ -5284,13 +5284,25 @@
</para>
<para>
- The size of the persistent buffer for
- <literal>transaction_alloc_blocks</literal> that is not
- freed between queries. By making this big enough to fit
- all queries in a common transaction, you can avoid a lot
- of <literal>malloc()</literal> calls. This variable was
- added in MySQL 4.0.16.
+ There is a per-transaction memory pool from which various
+ transaction-related allocations take memory. The initial
+ size of the pool in bytes is
+ <literal>transaction_prealloc_size</literal>. For every
+ allocation that cannot be satisfied from the pool because
+ it has insufficient memory available, the pool is
+ increased by
+ <literal>transaction_alloc_block_size</literal> bytes.
+ When the transaction ends, the pool is truncated to
+ <literal>transaction_prealloc_size</literal> bytes.
</para>
+
+ <para>
+ By making <literal>transaction_prealloc_size</literal>
+ sufficiently large to contain all statements within a
+ single transaction, you can avoid many
+ <literal>malloc()</literal> calls. This variable was added
+ in MySQL 4.0.16.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-01-23 21:26:35 UTC (rev 1004)
+++ trunk/refman-5.0/database-administration.xml 2006-01-23 21:26:53 UTC (rev 1005)
@@ -5541,10 +5541,9 @@
</para>
<para>
- The allocation size (in bytes) of memory blocks that are
- allocated for storing queries that are part of a
- transaction to be stored in the binary log when doing a
- commit.
+ The amount in bytes by which to increase a per-transaction
+ memory pool which needs memory. See the description of
+ <literal>transaction_prealloc_size</literal>.
</para>
</listitem>
@@ -5554,12 +5553,24 @@
</para>
<para>
- The size in bytes of the persistent buffer for
- <literal>transaction_alloc_blocks</literal> that is not
- freed between queries. By making this sufficiently large
- to fit all queries into a single transaction, you can
- avoid many <literal>malloc()</literal> calls.
+ There is a per-transaction memory pool from which various
+ transaction-related allocations take memory. The initial
+ size of the pool in bytes is
+ <literal>transaction_prealloc_size</literal>. For every
+ allocation that cannot be satisfied from the pool because
+ it has insufficient memory available, the pool is
+ increased by
+ <literal>transaction_alloc_block_size</literal> bytes.
+ When the transaction ends, the pool is truncated to
+ <literal>transaction_prealloc_size</literal> bytes.
</para>
+
+ <para>
+ By making <literal>transaction_prealloc_size</literal>
+ sufficiently large to contain all statements within a
+ single transaction, you can avoid many
+ <literal>malloc()</literal> calls.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-01-23 21:26:35 UTC (rev 1004)
+++ trunk/refman-5.1/database-administration.xml 2006-01-23 21:26:53 UTC (rev 1005)
@@ -5604,10 +5604,9 @@
</para>
<para>
- The allocation size (in bytes) of memory blocks that are
- allocated for storing queries that are part of a
- transaction to be stored in the binary log when doing a
- commit.
+ The amount in bytes by which to increase a per-transaction
+ memory pool which needs memory. See the description of
+ <literal>transaction_prealloc_size</literal>.
</para>
</listitem>
@@ -5617,12 +5616,24 @@
</para>
<para>
- The size in bytes of the persistent buffer for
- <literal>transaction_alloc_blocks</literal> that is not
- freed between queries. By making this sufficiently large
- to fit all queries into a single transaction, you can
- avoid many <literal>malloc()</literal> calls.
+ There is a per-transaction memory pool from which various
+ transaction-related allocations take memory. The initial
+ size of the pool in bytes is
+ <literal>transaction_prealloc_size</literal>. For every
+ allocation that cannot be satisfied from the pool because
+ it has insufficient memory available, the pool is
+ increased by
+ <literal>transaction_alloc_block_size</literal> bytes.
+ When the transaction ends, the pool is truncated to
+ <literal>transaction_prealloc_size</literal> bytes.
</para>
+
+ <para>
+ By making <literal>transaction_prealloc_size</literal>
+ sufficiently large to contain all statements within a
+ single transaction, you can avoid many
+ <literal>malloc()</literal> calls.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1005 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 23 Jan |
