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

[jstephens]

Author: jstephens
Date: 2006-07-13 15:05:30 +0200 (Thu, 13 Jul 2006)
New Revision: 2726

Log:
Updated info about StringMemory parameter (Pekka and Hartmut)

Modified:
   trunk/refman-4.1/mysql-cluster.xml
   trunk/refman-5.0/mysql-cluster.xml
   trunk/refman-5.1/mysql-cluster.xml


Modified: trunk/refman-4.1/mysql-cluster.xml
===================================================================
--- trunk/refman-4.1/mysql-cluster.xml	2006-07-13 10:57:48 UTC (rev 2725)
+++ trunk/refman-4.1/mysql-cluster.xml	2006-07-13 13:05:30 UTC (rev 2726)
Changed blocks: 1, Lines Added: 27, Lines Deleted: 6; 2559 bytes

@@ -3684,16 +3684,37 @@
               DEFAULT]</literal> section of the
               <filename>config.ini</filename> file. A value between
               <literal>0</literal> and <literal>100</literal>
inclusive
-              is interpreted as a percent; any value greater than
-              <literal>100</literal> is interpreted as a number of
-              bytes.
+              is interpreted as a percent of the maxmimum default value,
+              which is calculated based on a number of factors including
+              the number of tables, maximum table name size, maximum
+              size of <filename>.FRM</filename> files,
+              <literal>MaxNoOfTriggers</literal>, maximum column name
+              size, and maximum default column value. In general it is
+              safe to assume that the maximum default value is
+              approximately 5 MB for a MySQL Cluster having 1000 tables.
             </para>
 
             <para>
+              A value greater than <literal>100</literal> is interpreted
+              as a number of bytes.
+            </para>
+
+            <para>
               In MySQL &current-series;, the default value is
-              <literal>100</literal> &mdash; that is, 100 percent. It is
-              possible to reduce this amount safely, but it should never
-              be less than 5 percent.
+              <literal>100</literal> &mdash; that is, 100 percent of the
+              default maximum, or roughly 5 MB. It is possible to reduce
+              this value safely, but it should never be less than 5
+              percent. If you encounter Error 773 <errortext>Out of
+              string memory, please modify StringMemory config
+              parameter: Permanent error: Schema error</errortext>, this
+              means that means that you have set the
+              <literal>StringMemory</literal> value too low.
+              <literal>25</literal> (25 percent) is not excessive, and
+              should prevent this error from recurring in all but the
+              most extreme conditions, as when there are hundreds or
+              thousands of <literal>NDB</literal> tables with names
+              whose lengths and columns whose number approach their
+              permitted maximums.
             </para>
           </listitem>
 


Modified: trunk/refman-5.0/mysql-cluster.xml
===================================================================
--- trunk/refman-5.0/mysql-cluster.xml	2006-07-13 10:57:48 UTC (rev 2725)
+++ trunk/refman-5.0/mysql-cluster.xml	2006-07-13 13:05:30 UTC (rev 2726)
Changed blocks: 1, Lines Added: 27, Lines Deleted: 6; 2559 bytes

@@ -3671,16 +3671,37 @@
               DEFAULT]</literal> section of the
               <filename>config.ini</filename> file. A value between
               <literal>0</literal> and <literal>100</literal>
inclusive
-              is interpreted as a percent; any value greater than
-              <literal>100</literal> is interpreted as a number of
-              bytes.
+              is interpreted as a percent of the maxmimum default value,
+              which is calculated based on a number of factors including
+              the number of tables, maximum table name size, maximum
+              size of <filename>.FRM</filename> files,
+              <literal>MaxNoOfTriggers</literal>, maximum column name
+              size, and maximum default column value. In general it is
+              safe to assume that the maximum default value is
+              approximately 5 MB for a MySQL Cluster having 1000 tables.
             </para>
 
             <para>
+              A value greater than <literal>100</literal> is interpreted
+              as a number of bytes.
+            </para>
+
+            <para>
               In MySQL &current-series;, the default value is
-              <literal>100</literal> &mdash; that is, 100 percent. It is
-              possible to reduce this amount safely, but it should never
-              be less than 5 percent.
+              <literal>100</literal> &mdash; that is, 100 percent of the
+              default maximum, or roughly 5 MB. It is possible to reduce
+              this value safely, but it should never be less than 5
+              percent. If you encounter Error 773 <errortext>Out of
+              string memory, please modify StringMemory config
+              parameter: Permanent error: Schema error</errortext>, this
+              means that means that you have set the
+              <literal>StringMemory</literal> value too low.
+              <literal>25</literal> (25 percent) is not excessive, and
+              should prevent this error from recurring in all but the
+              most extreme conditions, as when there are hundreds or
+              thousands of <literal>NDB</literal> tables with names
+              whose lengths and columns whose number approach their
+              permitted maximums.
             </para>
           </listitem>
 


Modified: trunk/refman-5.1/mysql-cluster.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster.xml	2006-07-13 10:57:48 UTC (rev 2725)
+++ trunk/refman-5.1/mysql-cluster.xml	2006-07-13 13:05:30 UTC (rev 2726)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 5; 2401 bytes

@@ -3668,16 +3668,39 @@
               DEFAULT]</literal> section of the
               <filename>config.ini</filename> file. A value between
               <literal>0</literal> and <literal>100</literal>
inclusive
-              is interpreted as a percent; any value greater than
-              <literal>100</literal> is interpreted as a number of
-              bytes.
+              is interpreted as a percent of the maxmimum default value,
+              which is calculated based on a number of factors including
+              the number of tables, maximum table name size, maximum
+              size of <filename>.FRM</filename> files,
+              <literal>MaxNoOfTriggers</literal>, maximum column name
+              size, and maximum default column value. In general it is
+              safe to assume that the maximum default value is
+              approximately 5 MB for a MySQL Cluster having 1000 tables.
             </para>
 
             <para>
+              A value greater than <literal>100</literal> is interpreted
+              as a number of bytes.
+            </para>
+
+            <para>
               The default value is <literal>5</literal> &mdash; that is,
-              5 percent. (Note that this is a change from previous
-              versions of MySQL Cluster.)
+              5 percent of the default maximum, or roughly 5 KB. (Note
+              that this is a change from previous versions of MySQL
+              Cluster.)
             </para>
+
+            <para>
+              Under most circumstances, the default value should be
+              sufficient, but when you have a great many Cluster tables
+              (1000 or more), it is possible to get Error 773
+              <errortext>Out of string memory, please modify
+              StringMemory config parameter: Permanent error: Schema
+              error</errortext>, in which case you should increase this
+              value. <literal>25</literal> (25 percent) is not
+              excessive, and should prevent this error from recurring in
+              all but the most extreme conditions.
+            </para>
           </listitem>
 
         </itemizedlist>