Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.3078 05/07/19 21:54:59 paul@stripped +8 -0
Update descriptions for myisam_data_pointer_size.
refman/sql-syntax.xml
1.13 05/07/19 21:54:57 paul@stripped +13 -10
Update descriptions for myisam_data_pointer_size.
refman/problems.xml
1.9 05/07/19 21:54:57 paul@stripped +5 -3
Update descriptions for myisam_data_pointer_size.
refman/mysql-database-administration.xml
1.29 05/07/19 21:54:56 paul@stripped +3 -3
Update descriptions for myisam_data_pointer_size.
refman-5.0/sql-syntax.xml
1.20 05/07/19 21:54:56 paul@stripped +14 -10
Sync.
refman-5.0/problems.xml
1.9 05/07/19 21:54:55 paul@stripped +5 -3
Sync.
refman-5.0/mysql-database-administration.xml
1.31 05/07/19 21:54:55 paul@stripped +2 -1
Sync.
refman-4.1/sql-syntax.xml
1.12 05/07/19 21:54:54 paul@stripped +12 -10
Sync.
refman-4.1/problems.xml
1.9 05/07/19 21:54:54 paul@stripped +3 -3
Sync.
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: frost.snake.net
# Root: /Volumes/frost2/MySQL/bk/mysqldoc
--- 1.8/refman-4.1/problems.xml 2005-07-19 10:57:24 -05:00
+++ 1.9/refman-4.1/problems.xml 2005-07-19 21:54:54 -05:00
@@ -1380,12 +1380,12 @@
<para>
You are using a <literal>MyISAM</literal> table and the
space required for the table exceeds what is allowed by the
- internal pointer size. (If you don't specify the
+ internal pointer size. If you don't specify the
<literal>MAX_ROWS</literal> table option when you create a
table, MySQL uses the
<literal>myisam_data_pointer_size</literal> system variable.
- Its default value of 4 bytes is enough to allow only 4GB of
- data.) See <xref linkend="server-system-variables"/>.
+ The default value is 4 bytes, which is enough to allow only
+ 4GB of data. See <xref linkend="server-system-variables"/>.
</para>
<para>
--- 1.11/refman-4.1/sql-syntax.xml 2005-07-19 14:01:38 -05:00
+++ 1.12/refman-4.1/sql-syntax.xml 2005-07-19 21:54:54 -05:00
@@ -2196,17 +2196,19 @@
uses the product of the <literal>MAX_ROWS</literal> and
<literal>AVG_ROW_LENGTH</literal> options to decide how big
the resulting table is. If you don't specify either option,
- the maximum size for a table is 4GB (or 2GB if your
- operating system only supports 2GB tables). The reason for
- this is just to keep down the pointer sizes to make the
- index smaller and faster if you don't really need big files.
- If you want all your tables to be able to grow above the 4GB
- limit and are willing to have your smaller tables slightly
- slower and larger than necessary, you may increase the
- default pointer size by setting the
+ the maximum size for a table is 4GB. (If your operating
+ system does not support files that large, table sizes are
+ constrained by the operating system limit.) If you want to
+ keep down the pointer sizes to make the index smaller and
+ faster and you don't really need big files, you can decrease
+ the default pointer size by setting the
<literal>myisam_data_pointer_size</literal> system variable,
- which was added in MySQL 4.1.2. See
- <xref linkend="server-system-variables"/>.
+ which was added in MySQL 4.1.2. (See
+ <xref linkend="server-system-variables"/>.) If you want all
+ your tables to be able to grow above the default limit and
+ are willing to have your tables slightly slower and larger
+ than necessary, you may increase the default pointer size by
+ setting this variable.
</para>
</listitem>
--- 1.30/refman-5.0/mysql-database-administration.xml 2005-07-19 10:57:32 -05:00
+++ 1.31/refman-5.0/mysql-database-administration.xml 2005-07-19 21:54:55 -05:00
@@ -7070,7 +7070,8 @@
<literal>MyISAM</literal> tables when no
<literal>MAX_ROWS</literal> option is specified. This
variable cannot be less than 2 or larger than 7. The default
- value is 4. See <xref linkend="full-table"/>.
+ value is 6 (4 before MySQL 5.0.6). This variable was added
+ in MySQL 4.1.2. See <xref linkend="full-table"/>.
</para>
</listitem>
--- 1.8/refman-5.0/problems.xml 2005-07-19 10:57:35 -05:00
+++ 1.9/refman-5.0/problems.xml 2005-07-19 21:54:55 -05:00
@@ -1380,12 +1380,14 @@
<para>
You are using a <literal>MyISAM</literal> table and the
space required for the table exceeds what is allowed by the
- internal pointer size. (If you don't specify the
+ internal pointer size. If you don't specify the
<literal>MAX_ROWS</literal> table option when you create a
table, MySQL uses the
<literal>myisam_data_pointer_size</literal> system variable.
- Its default value of 4 bytes is enough to allow only 4GB of
- data.) See <xref linkend="server-system-variables"/>.
+ From MySQL 5.0.6 on, the default value is 6 bytes, which is
+ enough to allow 65,536TB of data. Before MySQL 5.0.6, the
+ default value is 4 bytes, which is enough to allow only 4GB
+ of data. See <xref linkend="server-system-variables"/>.
</para>
<para>
--- 1.19/refman-5.0/sql-syntax.xml 2005-07-19 14:01:40 -05:00
+++ 1.20/refman-5.0/sql-syntax.xml 2005-07-19 21:54:56 -05:00
@@ -2165,16 +2165,20 @@
uses the product of the <literal>MAX_ROWS</literal> and
<literal>AVG_ROW_LENGTH</literal> options to decide how big
the resulting table is. If you don't specify either option,
- the maximum size for a table is 4GB (or 2GB if your
- operating system supports files with a maximum size of 2GB).
- The reason for this is to keep down the pointer sizes to
- make the index smaller and faster if you do not need large
- files. In MySQL 5.0, if you want all your tables to be able
- to grow above the 4GB limit and are willing to have smaller
- tables slightly slower and larger than necessary, you may
- increase the default pointer size by setting the
- <literal>myisam_data_pointer_size</literal> system variable.
- See <xref linkend="server-system-variables"/>.
+ the maximum size for a table is 65,536TB of data (4GB before
+ MySQL 5.0.6). (If your operating system does not support
+ files that large, table sizes are constrained by the
+ operating system limit.) If you want to keep down the
+ pointer sizes to make the index smaller and faster and you
+ don't really need big files, you can decrease the default
+ pointer size by setting the
+ <literal>myisam_data_pointer_size</literal> system variable,
+ which was added in MySQL 4.1.2. (See
+ <xref linkend="server-system-variables"/>.) If you want all
+ your tables to be able to grow above the default limit and
+ are willing to have your tables slightly slower and larger
+ than necessary, you may increase the default pointer size by
+ setting this variable.
</para>
</listitem>
--- 1.28/refman/mysql-database-administration.xml 2005-07-19 10:57:43 -05:00
+++ 1.29/refman/mysql-database-administration.xml 2005-07-19 21:54:56 -05:00
@@ -5149,7 +5149,7 @@
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
-| myisam_data_pointer_size | 4 |
+| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 107374182400 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
@@ -7388,8 +7388,8 @@
<literal>MyISAM</literal> tables when no
<literal>MAX_ROWS</literal> option is specified. This
variable cannot be less than 2 or larger than 7. The default
- value is 4. This variable was added in MySQL 4.1.2. See
- <xref linkend="full-table"/>.
+ value is 6 (4 before MySQL 5.0.6). This variable was added
+ in MySQL 4.1.2. See <xref linkend="full-table"/>.
</para>
</listitem>
--- 1.8/refman/problems.xml 2005-07-19 10:57:45 -05:00
+++ 1.9/refman/problems.xml 2005-07-19 21:54:57 -05:00
@@ -1380,12 +1380,14 @@
<para>
You are using a <literal>MyISAM</literal> table and the
space required for the table exceeds what is allowed by the
- internal pointer size. (If you don't specify the
+ internal pointer size. If you don't specify the
<literal>MAX_ROWS</literal> table option when you create a
table, MySQL uses the
<literal>myisam_data_pointer_size</literal> system variable.
- Its default value of 4 bytes is enough to allow only 4GB of
- data.) See <xref linkend="server-system-variables"/>.
+ From MySQL 5.0.6 on, the default value is 6 bytes, which is
+ enough to allow 65,536TB of data. Before MySQL 5.0.6, the
+ default value is 4 bytes, which is enough to allow only 4GB
+ of data. See <xref linkend="server-system-variables"/>.
</para>
<para>
--- 1.12/refman/sql-syntax.xml 2005-07-19 14:01:43 -05:00
+++ 1.13/refman/sql-syntax.xml 2005-07-19 21:54:57 -05:00
@@ -2196,17 +2196,20 @@
uses the product of the <literal>MAX_ROWS</literal> and
<literal>AVG_ROW_LENGTH</literal> options to decide how big
the resulting table is. If you don't specify either option,
- the maximum size for a table is 4GB (or 2GB if your
- operating system only supports 2GB tables). The reason for
- this is just to keep down the pointer sizes to make the
- index smaller and faster if you don't really need big files.
- If you want all your tables to be able to grow above the 4GB
- limit and are willing to have your smaller tables slightly
- slower and larger than necessary, you may increase the
- default pointer size by setting the
+ the maximum size for a table is 65,536TB of data (4GB before
+ MySQL 5.0.6). (If your operating system does not support
+ files that large, table sizes are constrained by the
+ operating system limit.) If you want to keep down the
+ pointer sizes to make the index smaller and faster and you
+ don't really need big files, you can decrease the default
+ pointer size by setting the
<literal>myisam_data_pointer_size</literal> system variable,
- which was added in MySQL 4.1.2. See
- <xref linkend="server-system-variables"/>.
+ which was added in MySQL 4.1.2. (See
+ <xref linkend="server-system-variables"/>.) If you want all
+ your tables to be able to grow above the default limit and
+ are willing to have your tables slightly slower and larger
+ than necessary, you may increase the default pointer size by
+ setting this variable.
</para>
</listitem>
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (paul:1.3078) | paul | 20 Jul |
