List:Commits« Previous MessageNext Message »
From:paul Date:January 18 2006 3:33am
Subject:svn commit - mysqldoc@docsrva: r894 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
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> &hellip;</command>
+          <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> &hellip;</command>
         </cmdsynopsis>
          
         <cmdsynopsis>
-          <command>pack_isam [<replaceable>options</replaceable>] <replaceable>filename</replaceable> &hellip;</command>
+          <command>pack_isam [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> &hellip;</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&gt; <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell&gt; <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&gt; <userinput>source <replaceable>filename</replaceable></userinput>
-mysql&gt; <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql&gt; <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql&gt; <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> &hellip;</command>
+          <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> &hellip;</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&gt; <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell&gt; <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&gt; <userinput>source <replaceable>filename</replaceable></userinput>
-mysql&gt; <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql&gt; <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql&gt; <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> &hellip;</command>
+          <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> &hellip;</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&gt; <userinput>myisampack [<replaceable>options</replaceable>] <replaceable>filename</replaceable> ...</userinput>
+shell&gt; <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&gt; <userinput>source <replaceable>filename</replaceable></userinput>
-mysql&gt; <userinput>\. <replaceable>filename</replaceable></userinput>
+mysql&gt; <userinput>source <replaceable>file_name</replaceable></userinput>
+mysql&gt; <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.1paul18 Jan