Author: mcbrown
Date: 2009-01-08 19:05:24 +0100 (Thu, 08 Jan 2009)
New Revision: 13042
Log:
Lots of Falcon fixes, including:
- Updated for the new optvars
- Updated and extended the optvar structure and information in the Falcon section
- Added per-optvar entries to the options
- Updated the var/command line details
- Updated the introduced/removed data for optvar entries
Closed and/or documented the following bugs:
Bug #36636
Bug #34890
Bug #36603
Bug #37587
Bug #36269
Bug #34632
Bug #36467
Bug #35692
Bug #35538
Bug #36330
Bug #36296
Bug #33213
Bug #36991
Bug #36990
Bug #36825
Bug #34602
Bug #36620
Bug #38556
Bug #37679
Bug #35939
Bug #38594
Bug #37080
Bug #37251
Bug #38377
Bug #39098
Bug #40308
Bug #40888
Bug #40890
Bug #40892
Bug #40391
Bug #40895
Bug #41023
Bug #41024
Bug #41399
Bug #40044
Bug #40043
Bug #41127
Bug #41102
Bug #41037
Bug #39796
Bug #39396
Bug #38135
Bug #39710
Bug #39665
Bug #39073
Bug #39707
Bug #39692
Bug #38566
Bug #39421
Bug #39181
Bug #39574
Bug #39912
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/dynamic-docs/metadata-titles.en.xml
trunk/refman-6.0/se-falcon-core.xml
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-08 17:37:53 UTC (rev 13041)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-08 18:05:24 UTC (rev 13042)
Changed blocks: 1, Lines Added: 615, Lines Deleted: 0; 13069 bytes
@@ -6,9 +6,624 @@
]>
<changelog>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="Tablespace"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33213"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When creating a new tablespace and specifying the name of an
+ existing tablespace file, an incorrect error message would be
+ reported specifying that the tablespace already existed. The
+ error message has been updated to reflect the actual error.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_max_transaction_backlog"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="36991"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <option>falcon_max_transaction_backlog</option> has been
+ removed. The option was originally introduced to ensure that the
+ backlog of transactions did not exceed a certain level with the
+ gopher thread. <literal>FALCON</literal> now uses multiple
+ gopher threads. The transaction backlog is handled internally by
+ <literal>FALCON</literal>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_initial_allocation"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="36990"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <option>falcon_initial_allocation</option> has been removed.
+ The option created new tablespace files with the specified size
+ to force allocation on disk of specified block of contiguous
+ space. The option had little effect on the performance of the
+ tablespace files, and has therefore been removed.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_index_chill_threshold"/>
+ <manual type="falcon_record_chill_threshold"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="36825"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <option>falcon_index_chill_threshold</option> and
+ <option>falcon_record_chill_threshold</option> options have been
+ modified so that the specification for the size can be specified
+ in bytes, and support the KB, MB, and GB modifiers.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="34602"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ An assertion could be raised when the dependencies on a
+ transaction could not be released after a specified time when
+ using <literal>FALCON</literal> tables.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="36620"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <literal>FALCON</literal> would try to open a number of files
+ during startup that are not required by the MySQL storage engine
+ implmentation. These operations have been removed.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="38556"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When building <literal>FALCON</literal> using the Sun Studio 12
+ compiler, a requirement for the GNU Standard C++
+ (<literal>libstdc++</literal>) library would be added to the
+ build requirements, causing the build to fail.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="37679"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When building <literal>FALCON</literal> using the Sun Studio 12
+ compiler on OpenSolaris the build would fail due to a missing
+ header file, <filename>Interlock.h</filename>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="trigger"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="35939"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When using both an <literal>INSERT BEFORE</literal> trigger to
+ create a row and <literal>AFTER INSERT</literal> trigger to
+ delete the same row on a <literal>FALCON</literal> table, the
+ record count as reported by <literal>SHOW TABLE STATUS</literal>
+ could get out of sync with the actual record contents. This was
+ caused by the changes now being correctly updated in the table
+ status information.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="mysql_install_db"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="38594"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When using <command>mysql_install_db</command> on MySQL built
+ with Sun Studio 12 with the <option>--with-debug</option> option
+ enabled, the server would crash.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="TRUNCATE"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="37080"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When performing operations on a table in one client while a
+ different client is performing a <literal>TRUNCATE</literal>
+ operation on the same <literal>FALCON</literal> table a deadlock
+ could be introduced.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="37251"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When running a concurrent scenario involving transactions, each
+ executing a small number of <literal>DELETE</literal> and
+ <literal>UPDATE</literal> operations on a small number of
+ records on <literal>FALCON</literal> tables, a deadlock could
+ occur.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="serial_log_directory"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39098"/>
+ <fixes bugid="38377"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.7"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When specifying an alternative log directory for
+ <literal>FALCON</literal> using
+ <option>serial_log_directory</option> the operation would fail
+ silently if the directory did not exist. MySQL will now fail to
+ start if the serial log in the specified directory cannot be
+ opened or created, or if the
+ <filename>falcon_master.fts</filename> cannot be opened or
+ created.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_page_size"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39707"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The minimum page size accepted by <literal>FALCON</literal> has
+ been increased from 1K to 2K.
+ </para>
+
+ </message>
+
+ </logentry>
+
<logentry entrytype="feature">
<tags>
+ <manual type="Falcon"/>
+ <manual type="index"/>
+ <manual type="falcon_use_supernodes"/>
+ </tags>
+
+ <versions>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Supernodes have been added to index pages. Supernodes are an
+ array of 16 vectors into each index page to keys that are fully
+ expand\ ed with noprefix compression. This allows the page to be
+ searched quicker using a binary search of supernode keys
+ followed by th\ e normal sequential search. Without enabling
+ supernodes, the whole page has to be searched sequentially.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_use_sectorcache"/>
+ </tags>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When reading from <literal>FALCON</literal> tables,
+ <literal>FALCON</literal> can take advantage of reading from the
+ disk in larger blocks. When enabled, disk reads are in blocks of
+ 64KB. When switched off, disk reads are based on the page size
+ as set by <option>falcon_page_size</option>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_use_sectorcache"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39692"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Memory would be allocated for the <literal>Falcon</literal>
+ sector cache even if the cache had been disabled
+ (<option>falcon_use_sectorcache</option>).
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="serial log"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39912"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When the <literal>Falcon</literal> serial log reaches a state
+ where the serial log can no longer be written to, for example
+ when the disk is full, or when permissions have been changed on
+ an open log, then MySQL could crash.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="recovery"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39574"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When recovering a crashed <literal>Falcon</literal> table when
+ the page size had been set to 32K, MySQL could crash with an
+ assertion.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="recovery"/>
+ <manual type="windows"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39421"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ When performing a recovery of a crashed
+ <literal>Falcon</literal> table on Windows, MySQL would report
+ an exception when then recovery process completed, even though
+ the recovery may have completed successfully.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="falcon_index_chill_threshold"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="38566"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Executing a light <literal>INSERT</literal> and
+ <literal>UPDATE</literal> workload with
+ <option>falcon_index_chill_threshold</option> set to 4K and
+ <option>falcon_record_chill_threshold</option> set to to 4K,
+ MySQL could crash.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="Falcon"/>
+ <manual type="build"/>
+ <manual type="Solaris 10"/>
+ <manual type="Sun Studio 10"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="39181"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Building MySQL with <literal>Falcon</literal> support using Sun
+ Studio 10 would fail due to GNU CC specific code within
+ <filename>MemoryManager.h</filename>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="feature">
+
+ <tags>
<highlight type="cluster"/>
<manual type="ndbd"/>
</tags>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2009-01-08 17:37:53 UTC (rev 13041)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2009-01-08 18:05:24 UTC (rev 13042)
Changed blocks: 36, Lines Added: 196, Lines Deleted: 68; 18387 bytes
@@ -22077,7 +22077,7 @@
<xrefto id="option_mysqld_falcon_checkpoint_schedule"/>
- <name>falcon_checkpoint_schedule</name>
+ <name>falcon-checkpoint-schedule</name>
<shortdescription lang="en">
Sets the frequency that in-memory structures are synchronized to
@@ -22085,8 +22085,8 @@
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-checkpoint-schedule"/>
- <optype class="mycnf" format="falcon-checkpoint-schedule"/>
+ <optype class="cmdline" setvar="falcon_checkpoint_schedule"/>/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22105,7 +22105,7 @@
<xrefto id="option_mysqld_falcon_debug_mask"/>
- <name>falcon_debug_mask</name>
+ <name>falcon-debug-mask</name>
<shortdescription lang="en">
Sets the log information written to the standard output by the
@@ -22113,8 +22113,8 @@
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-debug-mask"/>
- <optype class="cmdline" format="falcon-debug-mask"/>
+ <optype class="mycnf" setvar="falcon_debug_mask"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22129,7 +22129,7 @@
<choice value="64">LogPanic</choice>
<choice value="128">ogScrub</choice>
<choice value="256">ogException, logs exceptions and SQL errors</choice>
- <choice value="512">ogScavenge, reports record scavenger statistics</choice>
+ <choice value="512">ogScavenge, reports record scavenger statistics</choice>
</values>
<versions>
@@ -22143,15 +22143,15 @@
<xrefto id="option_mysqld_falcon_debug_server"/>
- <name>falcon_debug_server</name>
+ <name>falcon-debug-server</name>
<shortdescription lang="en">
Specifies whether the debug server should be enabled.
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-debug-server"/>
- <optype class="mycnf" format="falcon-debug-server"/>
+ <optype class="cmdline" setvar="falcon_debug_server"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22170,15 +22170,15 @@
<xrefto id="option_mysqld_falcon_disable_fsync"/>
- <name>falcon_disable_fsync</name>
+ <name>falcon-disable-fsync</name>
<shortdescription lang="en">
Disables the periodic fsync operation.
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-disable-fsync"/>
- <optype class="cmdline" format="falcon-disable-fsync"/>
+ <optype class="mycnf" setvar="falcon_disable_fsync"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22188,16 +22188,44 @@
<versions>
<introduced version="6.0.2"/>
+ <removed version="6.0.4"/>
<manual version="6.0"/>
</versions>
</mysqloption>
+ <mysqloption id="falcon_checksums" section="falcon">
+
+ <xrefto id="option_mysqld_falcon_checksums"/>
+
+ <name>falcon-checksums</name>
+
+ <shortdescription lang="en">
+ Enable Falcon checksum validation
+ </shortdescription>
+
+ <types>
+ <optype class="mycnf" setvar="falcon_checksums"/>
+ <optype class="cmdline"/>
+ <vartype class="system" scope="global" isdynamic="yes"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+ <value default="OFF"/>
+ </values>
+
+ <versions>
+ <introduced version="6.0.6"/>
+ <manual version="6.0"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption id="falcon_index_chill_threshold" section="falcon">
<xrefto id="option_mysqld_falcon_index_chill_threshold"/>
- <name>falcon_index_chill_threshold</name>
+ <name>falcon-index-chill-threshold</name>
<shortdescription lang="en">
Number of megabytes of pending index data that should be stored
@@ -22205,13 +22233,14 @@
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-index-chill-threshold"/>
- <optype class="cmdline" format="falcon-index-chill-threshold"/>
+ <optype class="mycnf" setvar="falcon_index_chill_threshold"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
<values vartype="numeric" platform="all">
- <value default="4" maximum="1024" minimum="1"/>
+ <value default="4" maximum="1024" minimum="1" outversion="6.0.6"/>
+ <value default="4194304" maximum="1073741824" minimum="1048576" inversion="6.0.7"/>
</values>
<versions>
@@ -22225,15 +22254,15 @@
<xrefto id="option_mysqld_falcon_initial_allocation"/>
- <name>falcon_initial_allocation</name>
+ <name>falcon-initial-allocation</name>
<shortdescription lang="en">
Initial size of a Falcon tablespace file when created
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-initial-allocation"/>
- <optype class="mycnf" format="falcon-initial-allocation"/>
+ <optype class="cmdline" setvar="falcon_initial_allocation"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22243,6 +22272,7 @@
<versions>
<introduced version="6.0.2"/>
+ <removed version="6.0.6"/>
<manual version="6.0"/>
</versions>
@@ -22252,15 +22282,15 @@
<xrefto id="option_mysqld_falcon_max_transaction_backlog"/>
- <name>falcon_max_transaction_backlog</name>
+ <name>falcon-max-transaction-backlog</name>
<shortdescription lang="en">
falcon_max_transaction_backlog
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-max-transaction-backlog"/>
- <optype class="cmdline" format="falcon-max-transaction-backlog"/>
+ <optype class="mycnf" setvar="falcon_max_transaction_backlog"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22270,6 +22300,7 @@
<versions>
<introduced version="6.0.2"/>
+ <removed version="6.0.6"/>
<manual version="6.0"/>
</versions>
@@ -22279,7 +22310,7 @@
<xrefto id="option_mysqld_falcon_page_cache_size"/>
- <name>falcon_page_cache_size</name>
+ <name>falcon-page-cache-size</name>
<shortdescription lang="en">
Size of the memory cache (in bytes) for pages from the tablespace
@@ -22287,8 +22318,8 @@
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-page-cache-size"/>
- <optype class="mycnf" format="falcon-page-cache-size"/>
+ <optype class="cmdline" setvar="falcon_page_cache_size"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22307,7 +22338,7 @@
<xrefto id="option_mysqld_falcon_page_size"/>
- <name>falcon_page_size</name>
+ <name>falcon-page-size</name>
<shortdescription lang="en">
Size of the pages (in bytes) used to store information within the
@@ -22315,12 +22346,12 @@
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-page-size"/>
- <optype class="cmdline" format="falcon-page-size"/>
+ <optype class="mycnf" setvar="falcon_page_size"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
- <values vartype="numeric" platform="all">
+ <values vartype="numeric" platform="all" outversion="6.0.5">
<value default="4096"/>
<choice value="1024"/>
<choice value="2048"/>
@@ -22330,6 +22361,15 @@
<choice value="32768"/>
</values>
+ <values vartype="numeric" platform="all" inversion="6.0.6">
+ <value default="4096"/>
+ <choice value="2048"/>
+ <choice value="4096"/>
+ <choice value="8192"/>
+ <choice value="16384"/>
+ <choice value="32768"/>
+ </values>
+
<versions>
<introduced version="6.0.2"/>
<manual version="6.0"/>
@@ -22341,7 +22381,7 @@
<xrefto id="option_mysqld_falcon_record_chill_threshold"/>
- <name>falcon_record_chill_threshold</name>
+ <name>falcon-record-chill-threshold</name>
<shortdescription lang="en">
Number of megabytes of pending record data stored before flushing
@@ -22349,13 +22389,14 @@
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-record-chill-threshold"/>
- <optype class="mycnf" format="falcon-record-chill-threshold"/>
+ <optype class="cmdline" setvar="falcon_record_chill_threshold"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
<values vartype="numeric" platform="all">
- <value default="5" minimum="1" maximum="1024"/>
+ <value default="5" maximum="1024" minimum="1" outversion="6.0.6"/>
+ <value default="5242880" maximum="1073741824" minimum="1048576" inversion="6.0.7"/>
</values>
<versions>
@@ -22369,7 +22410,7 @@
<xrefto id="option_mysqld_falcon_record_memory_max"/>
- <name>falcon_record_memory_max</name>
+ <name>falcon-record-memory-max</name>
<shortdescription lang="en">
Maximum amount of memory (in bytes) that will be allocated for
@@ -22377,8 +22418,8 @@
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-record-memory-max"/>
- <optype class="cmdline" format="falcon-record-memory-max"/>
+ <optype class="mycnf" setvar="falcon_record_memory_max"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22397,7 +22438,7 @@
<xrefto id="option_mysqld_falcon_record_scavenge_floor"/>
- <name>falcon_record_scavenge_floor</name>
+ <name>falcon-record-scavenge-floor</name>
<shortdescription lang="en">
Percentage of falcon_record_scavenge_threshold that will be
@@ -22405,8 +22446,8 @@
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-record-scavenge-floor"/>
- <optype class="mycnf" format="falcon-record-scavenge-floor"/>
+ <optype class="cmdline" setvar="falcon_record_scavenge_floor"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22425,7 +22466,7 @@
<xrefto id="option_mysqld_falcon_record_scavenge_threshold"/>
- <name>falcon_record_scavenge_threshold</name>
+ <name>falcon-record-scavenge-threshold</name>
<shortdescription lang="en">
Percentage of falcon_record_memory_max that will cause the
@@ -22434,8 +22475,8 @@
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-record-scavenge-threshold"/>
- <optype class="cmdline" format="falcon-record-scavenge-threshold"/>
+ <optype class="mycnf" setvar="falcon_record_scavenge_threshold"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22454,15 +22495,15 @@
<xrefto id="option_mysqld_falcon_scavenge_schedule"/>
- <name>falcon_scavenge_schedule</name>
+ <name>falcon-scavenge-schedule</name>
<shortdescription lang="en">
Record scavenging threshold
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-scavenge-schedule"/>
- <optype class="mycnf" format="falcon-scavenge-schedule"/>
+ <optype class="cmdline" setvar="falcon_scavenge_schedule"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22481,15 +22522,15 @@
<xrefto id="option_mysqld_falcon_serial_log_buffers"/>
- <name>falcon_serial_log_buffers</name>
+ <name>falcon-serial-log-buffers</name>
<shortdescription lang="en">
Memory windows (1MB each) allocated for the Falcon serial log
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-serial-log-buffers"/>
- <optype class="cmdline" format="falcon-serial-log-buffers"/>
+ <optype class="mycnf" setvar="falcon_serial_log_buffers"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22508,15 +22549,15 @@
<xrefto id="option_mysqld_falcon_serial_log_dir"/>
- <name>falcon_serial_log_dir</name>
+ <name>falcon-serial-log-dir</name>
<shortdescription lang="en">
Location for the Falcon serial log files
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-serial-log-dir"/>
- <optype class="mycnf" format="falcon-serial-log-dir"/>
+ <optype class="cmdline" setvar="falcon_serial_log_dir"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22529,19 +22570,100 @@
</mysqloption>
+ <mysqloption id="falcon_use_sectorcache" section="falcon">
+
+ <xrefto id="option_mysqld_falcon_use_sectorcache"/>
+
+ <name>falcon-use-sectorcache</name>
+
+ <shortdescription lang="en">
+ Use the sector cache for reading blocks from disk
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" setvar="falcon_use_sectorcache"/>
+ <optype class="mycnf"/>
+ <vartype class="system" scope="global" isdynamic="no"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+ <value default="off"/>
+ </values>
+
+ <versions>
+ <introduced version="6.0.6"/>
+ <manual version="6.0"/>
+ </versions>
+
+ </mysqloption>
+
+ <mysqloption id="falcon_use_supernodes" section="falcon">
+
+ <xrefto id="option_mysqld_falcon_use_supernodes"/>
+
+ <name>falcon-use-supernodes</name>
+
+ <shortdescription lang="en">
+ Use index supernodes
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" setvar="falcon_use_supernodes"/>
+ <optype class="mycnf"/>
+ <vartype class="system" scope="global" isdynamic="no"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+ <value default="on"/>
+ </values>
+
+ <versions>
+ <introduced version="6.0.5"/>
+ <manual version="6.0"/>
+ </versions>
+
+ </mysqloption>
+
+ <mysqloption id="falcon_use_deferred_index_hash" section="falcon">
+
+ <xrefto id="option_mysqld_falcon_use_deferred_index_hash"/>
+
+ <name>falcon-use-deferred-index-hash</name>
+
+ <shortdescription lang="en">
+ Use a deferred index hash lookup
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" setvar="falcon_use_deferred_index_hash"/>
+ <optype class="mycnf"/>
+ <vartype class="system" scope="global" isdynamic="no"/>
+ </types>
+
+ <values vartype="boolean" platform="all">
+ <value default="OFF"/>
+ </values>
+
+ <versions>
+ <introduced version="6.0.4"/>
+ <manual version="6.0"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption id="falcon_consistent_read" section="falcon">
<xrefto id="option_mysqld_falcon_consistent_read"/>
- <name>falcon_consistent_read</name>
+ <name>falcon-consistent-read</name>
<shortdescription lang="en">
Sets the repeatable read isolation mode
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-consistent-read"/>
- <optype class="cmdline" format="falcon-consistent-read"/>
+ <optype class="mycnf" setvar="falcon_consistent_read"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="both" isdynamic="yes"/>
</types>
@@ -22560,15 +22682,15 @@
<xrefto id="option_mysqld_falcon_gopher_threads"/>
- <name>falcon_gopher_threads</name>
+ <name>falcon-gopher-threads</name>
<shortdescription lang="en">
Sets the number of gopher threads
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-gopher-threads"/>
- <optype class="mycnf" format="falcon-gopher-threads"/>
+ <optype class="cmdline" setvar="falcon_gopher_threads"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22587,15 +22709,15 @@
<xrefto id="option_mysqld_falcon_io_threads"/>
- <name>falcon_io_threads</name>
+ <name>falcon-io-threads</name>
<shortdescription lang="en">
Number of asynchronous I/O threads
</shortdescription>
<types>
- <optype class="mycnf" format="falcon-io-threads"/>
- <optype class="cmdline" format="falcon-io-threads"/>
+ <optype class="mycnf" setvar="falcon_io_threads"/>
+ <optype class="cmdline"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
@@ -22614,7 +22736,7 @@
<xrefto id="option_mysqld_falcon_large_blob_threshold"/>
- <name>falcon_large_blob_threshold</name>
+ <name>falcon-large-blob-threshold</name>
<shortdescription lang="en">
Blobs smaller than this value are stored in data pages not blob
@@ -22622,8 +22744,8 @@
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-large-blob-threshold"/>
- <optype class="mycnf" format="falcon-large-blob-threshold"/>
+ <optype class="cmdline" setvar="falcon_large_blob_threshold"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="no"/>
</types>
@@ -22648,7 +22770,7 @@
<xrefto id="option_mysqld_falcon_lock_wait_timeout"/>
- <name>falcon_lock_wait_timeout</name>
+ <name>falcon-lock-wait-timeout</name>
<shortdescription lang="en">
Number of seconds Falcon will force one transaction to wait on
@@ -22675,18 +22797,24 @@
<mysqloption id="falcon_serial_log_priority" section="falcon">
- <name>falcon_serial_log_priority</name>
+ <xrefto id="option_mysqld_falcon_serial_log_priority"/>
+ <name>falcon-serial-log-priority</name>
+
<shortdescription lang="en">
Set the priority for writing the Falcon serial log
</shortdescription>
<types>
- <optype class="cmdline" format="falcon-serial-log-priority"/>
- <optype class="mycnf" format="falcon-serial-log-priority"/>
+ <optype class="cmdline" setvar="falcon_serial_log_priority"/>
+ <optype class="mycnf"/>
<vartype class="system" scope="global" isdynamic="yes"/>
</types>
+ <values vartype="boolean" platform="all">
+ <value default="1"/>
+ </values>
+
<versions>
<manual version="6.0"/>
<introduced version="6.0.4"/>
Modified: trunk/dynamic-docs/metadata-titles.en.xml
===================================================================
--- trunk/dynamic-docs/metadata-titles.en.xml 2009-01-08 17:37:53 UTC (rev 13041)
+++ trunk/dynamic-docs/metadata-titles.en.xml 2009-01-08 18:05:24 UTC (rev 13042)
Changed blocks: 2, Lines Added: 3, Lines Deleted: 0; 837 bytes
@@ -4,6 +4,7 @@
<titles>
<title id="all">All</title>
<title id="boolean">boolean</title>
+<title id="bitmap">Bitmap</title>
<title id="both">Both</title>
<title id="cmd-line">Cmd-Line</title>
<title id="command_line">Command-line</title>
@@ -45,5 +46,7 @@
<title id="variable_scope">Variable Scope</title>
<title id="variable_type">Variable Type</title>
<title id="version_introduced">Version Introduced</title>
+<title id="version_removed">Version Removed</title>
+<title id="version_deprecated">Version Deprecated</title>
<title id="yes">Yes</title>
</titles>
Modified: trunk/refman-6.0/se-falcon-core.xml
===================================================================
--- trunk/refman-6.0/se-falcon-core.xml 2009-01-08 17:37:53 UTC (rev 13041)
+++ trunk/refman-6.0/se-falcon-core.xml 2009-01-08 18:05:24 UTC (rev 13042)
Changed blocks: 14, Lines Added: 278, Lines Deleted: 137; 25649 bytes
@@ -205,8 +205,13 @@
<listitem>
<para id="option_mysqld_falcon_checkpoint_schedule">
- <literal>falcon_checkpoint_schedule</literal> — the
- checkpoint schedule (the frequency with which
+ <option>falcon_checkpoint_schedule</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_checkpoint_schedule"/>
+
+ <para>
+ The checkpoint schedule (the frequency with which
<literal>fsync()</literal> is called to synchronize the
in-memory and disk data). Specification is in the form of a
<literal>crontab</literal>-style series of values, separated
@@ -279,16 +284,30 @@
<programlisting>7 * * * * *</programlisting>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_falcon_checksums">
+ <option>falcon_consistent_read</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_checksums"/>
+
<para>
- This option was added in MySQL 6.0.3.
+ Enable Falcon checksum validation
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_consistent_read">
- <literal>falcon_consistent_read</literal> — sets the
- repeatable read transaction isolation level. Set to On,
- repeatable read transactions are truly consistent-read.
+ <option>falcon_consistent_read</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_consistent_read"/>
+
+ <para>
+ Sets the repeatable read transaction isolation level. Set to
+ On, repeatable read transactions are truly consistent-read.
Changes made by younger transactions will not be exposed and
newer records cannot be read or written within a repeatable
read transaction. Set to Off, <literal>Falcon</literal> works
@@ -308,33 +327,31 @@
</note>
<para>
- The <literal>falcon_consistent_read</literal> variable has
- only local scope. You can set the global value, using
+ The <option>falcon_consistent_read</option> variable has only
+ local scope. You can set the global value, using
<literal role="stmt" condition="set-option">SET
GLOBAL</literal>, but this affects only the current local
scope and all new connections made after the global variable
was set.
</para>
- <para>
- Default is On.
- </para>
-
- <para>
- This option was added in MySQL 6.0.4.
- </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_debug_mask">
- <literal>falcon_debug_mask</literal> — (formerly
- <literal>falcon_log_mask</literal>) sets the log information
- that is output to the standard output of
- <command>mysqld</command> in the event of an error. The value
- is a bit mask; you must combine values to enables different
- combinations of error message types. The supported values are:
+ <option>falcon_debug_mask</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_debug_mask"/>
+
+ <para>
+ Sets the log information that is output to the standard output
+ of <command>mysqld</command> in the event of an error. The
+ value is a bit mask; you must combine values to enables
+ different combinations of error message types. Formerly known
+ as <option>falcon_log_mask</option>. The supported values are:
+ </para>
+
<informaltable>
<tgroup cols="3">
<colspec colwidth="10*"/>
@@ -406,49 +423,59 @@
<listitem>
<para id="option_mysqld_falcon_debug_server">
- <literal>falcon_debug_server</literal> — specifies
- whether the debug server should be enabled.
+ <option>falcon_debug_server</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_debug_server"/>
+
<para>
- The default value is OFF.
+ Specifies whether the debug server should be enabled.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_disable_fsync">
- <literal>falcon_disable_fsync</literal> — if true, the
- periodic <literal>fsync</literal> operation to synchronize
- data on disk is disabled. Setting this value to true may lead
- to data loss, but may increase performance.
+ <option>falcon_disable_fsync</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_disable_fsync"/>
+
<para>
+ If true, the periodic <literal>fsync</literal> operation to
+ synchronize data on disk is disabled. Setting this value to
+ true may lead to data loss, but may increase performance.
+ </para>
+
+ <para>
Default value is false (<literal>fsync</literal> is enabled).
</para>
+
</listitem>
<listitem>
<para id="option_mysqld_falcon_gopher_threads">
- <literal>falcon_gopher_threads</literal> — number of
- threads that process committed changes in the serial log to
- the database.
+ <option>falcon_gopher_threads</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_gopher_threads"/>
+
<para>
- The default value is 5 gopher threads.
+ Number of threads that process committed changes in the serial
+ log to the database.
</para>
- <para>
- This option was added in MySQL 6.0.4.
- </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_index_chill_threshold">
- <literal>falcon_index_chill_threshold</literal> — the
- number of megabytes of pending index data that should be
- stored during a large transaction before the index changes are
+ <option>falcon_index_chill_threshold</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_index_chill_threshold"/>
+
+ <para>
+ The size of the pending index data that should be stored
+ during a large transaction before the index changes are
flushed to the serial log. If the index is unique, or the
transaction regularly re-reads the index data, then the index
data is stored in memory (for faster access). The flushing of
@@ -458,11 +485,18 @@
</para>
<para>
- The minimum accepted value is 1, the maximum is 1024 and the
- default value is 4.
+ For versions up to MySQL 6.0.6, the value is specified in
+ megabytes, with the minimum accepted value is 1, the maximum
+ is 1024 and the default value is 4.
</para>
<para>
+ For versions of MySQL 6.0.7 and later, the value is specified
+ in bytes, with the minimum accepted value is 1048576, the
+ maximum is 1073741824 and the default value is 4194304.
+ </para>
+
+ <para>
This configuration option is available within
<command>mysqld</command> as a server variable.
</para>
@@ -470,100 +504,119 @@
<listitem>
<para id="option_mysqld_falcon_initial_allocation">
- <literal>falcon_initial_allocation</literal> — the
- amount of space, in MB, that should be preallocated on disk
- when a new <literal>Falcon</literal> tablespace file is
+ <option>falcon_initial_allocation</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_initial_allocation"/>
+
+ <para>
+ The amount of space, in MB, that should be preallocated on
+ disk when a new <literal>Falcon</literal> tablespace file is
created.
</para>
<para>
- The default value is 0 (no preallocation). The minimum value
- is 10.
+ This configuration option was removed in MySQL 6.0.6.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_io_threads">
- <literal>falcon_io_threads</literal> — the number of
- asynchronous threads to be used when performing writes to
- disk.
+ <option>falcon_io_threads</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_io_threads"/>
+
<para>
- The default value is 2 threads.
+ The number of asynchronous threads to be used when performing
+ writes to disk.
</para>
- <para>
- This option was added in MySQL 6.0.4.
- </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_max_transaction_backlog">
- <literal>falcon_max_transaction_backlog</literal> — the
- maximum number of pending transactions that will be active
+ <option>falcon_max_transaction_backlog</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_max_transaction_backlog"/>
+
+ <para>
+ The maximum number of pending transactions that will be active
before the update process is blocked until the number of
pending transactions reduces.
</para>
<para>
- The default value is 150.
+ This configuration option was removed in MySQL 6.0.6.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_large_blob_threshold">
- <literal>falcon_large_blob_threshold</literal> — BLOB
- data below this threshold is stored in data pages, instead of
- BLOB pages. This can improve performance for smaller blobs
- because only the serial log needs to be flushed at the end of
- a transaction, and not the serial log and the blob pages.
+ <option>falcon_large_blob_threshold</option>
</para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_large_blob_threshold"/>
+
+ <para>
+ <literal>BLOB</literal> data below this threshold is stored in
+ data pages, instead of <literal>BLOB</literal> pages. This can
+ improve performance for smaller blobs because only the serial
+ log needs to be flushed at the end of a transaction, and not
+ the serial log and the blob pages.
+ </para>
</listitem>
<listitem>
<para id ="option_mysqld_falcon_lock_wait_timeout">
- <literal>falcon_lock_wait_timeout</literal> — the period
- (in seconds) that a <literal>Falcon</literal> transaction will
- wait for another transaction to complete when both
- transactions need access to a locked table. A value 0
- indicates that <literal>Falcon</literal> will wait
- indefinitely for another transaction to complete.
+ <option>falcon_lock_wait_timeout</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_lock_wait_timeout"/>
+
<para>
- The default value is 50.
+ The period (in seconds) that a <literal>Falcon</literal>
+ transaction will wait for another transaction to complete when
+ both transactions need access to a locked table. A value 0
+ indicates that <literal>Falcon</literal> will wait
+ indefinitely for another transaction to complete.
</para>
<para>
This variable was added in MySQL 6.0.4. (Previously, in 6.0.3,
there was a variable named
- <literal>falcon_lock_timeout</literal> which was measured in
+ <option>falcon_lock_timeout</option> which was measured in
milliseconds and had a default of 0.)
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_page_cache_size">
- <literal>falcon_page_cache_size</literal> — (Page Cache
- Size) sets the amount of memory that will be allocated for
- caching pages from the tablespace file.
+ <option>falcon_page_cache_size</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_page_cache_size"/>
+
<para>
- The default value is 4MB.
+ Sets the amount of memory that will be allocated for caching
+ pages from the tablespace file.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_page_size">
- <literal>falcon_page_size</literal> — (Page Size)
- controls the size of the pages used to store information
- within the tablespace. Valid sizes are 1, 2, 4, 8, 16 and 32
- KB.
+ <option>falcon_page_size</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_page_size"/>
+
<para>
+ Controls the size of the pages used to store information
+ within the tablespace. Valid sizes are 2, 4, 8, 16 and 32 KB.
+ </para>
+
+ <para>
The specified page size also affects the maximum index key
lengths supported. The table below shows the relationship
between the page size and the maximum index key length.
@@ -581,10 +634,6 @@
</thead>
<tbody>
<row>
- <entry>1K</entry>
- <entry>255</entry>
- </row>
- <row>
<entry>2K</entry>
<entry>540</entry>
</row>
@@ -607,16 +656,17 @@
</tbody>
</tgroup>
</informaltable>
-
- <para>
- The default is 4KB.
- </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_record_chill_threshold">
- <literal>falcon_record_chill_threshold</literal> — the
- number of Mbytes of pending record data that
+ <option>falcon_record_chill_threshold</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_record_chill_threshold"/>
+
+ <para>
+ The number of Mbytes of pending record data that
<literal>Falcon</literal> will keep in memory during a large
transaction before flushing these records to the serial log.
This flushing is called chilling since it makes the data not
@@ -628,29 +678,42 @@
</para>
<para>
- The minimum accepted value is 1, the maximum is 1024 and the
- default value is 5.
+ For versions up to MySQL 6.0.6, the value is specified in
+ megabytes, with the minimum accepted value is 1, the maximum
+ is 1024 and the default value is 5.
</para>
+
+ <para>
+ For versions of MySQL 6.0.7 and later, the value is specified
+ in bytes, with the minimum accepted value is 1048576, the
+ maximum is 1073741824 and the default value is 5242880.
+ </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_record_memory_max">
- <literal>falcon_record_memory_max</literal> — sets the
- maximum amount of memory that will be allocated for caching
- record data.
+ <option>falcon_record_memory_max</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_record_memory_max"/>
+
<para>
- The default is 20MB.
+ Sets the maximum amount of memory that will be allocated for
+ caching record data.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_record_scavenge_floor">
- <literal>falcon_record_scavenge_floor</literal> — the
- percentage of
- <literal>falcon_record_scavenge_threshold</literal> that will
- be retained in the record cache after the scavenger thread has
+ <option>falcon_record_scavenge_floor</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_record_scavenge_floor"/>
+
+ <para>
+ The percentage of
+ <option>falcon_record_scavenge_threshold</option> that will be
+ retained in the record cache after the scavenger thread has
completed execution.
</para>
@@ -664,17 +727,17 @@
* (falcon_record_scavenge_threshold/100)
* (falcon_record_scavenge_floor/100))
</programlisting>
-
- <para>
- The default value is 50. The minimum accepted value is 10, and
- the maximum is 90.
- </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_record_scavenge_threshold">
- <literal>falcon_record_scavenge_threshold</literal> —
- the percentage of <literal>falcon_record_memory_max</literal>
+ <option>falcon_record_scavenge_threshold</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_record_scavenge_threshold"/>
+
+ <para>
+ The percentage of <option>falcon_record_memory_max</option>
that will cause the scavenger thread to start removing old
generations of records from the record cache.
</para>
@@ -687,53 +750,131 @@
<listitem>
<para id="option_mysqld_falcon_scavenge_schedule">
- <literal>falcon_scavenge_schedule</literal> — the record
- scavenging schedule, specified as a <literal>crontab</literal>
- style schedule. See
- <link linkend="option_mysqld_falcon_checkpoint_schedule"><literal>falcon_checkpoint_schedule</literal></link>.
+ <option>falcon_scavenge_schedule</option>
</para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_scavenge_schedule"/>
+
+ <para>
+ The record scavenging schedule, specified as a
+ <literal>crontab</literal> style schedule. See
+ <link linkend="option_mysqld_falcon_checkpoint_schedule"><option>falcon_checkpoint_schedule</option></link>.
+ </para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_serial_log_buffers">
- <literal>falcon_serial_log_buffers</literal> — the
- number of memory windows allocated for the
- <literal>Falcon</literal> serial log. Each window is 1 MByte
- in size. Formerly <literal>falcon_log_windows</literal>.
+ <option>falcon_serial_log_buffers</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_serial_log_buffers"/>
+
<para>
- The minimum accepted value is 10, the maximum is 32768 and the
- default value is 10.
+ The number of memory windows allocated for the
+ <literal>Falcon</literal> serial log. Each window is 1 MByte
+ in size. Formerly <option>falcon_log_windows</option>.
</para>
</listitem>
<listitem>
<para id="option_mysqld_falcon_serial_log_dir">
- <literal>falcon_serial_log_dir</literal> — (Log file
- location) sets the directory for storing the serial log. The
- filenames used by the serial log (two files are create for
- storing serial data) are allocated according to the name of
- the tablespace. The default location is in the same directory
- as the tablespace file. Formerly
- <literal>falcon_log_dir</literal>.
+ <option>falcon_serial_log_dir</option>
</para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_serial_log_dir"/>
+
+ <para>
+ Sets the directory for storing the serial log. The filenames
+ used by the serial log (two files are create for storing
+ serial data) are allocated according to the name of the
+ tablespace.
+ </para>
</listitem>
<listitem>
+ <para id="option_mysqld_falcon_serial_log_priority">
+ <option>falcon_serial_log_priority</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_serial_log_priority"/>
+
+ <para>
+ Sets whether the serial log has priority other writes.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="option_mysqld_falcon-support-xa">
- <literal>falcon_support_xa</literal> — specifies whether
- <literal>Falcon</literal> should support two-phase commit.
- When set to 0 (default), commits are single phase. When set to
- 1, <literal>Falcon</literal> reports itself as a two-phase
- commit supporting engine and supports two-phase commits.
+ <option>falcon_support_xa</option>
</para>
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_support_xa"/>
+
<para>
- This option was added in MySQL 6.0.4.
+ Specifies whether <literal>Falcon</literal> should support
+ two-phase commit. When set to 0 (default), commits are single
+ phase. When set to 1, <literal>Falcon</literal> reports itself
+ as a two-phase commit supporting engine and supports two-phase
+ commits.
</para>
+
</listitem>
+ <listitem>
+ <para id="option_mysqld_falcon_use_deferred_index_hash">
+ <option>falcon_use_deferred_index_hash</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_use_deferred_index_hash"/>
+
+ <para>
+ Enable the deferred index hash.
+ </para>
+
+ <para>
+ Default is off
+ </para>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_falcon_use_sectorcache">
+ <option>falcon_use_sectorcache</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_use_sectorcache"/>
+
+ <para>
+ Use the sector cache. When enabled, disk reads are in blocks
+ of 64KB. When switched off, disk reads are based on the page
+ size (as set by <option>falcon_page_size</option>.
+ </para>
+
+ <para>
+ Default is off
+ </para>
+ </listitem>
+
+ <listitem>
+ <para id="option_mysqld_falcon_use_supernodes">
+ <option>falcon_use_supernodes</option>
+ </para>
+
+ <para condition="dynamic:optvar:item" role="6.0:mysqld:falcon_use_supernodes"/>
+
+ <para>
+ Use supernodes within the Falcon index. Supernodes are an
+ array of 16 vectors into each index page to keys that are
+ fully expanded with noprefix compression. This allows the page
+ to be searched quicker using a binary search of supernode keys
+ followed by the normal sequential search. Without enabling
+ supernodes, the whole page has to be searched sequentially.
+ </para>
+
+ <para>
+ Default is on
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1582,7 +1723,7 @@
<emphasis role="bold">Page Cache</emphasis> — database
pages read from disk for a particular database. The page
cache size is controlled by the
- <literal>falcon_page_cache_size</literal> parameter, which
+ <option>falcon_page_cache_size</option> parameter, which
defaults to 4MB, and is set in the my.cnf file. Although
record and index changes go to the serial log before being
written to database pages, blob data is written directly
@@ -1610,10 +1751,10 @@
concurrency control (MVCC) mechanisms of the
<literal>Falcon</literal> engine. The record cache is
controlled by two parameters. The
- <literal>falcon_min_record_memory</literal> parameter
- (default 10MB) determines the minimum amount of RAM supplied
- to the record cache and the
- <literal>falcon_max_record_memory</literal> (default 20MB)
+ <option>falcon_min_record_memory</option> parameter (default
+ 10MB) determines the minimum amount of RAM supplied to the
+ record cache and the
+ <option>falcon_max_record_memory</option> (default 20MB)
limits the total amount of memory available to the cache.
</para>
</listitem>
@@ -1623,12 +1764,12 @@
Because of the support the record cache supplies to
transactions, a scavenge thread is used to ensure only "hot"
data resides in the cache. When the
- <literal>falcon_max_record_memory</literal> limit is
- reached, <literal>Falcon</literal> surveys the demographics
- of the generational data in the cache, and removes the
- oldest generations. This process is more complicated than
- the standard LRU algorithm used by many database systems,
- but it is more efficient and faster.
+ <option>falcon_max_record_memory</option> limit is reached,
+ <literal>Falcon</literal> surveys the demographics of the
+ generational data in the cache, and removes the oldest
+ generations. This process is more complicated than the
+ standard LRU algorithm used by many database systems, but it
+ is more efficient and faster.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r13042 - in trunk: dynamic-docs dynamic-docs/changelog dynamic-docs/command-optvars refman-6.0 | martin.brown | 8 Jan |
