Author: paul
Date: 2006-01-18 04:33:43 +0100 (Wed, 18 Jan 2006)
New Revision: 894
Log:
r6344@frost: paul | 2006-01-17 21:31:52 -0600
General revisions.
Modified:
trunk/
trunk/refman-4.1/client-utility-programs.xml
trunk/refman-4.1/installing.xml
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.0/installing.xml
trunk/refman-5.1/client-utility-programs.xml
trunk/refman-5.1/installing.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6343
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2265
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6344
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2265
Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-4.1/client-utility-programs.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -686,11 +686,11 @@
<refsynopsisdiv>
<cmdsynopsis>
- <command>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> …</command>
+ <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> …</command>
</cmdsynopsis>
<cmdsynopsis>
- <command>pack_isam [<replaceable>options</replaceable>] <replaceable>filename</replaceable> …</command>
+ <command>pack_isam [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> …</command>
</cmdsynopsis>
</refsynopsisdiv>
@@ -707,8 +707,8 @@
</para>
<para>
- When the table is used later, the information needed to
- decompress columns is read into memory. This results in much
+ When the table is used later, the server reads into memory the
+ information needed to decompress columns. This results in much
better performance when accessing individual records, because
you only have to uncompress exactly one record.
</para>
@@ -727,7 +727,9 @@
discusses only <command>myisampack</command>, but the general
procedures for using <command>myisampack</command> are also
true for <command>pack_isam</command> unless otherwise
- specified.
+ specified. References to <command>myisamchk</command> should
+ be read as references to <command>isamchk</command> if you are
+ using <command>pack_isam</command>.
</para>
<para>
@@ -739,10 +741,10 @@
<listitem>
<para>
If the <command>mysqld</command> server was invoked with
- the <option>--skip-external-locking</option> option, it is
- not a good idea to invoke <command>myisampack</command> if
- the table might be updated by the server during the
- packing process.
+ external locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process. It is
+ safest to compress tables with the server stopped.
</para>
</listitem>
@@ -759,8 +761,9 @@
<para>
<command>myisampack</command> can pack
<literal>BLOB</literal> or <literal>TEXT</literal>
- columns. The older <command>pack_isam</command> program
- for <literal>ISAM</literal> tables cannot.
+ columns. (The older <command>pack_isam</command> program
+ for <literal>ISAM</literal> tables does not have this
+ capability.)
</para>
</listitem>
@@ -771,11 +774,11 @@
</para>
<programlisting>
-shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> ...</userinput>
</programlisting>
<para>
- Each filename should be the name of an index
+ Each filename argument should be the name of an index
(<filename>.MYI</filename>) file. If you are not in the
database directory, you should specify the pathname to the
file. It is permissible to omit the <filename>.MYI</filename>
@@ -783,6 +786,12 @@
</para>
<para>
+ After you compress a table with <command>myisampack</command>,
+ you should use <command>myisamchk -rq</command> to rebuild its
+ indexes. <xref linkend="myisamchk"/>.
+ </para>
+
+ <para>
<command>myisampack</command> supports the following options:
</para>
@@ -804,7 +813,7 @@
</para>
<para>
- Make a backup of the table data file using the name
+ Make a backup of each table's data file using the name
<filename><replaceable>tbl_name</replaceable>.OLD</filename>.
</para>
</listitem>
@@ -873,12 +882,12 @@
value should be 1, 2, or 3. <command>myisampack</command>
stores all rows with length pointers of 1, 2, or 3 bytes.
In most normal cases, <command>myisampack</command> can
- determine the right length value before it begins packing
- the file, but it may notice during the packing process
- that it could have used a shorter length. In this case,
- <command>myisampack</command> prints a note that the next
- time you pack the same file, you could use a shorter
- record length.
+ determine the correct length value before it begins
+ packing the file, but it may notice during the packing
+ process that it could have used a shorter length. In this
+ case, <command>myisampack</command> prints a note that you
+ could use a shorter record length the next time you pack
+ the same file.
</para>
</listitem>
@@ -942,11 +951,10 @@
<para>
Wait and retry if the table is in use. If the
- <command>mysqld</command> server was invoked with the
- <option>--skip-external-locking</option> option, it is not
- a good idea to invoke <command>myisampack</command> if the
- table might be updated by the server during the packing
- process.
+ <command>mysqld</command> server was invoked with external
+ locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process.
</para>
</listitem>
@@ -1167,7 +1175,7 @@
<para>
The number of columns containing values that are only
- spaces; these occupy one bit.
+ spaces. These occupy one bit.
</para>
</listitem>
@@ -1178,7 +1186,7 @@
<para>
The number of columns containing values that are only
- binary zeros; these occupy one bit.
+ binary zeros. These occupy one bit.
</para>
</listitem>
@@ -1189,7 +1197,7 @@
<para>
The number of integer columns that do not occupy the full
- byte range of their type; these are changed to a smaller
+ byte range of their type. These are changed to a smaller
type. For example, a <literal>BIGINT</literal> column
(eight bytes) can be stored as a
<literal>TINYINT</literal> column (one byte) if all its
@@ -1341,11 +1349,11 @@
<listitem>
<para>
- <literal>zerofill(<replaceable>n</replaceable>)</literal>
+ <literal>zerofill(<replaceable>N</replaceable>)</literal>
</para>
<para>
- The most significant <replaceable>n</replaceable>
+ The most significant <replaceable>N</replaceable>
bytes in the value are always 0 and are not stored.
</para>
</listitem>
@@ -3044,8 +3052,8 @@
</para>
<programlisting>
-mysql> <userinput>source <replaceable>filename</replaceable></userinput>
-mysql> <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql> <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql> <userinput>\. <replaceable>file_name</replaceable></userinput>
</programlisting>
<para>
Modified: trunk/refman-4.1/installing.xml
===================================================================
--- trunk/refman-4.1/installing.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-4.1/installing.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -7652,6 +7652,10 @@
<secondary>log</secondary>
</indexterm>
+ <indexterm>
+ <primary>debugging support</primary>
+ </indexterm>
+
<para>
The <command>configure</command> script gives you a great deal
of control over how you configure a MySQL source distribution.
@@ -8060,8 +8064,9 @@
<para>
If you want to convert characters between the server and the
- client, you should take a look at the <literal>SET CHARACTER
- SET</literal> statement. See <xref linkend="set-option"/>.
+ client, you should look at the <literal>SET NAMES</literal>
+ statement. See <xref linkend="set-option"/>, and
+ <xref linkend="charset-connection"/>.
</para>
<indexterm>
@@ -16268,7 +16273,7 @@
Users of AIX 4.3 should use <command>gmake</command> instead
of the <command>make</command> utility included with AIX.
</para>
-
+
</section>
<section id="sunos">
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -651,7 +651,7 @@
<refsynopsisdiv>
<cmdsynopsis>
- <command>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> …</command>
+ <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> …</command>
</cmdsynopsis>
</refsynopsisdiv>
@@ -668,8 +668,8 @@
</para>
<para>
- When the table is used later, the information needed to
- decompress columns is read into memory. This results in much
+ When the table is used later, the server reads into memory the
+ information needed to decompress columns. This results in much
better performance when accessing individual records, because
you only have to uncompress exactly one record.
</para>
@@ -690,10 +690,10 @@
<listitem>
<para>
If the <command>mysqld</command> server was invoked with
- the <option>--skip-external-locking</option> option, it is
- not a good idea to invoke <command>myisampack</command> if
- the table might be updated by the server during the
- packing process.
+ external locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process. It is
+ safest to compress tables with the server stopped.
</para>
</listitem>
@@ -710,8 +710,9 @@
<para>
<command>myisampack</command> can pack
<literal>BLOB</literal> or <literal>TEXT</literal>
- columns. The older <command>pack_isam</command> program
- for <literal>ISAM</literal> tables cannot.
+ columns. (The older <command>pack_isam</command> program
+ for <literal>ISAM</literal> tables did not have this
+ capability.)
</para>
</listitem>
@@ -722,11 +723,11 @@
</para>
<programlisting>
-shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> ...</userinput>
</programlisting>
<para>
- Each filename should be the name of an index
+ Each filename argument should be the name of an index
(<filename>.MYI</filename>) file. If you are not in the
database directory, you should specify the pathname to the
file. It is permissible to omit the <filename>.MYI</filename>
@@ -734,6 +735,12 @@
</para>
<para>
+ After you compress a table with <command>myisampack</command>,
+ you should use <command>myisamchk -rq</command> to rebuild its
+ indexes. <xref linkend="myisamchk"/>.
+ </para>
+
+ <para>
<command>myisampack</command> supports the following options:
</para>
@@ -755,7 +762,7 @@
</para>
<para>
- Make a backup of the table data file using the name
+ Make a backup of each table's data file using the name
<filename><replaceable>tbl_name</replaceable>.OLD</filename>.
</para>
</listitem>
@@ -824,12 +831,12 @@
value should be 1, 2, or 3. <command>myisampack</command>
stores all rows with length pointers of 1, 2, or 3 bytes.
In most normal cases, <command>myisampack</command> can
- determine the right length value before it begins packing
- the file, but it may notice during the packing process
- that it could have used a shorter length. In this case,
- <command>myisampack</command> prints a note that the next
- time you pack the same file, you could use a shorter
- record length.
+ determine the correct length value before it begins
+ packing the file, but it may notice during the packing
+ process that it could have used a shorter length. In this
+ case, <command>myisampack</command> prints a note that you
+ could use a shorter record length the next time you pack
+ the same file.
</para>
</listitem>
@@ -893,11 +900,10 @@
<para>
Wait and retry if the table is in use. If the
- <command>mysqld</command> server was invoked with the
- <option>--skip-external-locking</option> option, it is not
- a good idea to invoke <command>myisampack</command> if the
- table might be updated by the server during the packing
- process.
+ <command>mysqld</command> server was invoked with external
+ locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process.
</para>
</listitem>
@@ -1118,7 +1124,7 @@
<para>
The number of columns containing values that are only
- spaces; these occupy one bit.
+ spaces. These occupy one bit.
</para>
</listitem>
@@ -1129,7 +1135,7 @@
<para>
The number of columns containing values that are only
- binary zeros; these occupy one bit.
+ binary zeros. These occupy one bit.
</para>
</listitem>
@@ -1140,7 +1146,7 @@
<para>
The number of integer columns that do not occupy the full
- byte range of their type; these are changed to a smaller
+ byte range of their type. These are changed to a smaller
type. For example, a <literal>BIGINT</literal> column
(eight bytes) can be stored as a
<literal>TINYINT</literal> column (one byte) if all its
@@ -1292,11 +1298,11 @@
<listitem>
<para>
- <literal>zerofill(<replaceable>n</replaceable>)</literal>
+ <literal>zerofill(<replaceable>N</replaceable>)</literal>
</para>
<para>
- The most significant <replaceable>n</replaceable>
+ The most significant <replaceable>N</replaceable>
bytes in the value are always 0 and are not stored.
</para>
</listitem>
@@ -1366,8 +1372,7 @@
<para>
To unpack a packed table, use the <option>--unpack</option>
- option to <command>myisamchk</command> or
- <command>isamchk</command>.
+ option to <command>myisamchk</command>.
</para>
</refsection>
@@ -3001,8 +3006,8 @@
</para>
<programlisting>
-mysql> <userinput>source <replaceable>filename</replaceable></userinput>
-mysql> <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql> <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql> <userinput>\. <replaceable>file_name</replaceable></userinput>
</programlisting>
<para>
Modified: trunk/refman-5.0/installing.xml
===================================================================
--- trunk/refman-5.0/installing.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-5.0/installing.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -7608,6 +7608,10 @@
<secondary>log</secondary>
</indexterm>
+ <indexterm>
+ <primary>debugging support</primary>
+ </indexterm>
+
<para>
The <command>configure</command> script gives you a great deal
of control over how you configure a MySQL source distribution.
@@ -8016,8 +8020,9 @@
<para>
If you want to convert characters between the server and the
- client, you should look at the <literal>SET CHARACTER
- SET</literal> statement. See <xref linkend="set-option"/>.
+ client, you should look at the <literal>SET NAMES</literal>
+ statement. See <xref linkend="set-option"/>, and
+ <xref linkend="charset-connection"/>.
</para>
<indexterm>
@@ -15445,7 +15450,7 @@
Users of AIX 4.3 should use <command>gmake</command> instead
of the <command>make</command> utility included with AIX.
</para>
-
+
</section>
<section id="sunos">
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -667,7 +667,7 @@
<refsynopsisdiv>
<cmdsynopsis>
- <command>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> …</command>
+ <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> …</command>
</cmdsynopsis>
</refsynopsisdiv>
@@ -684,8 +684,8 @@
</para>
<para>
- When the table is used later, the information needed to
- decompress columns is read into memory. This results in much
+ When the table is used later, the server reads into memory the
+ information needed to decompress columns. This results in much
better performance when accessing individual records, because
you only have to uncompress exactly one record.
</para>
@@ -706,10 +706,10 @@
<listitem>
<para>
If the <command>mysqld</command> server was invoked with
- the <option>--skip-external-locking</option> option, it is
- not a good idea to invoke <command>myisampack</command> if
- the table might be updated by the server during the
- packing process.
+ external locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process. It is
+ safest to compress tables with the server stopped.
</para>
</listitem>
@@ -726,8 +726,9 @@
<para>
<command>myisampack</command> can pack
<literal>BLOB</literal> or <literal>TEXT</literal>
- columns. The older <command>pack_isam</command> program
- for <literal>ISAM</literal> tables cannot.
+ columns. (The older <command>pack_isam</command> program
+ for <literal>ISAM</literal> tables did not have this
+ capability.)
</para>
</listitem>
@@ -738,11 +739,11 @@
</para>
<programlisting>
-shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell> <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> ...</userinput>
</programlisting>
<para>
- Each filename should be the name of an index
+ Each filename argument should be the name of an index
(<filename>.MYI</filename>) file. If you are not in the
database directory, you should specify the pathname to the
file. It is permissible to omit the <filename>.MYI</filename>
@@ -750,6 +751,12 @@
</para>
<para>
+ After you compress a table with <command>myisampack</command>,
+ you should use <command>myisamchk -rq</command> to rebuild its
+ indexes. <xref linkend="myisamchk"/>.
+ </para>
+
+ <para>
<command>myisampack</command> supports the following options:
</para>
@@ -771,7 +778,7 @@
</para>
<para>
- Make a backup of the table data file using the name
+ Make a backup of each table's data file using the name
<filename><replaceable>tbl_name</replaceable>.OLD</filename>.
</para>
</listitem>
@@ -840,12 +847,12 @@
value should be 1, 2, or 3. <command>myisampack</command>
stores all rows with length pointers of 1, 2, or 3 bytes.
In most normal cases, <command>myisampack</command> can
- determine the right length value before it begins packing
- the file, but it may notice during the packing process
- that it could have used a shorter length. In this case,
- <command>myisampack</command> prints a note that the next
- time you pack the same file, you could use a shorter
- record length.
+ determine the correct length value before it begins
+ packing the file, but it may notice during the packing
+ process that it could have used a shorter length. In this
+ case, <command>myisampack</command> prints a note that you
+ could use a shorter record length the next time you pack
+ the same file.
</para>
</listitem>
@@ -909,11 +916,10 @@
<para>
Wait and retry if the table is in use. If the
- <command>mysqld</command> server was invoked with the
- <option>--skip-external-locking</option> option, it is not
- a good idea to invoke <command>myisampack</command> if the
- table might be updated by the server during the packing
- process.
+ <command>mysqld</command> server was invoked with external
+ locking disabled, it is not a good idea to invoke
+ <command>myisampack</command> if the table might be
+ updated by the server during the packing process.
</para>
</listitem>
@@ -1134,7 +1140,7 @@
<para>
The number of columns containing values that are only
- spaces; these occupy one bit.
+ spaces. These occupy one bit.
</para>
</listitem>
@@ -1145,7 +1151,7 @@
<para>
The number of columns containing values that are only
- binary zeros; these occupy one bit.
+ binary zeros. These occupy one bit.
</para>
</listitem>
@@ -1156,7 +1162,7 @@
<para>
The number of integer columns that do not occupy the full
- byte range of their type; these are changed to a smaller
+ byte range of their type. These are changed to a smaller
type. For example, a <literal>BIGINT</literal> column
(eight bytes) can be stored as a
<literal>TINYINT</literal> column (one byte) if all its
@@ -1308,11 +1314,11 @@
<listitem>
<para>
- <literal>zerofill(<replaceable>n</replaceable>)</literal>
+ <literal>zerofill(<replaceable>N</replaceable>)</literal>
</para>
<para>
- The most significant <replaceable>n</replaceable>
+ The most significant <replaceable>N</replaceable>
bytes in the value are always 0 and are not stored.
</para>
</listitem>
@@ -1382,8 +1388,7 @@
<para>
To unpack a packed table, use the <option>--unpack</option>
- option to <command>myisamchk</command> or
- <command>isamchk</command>.
+ option to <command>myisamchk</command>.
</para>
</refsection>
@@ -3016,8 +3021,8 @@
</para>
<programlisting>
-mysql> <userinput>source <replaceable>filename</replaceable></userinput>
-mysql> <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql> <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql> <userinput>\. <replaceable>file_name</replaceable></userinput>
</programlisting>
<para>
Modified: trunk/refman-5.1/installing.xml
===================================================================
--- trunk/refman-5.1/installing.xml 2006-01-18 03:33:29 UTC (rev 893)
+++ trunk/refman-5.1/installing.xml 2006-01-18 03:33:43 UTC (rev 894)
@@ -7601,6 +7601,10 @@
<secondary>log</secondary>
</indexterm>
+ <indexterm>
+ <primary>debugging support</primary>
+ </indexterm>
+
<para>
The <command>configure</command> script gives you a great deal
of control over how you configure a MySQL source distribution.
@@ -8009,8 +8013,9 @@
<para>
If you want to convert characters between the server and the
- client, you should look at the <literal>SET CHARACTER
- SET</literal> statement. See <xref linkend="set-option"/>.
+ client, you should look at the <literal>SET NAMES</literal>
+ statement. See <xref linkend="set-option"/>, and
+ <xref linkend="charset-connection"/>.
</para>
<indexterm>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r894 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 18 Jan |
