Author: mcbrown
Date: 2009-10-15 12:39:11 +0200 (Thu, 15 Oct 2009)
New Revision: 17167
Log:
Adding some clarification and rewording to address Docs Bug #36850
Modified:
trunk/refman-5.0/data-types.xml
trunk/refman-5.1/data-types.xml
trunk/refman-5.4/data-types.xml
trunk/refman-5.5/data-types.xml
Modified: trunk/refman-5.0/data-types.xml
===================================================================
--- trunk/refman-5.0/data-types.xml 2009-10-15 10:20:27 UTC (rev 17166)
+++ trunk/refman-5.0/data-types.xml 2009-10-15 10:39:11 UTC (rev 17167)
Changed blocks: 5, Lines Added: 44, Lines Deleted: 12; 3688 bytes
@@ -5684,10 +5684,31 @@
</indexterm>
<para>
- The storage requirements for each of the data types supported by
- MySQL are listed here by category.
+ The storage requirements for data vary, according to the storage
+ engine being used for the table in question. Different storage
+ engines use different methods for recording the raw data and
+ different data types. In addition, some engines may compress the
+ information in a given row, either on a column or entire row
+ basis, making calculation of the storage requirements for a given
+ table or column structure.
</para>
+ <para>
+ However, all storage engines must communicate and exchange
+ information on a given row within a table using the same
+ structure, and this information is consistent, irrespective of the
+ storage engine used to write the information to disk.
+ </para>
+
+ <para>
+ This sections includes some guideliness and information for the
+ the storage requirements for each of the data types supported by
+ MySQL, including details for the internal format and the sizes
+ used by storage engines that used a fixed size representation for
+ different types. Information is listed by category and/or storage
+ engine.
+ </para>
+
<indexterm>
<primary>table</primary>
<secondary>row size</secondary>
@@ -5695,10 +5716,21 @@
<para>
The maximum size of a row in a <literal>MyISAM</literal> table is
- 65,535 bytes. (However, each <literal role="type">BLOB</literal>
- or <literal role="type">TEXT</literal> column contributes only
- 9–12 bytes toward this size.) This limitation may be shared
- by other storage engines as well. See
+ 65,535 bytes. This figure excludes
+ <literal role="type">BLOB</literal> or
+ <literal role="type">TEXT</literal> columns, which contribute only
+ 9–12 bytes toward this size.
+ </para>
+
+ <para>
+ The internal representation of a table also has a maximum row size
+ of 65,535 bytes, even if the storage engine is capable of
+ supporting larger rows. For <literal role="type">BLOB</literal>
+ and and <literal role="text">TEXT</literal> data, the information
+ is stored internally in a different area of memory than the row
+ buffer. Different storage engines handle the allocation and
+ storage of this data in different ways, according to the method
+ they use for handling the corresponding types. See
<xref linkend="storage-engines"/>, for more information.
</para>
@@ -5788,8 +5820,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Numeric
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Numeric Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5945,8 +5977,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Date and Time
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Date and Time Types
+ in <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -6052,8 +6084,8 @@
</itemizedlist>
<para>
- <emphasis role="bold">Storage Requirements for String
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for String Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<para>
Modified: trunk/refman-5.1/data-types.xml
===================================================================
--- trunk/refman-5.1/data-types.xml 2009-10-15 10:20:27 UTC (rev 17166)
+++ trunk/refman-5.1/data-types.xml 2009-10-15 10:39:11 UTC (rev 17167)
Changed blocks: 5, Lines Added: 44, Lines Deleted: 12; 3688 bytes
@@ -5410,10 +5410,31 @@
</indexterm>
<para>
- The storage requirements for each of the data types supported by
- MySQL are listed here by category.
+ The storage requirements for data vary, according to the storage
+ engine being used for the table in question. Different storage
+ engines use different methods for recording the raw data and
+ different data types. In addition, some engines may compress the
+ information in a given row, either on a column or entire row
+ basis, making calculation of the storage requirements for a given
+ table or column structure.
</para>
+ <para>
+ However, all storage engines must communicate and exchange
+ information on a given row within a table using the same
+ structure, and this information is consistent, irrespective of the
+ storage engine used to write the information to disk.
+ </para>
+
+ <para>
+ This sections includes some guideliness and information for the
+ the storage requirements for each of the data types supported by
+ MySQL, including details for the internal format and the sizes
+ used by storage engines that used a fixed size representation for
+ different types. Information is listed by category and/or storage
+ engine.
+ </para>
+
<indexterm>
<primary>table</primary>
<secondary>row size</secondary>
@@ -5421,10 +5442,21 @@
<para>
The maximum size of a row in a <literal>MyISAM</literal> table is
- 65,535 bytes. (However, each <literal role="type">BLOB</literal>
- or <literal role="type">TEXT</literal> column contributes only
- 9–12 bytes toward this size.) This limitation may be shared
- by other storage engines as well. See
+ 65,535 bytes. This figure excludes
+ <literal role="type">BLOB</literal> or
+ <literal role="type">TEXT</literal> columns, which contribute only
+ 9–12 bytes toward this size.
+ </para>
+
+ <para>
+ The internal representation of a table also has a maximum row size
+ of 65,535 bytes, even if the storage engine is capable of
+ supporting larger rows. For <literal role="type">BLOB</literal>
+ and and <literal role="text">TEXT</literal> data, the information
+ is stored internally in a different area of memory than the row
+ buffer. Different storage engines handle the allocation and
+ storage of this data in different ways, according to the method
+ they use for handling the corresponding types. See
<xref linkend="storage-engines"/>, for more information.
</para>
@@ -5514,8 +5546,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Numeric
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Numeric Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5654,8 +5686,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Date and Time
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Date and Time Types
+ in <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5761,8 +5793,8 @@
</itemizedlist>
<para>
- <emphasis role="bold">Storage Requirements for String
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for String Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<para>
Modified: trunk/refman-5.4/data-types.xml
===================================================================
--- trunk/refman-5.4/data-types.xml 2009-10-15 10:20:27 UTC (rev 17166)
+++ trunk/refman-5.4/data-types.xml 2009-10-15 10:39:11 UTC (rev 17167)
Changed blocks: 5, Lines Added: 44, Lines Deleted: 12; 3688 bytes
@@ -5405,10 +5405,31 @@
</indexterm>
<para>
- The storage requirements for each of the data types supported by
- MySQL are listed here by category.
+ The storage requirements for data vary, according to the storage
+ engine being used for the table in question. Different storage
+ engines use different methods for recording the raw data and
+ different data types. In addition, some engines may compress the
+ information in a given row, either on a column or entire row
+ basis, making calculation of the storage requirements for a given
+ table or column structure.
</para>
+ <para>
+ However, all storage engines must communicate and exchange
+ information on a given row within a table using the same
+ structure, and this information is consistent, irrespective of the
+ storage engine used to write the information to disk.
+ </para>
+
+ <para>
+ This sections includes some guideliness and information for the
+ the storage requirements for each of the data types supported by
+ MySQL, including details for the internal format and the sizes
+ used by storage engines that used a fixed size representation for
+ different types. Information is listed by category and/or storage
+ engine.
+ </para>
+
<indexterm>
<primary>table</primary>
<secondary>row size</secondary>
@@ -5416,10 +5437,21 @@
<para>
The maximum size of a row in a <literal>MyISAM</literal> table is
- 65,535 bytes. (However, each <literal role="type">BLOB</literal>
- or <literal role="type">TEXT</literal> column contributes only
- 9–12 bytes toward this size.) This limitation may be shared
- by other storage engines as well. See
+ 65,535 bytes. This figure excludes
+ <literal role="type">BLOB</literal> or
+ <literal role="type">TEXT</literal> columns, which contribute only
+ 9–12 bytes toward this size.
+ </para>
+
+ <para>
+ The internal representation of a table also has a maximum row size
+ of 65,535 bytes, even if the storage engine is capable of
+ supporting larger rows. For <literal role="type">BLOB</literal>
+ and and <literal role="text">TEXT</literal> data, the information
+ is stored internally in a different area of memory than the row
+ buffer. Different storage engines handle the allocation and
+ storage of this data in different ways, according to the method
+ they use for handling the corresponding types. See
<xref linkend="storage-engines"/>, for more information.
</para>
@@ -5509,8 +5541,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Numeric
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Numeric Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5649,8 +5681,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Date and Time
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Date and Time Types
+ in <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5756,8 +5788,8 @@
</itemizedlist>
<para>
- <emphasis role="bold">Storage Requirements for String
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for String Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<para>
Modified: trunk/refman-5.5/data-types.xml
===================================================================
--- trunk/refman-5.5/data-types.xml 2009-10-15 10:20:27 UTC (rev 17166)
+++ trunk/refman-5.5/data-types.xml 2009-10-15 10:39:11 UTC (rev 17167)
Changed blocks: 5, Lines Added: 44, Lines Deleted: 12; 3688 bytes
@@ -5405,10 +5405,31 @@
</indexterm>
<para>
- The storage requirements for each of the data types supported by
- MySQL are listed here by category.
+ The storage requirements for data vary, according to the storage
+ engine being used for the table in question. Different storage
+ engines use different methods for recording the raw data and
+ different data types. In addition, some engines may compress the
+ information in a given row, either on a column or entire row
+ basis, making calculation of the storage requirements for a given
+ table or column structure.
</para>
+ <para>
+ However, all storage engines must communicate and exchange
+ information on a given row within a table using the same
+ structure, and this information is consistent, irrespective of the
+ storage engine used to write the information to disk.
+ </para>
+
+ <para>
+ This sections includes some guideliness and information for the
+ the storage requirements for each of the data types supported by
+ MySQL, including details for the internal format and the sizes
+ used by storage engines that used a fixed size representation for
+ different types. Information is listed by category and/or storage
+ engine.
+ </para>
+
<indexterm>
<primary>table</primary>
<secondary>row size</secondary>
@@ -5416,10 +5437,21 @@
<para>
The maximum size of a row in a <literal>MyISAM</literal> table is
- 65,535 bytes. (However, each <literal role="type">BLOB</literal>
- or <literal role="type">TEXT</literal> column contributes only
- 9–12 bytes toward this size.) This limitation may be shared
- by other storage engines as well. See
+ 65,535 bytes. This figure excludes
+ <literal role="type">BLOB</literal> or
+ <literal role="type">TEXT</literal> columns, which contribute only
+ 9–12 bytes toward this size.
+ </para>
+
+ <para>
+ The internal representation of a table also has a maximum row size
+ of 65,535 bytes, even if the storage engine is capable of
+ supporting larger rows. For <literal role="type">BLOB</literal>
+ and and <literal role="text">TEXT</literal> data, the information
+ is stored internally in a different area of memory than the row
+ buffer. Different storage engines handle the allocation and
+ storage of this data in different ways, according to the method
+ they use for handling the corresponding types. See
<xref linkend="storage-engines"/>, for more information.
</para>
@@ -5509,8 +5541,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Numeric
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Numeric Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5649,8 +5681,8 @@
</indexterm>
<para>
- <emphasis role="bold">Storage Requirements for Date and Time
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for Date and Time Types
+ in <literal>MyISAM</literal></emphasis>
</para>
<informaltable>
@@ -5756,8 +5788,8 @@
</itemizedlist>
<para>
- <emphasis role="bold">Storage Requirements for String
- Types</emphasis>
+ <emphasis role="bold">Storage Requirements for String Types in
+ <literal>MyISAM</literal></emphasis>
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r17167 - in trunk: refman-5.0 refman-5.1 refman-5.4 refman-5.5 | martin.brown | 15 Oct |
