From: Date: July 13 2006 3:05pm
Subject: svn commit - mysqldoc@docsrva: r2726 - in trunk: refman-4.1 refman-5.0 refman-5.1
List-Archive: http://lists.mysql.com/commits/9121
Message-Id: <200607131305.k6DD5YOv009856@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
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] section of the
config.ini file. A value between
0 and 100 inclusive
- is interpreted as a percent; any value greater than
- 100 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 .FRM files,
+ MaxNoOfTriggers, 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.
+ A value greater than 100 is interpreted
+ as a number of bytes.
+
+
+
In MySQL ¤t-series;, the default value is
- 100 — that is, 100 percent. It is
- possible to reduce this amount safely, but it should never
- be less than 5 percent.
+ 100 — 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 Out of
+ string memory, please modify StringMemory config
+ parameter: Permanent error: Schema error, this
+ means that means that you have set the
+ StringMemory value too low.
+ 25 (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 NDB tables with names
+ whose lengths and columns whose number approach their
+ permitted maximums.
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] section of the
config.ini file. A value between
0 and 100 inclusive
- is interpreted as a percent; any value greater than
- 100 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 .FRM files,
+ MaxNoOfTriggers, 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.
+ A value greater than 100 is interpreted
+ as a number of bytes.
+
+
+
In MySQL ¤t-series;, the default value is
- 100 — that is, 100 percent. It is
- possible to reduce this amount safely, but it should never
- be less than 5 percent.
+ 100 — 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 Out of
+ string memory, please modify StringMemory config
+ parameter: Permanent error: Schema error, this
+ means that means that you have set the
+ StringMemory value too low.
+ 25 (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 NDB tables with names
+ whose lengths and columns whose number approach their
+ permitted maximums.
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] section of the
config.ini file. A value between
0 and 100 inclusive
- is interpreted as a percent; any value greater than
- 100 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 .FRM files,
+ MaxNoOfTriggers, 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.
+ A value greater than 100 is interpreted
+ as a number of bytes.
+
+
+
The default value is 5 — 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.)
+
+
+ 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
+ Out of string memory, please modify
+ StringMemory config parameter: Permanent error: Schema
+ error, in which case you should increase this
+ value. 25 (25 percent) is not
+ excessive, and should prevent this error from recurring in
+ all but the most extreme conditions.
+