svn commit - mysqldoc@docsrva: r1813 - in trunk: refman-4.1 refman-5.0 refman-5.1

[mcbrown]

Author: mcbrown
Date: 2006-04-13 15:12:06 +0200 (Thu, 13 Apr 2006)
New Revision: 1813

Log:
Updating storage engine docs with default_storage_engine/table_type in my.cnf and within a
session (Bug #19061).



Modified:
   trunk/refman-4.1/storage-engines.xml
   trunk/refman-5.0/storage-engines.xml
   trunk/refman-5.1/storage-engines.xml

Modified: trunk/refman-4.1/storage-engines.xml
===================================================================
--- trunk/refman-4.1/storage-engines.xml	2006-04-13 13:07:53 UTC (rev 1812)
+++ trunk/refman-4.1/storage-engines.xml	2006-04-13 13:12:06 UTC (rev 1813)
@@ -220,11 +220,23 @@
     <literal>MyISAM</literal>, but you can change it by using the
     <option>--default-storage-engine</option> or
     <option>--default-table-type</option> server startup option, or by
-    setting the <literal>storage_engine</literal> or
-    <literal>table_type</literal> system variable.
+    setting the <literal>default_storage_engine</literal> or
+    <literal>default_table_type</literal> system variable in the
+    <filename>my.cnf</filename> configuration file.
   </para>
 
   <para>
+    You can set the default storage engine to be used during the current
+    session by setting the <literal>storage_engine</literal> or
+    <literal>table_type</literal> variable:
+  </para>
+
+<programlisting>
+SET storage_engine=MYISAM;
+SET table_type=BDB;
+</programlisting>
+
+  <para>
     When MySQL is installed on Windows using the MySQL Configuration
     Wizard, the <literal>InnoDB</literal> storage engine can be selected
     as the default instead of <literal>MyISAM</literal>. See

Modified: trunk/refman-5.0/storage-engines.xml
===================================================================
--- trunk/refman-5.0/storage-engines.xml	2006-04-13 13:07:53 UTC (rev 1812)
+++ trunk/refman-5.0/storage-engines.xml	2006-04-13 13:12:06 UTC (rev 1813)
@@ -230,11 +230,23 @@
     <literal>MyISAM</literal>, but you can change it by using the
     <option>--default-storage-engine</option> or
     <option>--default-table-type</option> server startup option, or by
-    setting the <literal>storage_engine</literal> or
-    <literal>table_type</literal> system variable.
+    setting the <literal>default_storage_engine</literal> or
+    <literal>default_table_type</literal> system variable in the
+    <filename>my.cnf</filename> configuration file.
   </para>
 
   <para>
+    You can set the default storage engine to be used during the current
+    session by setting the <literal>storage_engine</literal> or
+    <literal>table_type</literal> variable:
+  </para>
+
+<programlisting>
+SET storage_engine=MYISAM;
+SET table_type=BDB;
+</programlisting>
+
+  <para>
     When MySQL is installed on Windows using the MySQL Configuration
     Wizard, the <literal>InnoDB</literal> storage engine can be selected
     as the default instead of <literal>MyISAM</literal>. See

Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml	2006-04-13 13:07:53 UTC (rev 1812)
+++ trunk/refman-5.1/storage-engines.xml	2006-04-13 13:12:06 UTC (rev 1813)
@@ -212,16 +212,28 @@
 </programlisting>
 
   <para>
-    If you omit the <literal>ENGINE</literal> option, the default
-    storage engine is used. Normally, this is <literal>MyISAM</literal>,
-    but you can change it by using the
+    If you omit the <literal>ENGINE</literal> or
<literal>TYPE</literal>
+    option, the default storage engine is used. Normally, this is
+    <literal>MyISAM</literal>, but you can change it by using the
     <option>--default-storage-engine</option> or
     <option>--default-table-type</option> server startup option, or by
-    setting the <literal>storage_engine</literal> or
-    <literal>table_type</literal> system variable.
+    setting the <literal>default_storage_engine</literal> or
+    <literal>default_table_type</literal> system variable in the
+    <filename>my.cnf</filename> configuration file.
   </para>
 
   <para>
+    You can set the default storage engine to be used during the current
+    session by setting the <literal>storage_engine</literal> or
+    <literal>table_type</literal> variable:
+  </para>
+
+<programlisting>
+SET storage_engine=MYISAM;
+SET table_type=BDB;
+</programlisting>
+
+  <para>
     When MySQL is installed on Windows using the MySQL Configuration
     Wizard, the <literal>InnoDB</literal> storage engine can be selected
     as the default instead of <literal>MyISAM</literal>. See