svn commit - mysqldoc@docsrva: r11445 - trunk/refman-6.0

[mcbrown]

Author: mcbrown
Date: 2008-07-30 17:58:23 +0200 (Wed, 30 Jul 2008)
New Revision: 11445

Log:
Adding an FAQ section, and adding detail on DELAY_KEY_WRITE support



Modified:
   trunk/refman-6.0/se-maria-core.xml


Modified: trunk/refman-6.0/se-maria-core.xml
===================================================================
--- trunk/refman-6.0/se-maria-core.xml	2008-07-30 15:07:44 UTC (rev 11444)
+++ trunk/refman-6.0/se-maria-core.xml	2008-07-30 15:58:23 UTC (rev 11445)
Changed blocks: 2, Lines Added: 48, Lines Deleted: 6; 2322 bytes

@@ -179,7 +179,6 @@
         TABLES</literal> and <literal>UNLOCK TABLES</literal>
         statements.
       </para>
-
     </listitem>
 
   </itemizedlist>

@@ -1570,15 +1569,58 @@
 
   </section>
 
-<!--
+  <section id="se-maria-faq">
 
+    <title><literal>Maria</literal> Frequently Asked Questions (FAQ)</title>
 
-<section id="se-maria-faq">
-  <title><literal>Maria</literal> Frequently Asked Questions (FAQ)</title>
+    <para>
+      The following entries cover some of the frequently asked questions
+      about <literal>Maria</literal>/
+    </para>
 
-</section>
-   -->
+    <qandaset>
 
+      <qandaentry>
+
+        <question>
+
+          <para>
+            Is <literal>DELAY_KEY_WRITE</literal> honoured on Maria
+            tables?
+          </para>
+
+        </question>
+
+        <answer>
+
+          <para>
+            If you are using non-transactional <literal>Maria</literal>
+            tables (<literal>CREATE TABLE... ENGINE=MARIA
+            TRANSACTIONAL=0</literal>), which are similar to
+            <literal>MyISAM</literal>, then
+            <literal>DELAY_KEY_WRITE</literal> works as you expect. If
+            you are using transactional <literal>Maria</literal> tables
+            (the default), then <literal>DELAY_KEY_WRITE</literal> is
+            always enabled. In <literal>MyISAM</literal> and
+            non-transactional <literal>Maria</literal> tables (which
+            have no logging), by default all the table's key pages are
+            flushed to the OS at the end of each statement, to guarantee
+            some durability. <literal>DELAY_KEY_WRITE</literal> removes
+            this flush, giving less durability. In transactional
+            <literal>Maria</literal> tables, key pages are flushed by a
+            background job, regularly, not necessarily at the end of
+            each statement, and durability is guaranteed thanks to
+            logging.
+          </para>
+
+        </answer>
+
+      </qandaentry>
+
+    </qandaset>
+
+  </section>
+
   <section id="se-maria-openbugs">
 
     <title><literal>Maria</literal> Open Bugs</title>