Author: jstephens
Date: 2007-10-12 18:07:54 +0200 (Fri, 12 Oct 2007)
New Revision: 8078
Log:
Make it clear that partitioned tables don't support key caches at all.
Fixes Docs Bug #31208.
Modified:
trunk/refman-5.1/partitioning.xml
trunk/refman-5.2/partitioning.xml
Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml 2007-10-12 15:54:55 UTC (rev 8077)
+++ trunk/refman-5.1/partitioning.xml 2007-10-12 16:07:54 UTC (rev 8078)
Changed blocks: 2, Lines Added: 14, Lines Deleted: 6; 1756 bytes
@@ -4636,7 +4636,7 @@
<listitem>
<formalpara>
- <title><literal>LOAD INDEX INTO CACHE</literal></title>
+ <title>Key caches not supported</title>
<indexterm>
<primary>partitioning</primary>
@@ -4644,16 +4644,24 @@
</indexterm>
<indexterm>
+ <primary>CACHE INDEX</primary>
+ <secondary>and partitioning</secondary>
+ </indexterm>
+
+ <indexterm>
<primary>LOAD INDEX INTO CACHE</primary>
<secondary>and partitioning</secondary>
</indexterm>
<para>
- The <literal>LOAD INDEX INTO CACHE</literal> statement is
- not supported for partitioned tables. Attempting to load an
- index from a partitioned table into a key cache results in
- the error <errortext>The storage engine for the table
- doesn't support preload_keys</errortext>.
+ Key caches are not supported for partitioned tables. The
+ <literal>LOAD CACHE</literal> and <literal>LOAD INDEX INTO
+ CACHE</literal> statements, when you attempt to use them on
+ tables having user-defined partitioning, fail with the
+ errors <errortext>The storage engine for the table doesn't
+ support assign_to_keycache</errortext> and <errortext>The
+ storage engine for the table doesn't support
+ preload_keys</errortext>, respectively.
</para>
</formalpara>
Modified: trunk/refman-5.2/partitioning.xml
===================================================================
--- trunk/refman-5.2/partitioning.xml 2007-10-12 15:54:55 UTC (rev 8077)
+++ trunk/refman-5.2/partitioning.xml 2007-10-12 16:07:54 UTC (rev 8078)
Changed blocks: 2, Lines Added: 14, Lines Deleted: 6; 1756 bytes
@@ -4528,7 +4528,7 @@
<listitem>
<formalpara>
- <title><literal>LOAD INDEX INTO CACHE</literal></title>
+ <title>Key caches not supported</title>
<indexterm>
<primary>partitioning</primary>
@@ -4536,16 +4536,24 @@
</indexterm>
<indexterm>
+ <primary>CACHE INDEX</primary>
+ <secondary>and partitioning</secondary>
+ </indexterm>
+
+ <indexterm>
<primary>LOAD INDEX INTO CACHE</primary>
<secondary>and partitioning</secondary>
</indexterm>
<para>
- The <literal>LOAD INDEX INTO CACHE</literal> statement is
- not supported for partitioned tables. Attempting to load an
- index from a partitioned table into a key cache results in
- the error <errortext>The storage engine for the table
- doesn't support preload_keys</errortext>.
+ Key caches are not supported for partitioned tables. The
+ <literal>LOAD CACHE</literal> and <literal>LOAD INDEX INTO
+ CACHE</literal> statements, when you attempt to use them on
+ tables having user-defined partitioning, fail with the
+ errors <errortext>The storage engine for the table doesn't
+ support assign_to_keycache</errortext> and <errortext>The
+ storage engine for the table doesn't support
+ preload_keys</errortext>, respectively.
</para>
</formalpara>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8078 - in trunk: refman-5.1 refman-5.2 | jon | 12 Oct |
