MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:March 25 2007 4:48am
Subject:svn commit - mysqldoc@docsrva: r5552 - in trunk: refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: jstephens
Date: 2007-03-25 06:47:56 +0200 (Sun, 25 Mar 2007)
New Revision: 5552

Log:

Made it unambiguous that running myisamchk whilst other programs are 
accessing tables can result in damaging the tables. (User comments)



Modified:
   trunk/refman-4.1/client-utility-programs.xml
   trunk/refman-5.0/client-utility-programs.xml
   trunk/refman-5.1/client-utility-programs.xml


Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml	2007-03-24 23:31:01 UTC (rev 5551)
+++ trunk/refman-4.1/client-utility-programs.xml	2007-03-25 04:47:56 UTC (rev 5552)
Changed blocks: 1, Lines Added: 34, Lines Deleted: 22; 3216 bytes

@@ -1207,34 +1207,46 @@
           <command>myisamchk</command>, see
           <xref linkend="myisamchk-memory"/>.
         </para>
+        
+        <important>
+          <para>
+            <emphasis>You must ensure that no other program is using the
+            tables while you are running
+            <command>myisamchk</command></emphasis>. Otherwise, when you
+            run <command>myisamchk</command>, it may display the
+            following error message: 
+          </para>
 
-        <para>
-          You must ensure that no other program is using the tables
-          while you are running <command>myisamchk</command>. Otherwise,
-          when you run <command>myisamchk</command>, it may display the
-          following error message:
-        </para>
-
 <programlisting>
 warning: clients are using or haven't closed the table properly
 </programlisting>
 
-        <para>
-          This means that you are trying to check a table that has been
-          updated by another program (such as the
-          <command>mysqld</command> server) that hasn't yet closed the
-          file or that has died without closing the file properly.
-        </para>
+          <para>
+            This means that you are trying to check a table that has been
+            updated by another program (such as the
+            <command>mysqld</command> server) that hasn't yet closed the
+            file or that has died without closing the file properly,
+            which can sometimes lead to the corruption of one or more
+            <literal>MyISAM</literal> tables.
+          </para>
+          
+          <para>
+            If <command>mysqld</command> is running, you must force it
+            to flush any table modifications that are still buffered in
+            memory by using <literal>FLUSH TABLES</literal>. You should
+            then ensure that no one is using the tables while you are
+            running <command>myisamchk</command>, the most effective
+            means of doing so being to shut down the MySQL server while
+            running <literal>myisamchk</literal>. 
+          </para>
 
-        <para>
-          If <command>mysqld</command> is running, you must force it to
-          flush any table modifications that are still buffered in
-          memory by using <literal>FLUSH TABLES</literal>. You should
-          then ensure that no one is using the tables while you are
-          running <command>myisamchk</command>. The easiest way to avoid
-          this problem is to use <literal>CHECK TABLE</literal> instead
-          of <command>myisamchk</command> to check tables.
-        </para>
+          <para>
+            However, the easiest way to avoid this problem is to use
+            <literal>CHECK TABLE</literal> instead of
+            <command>myisamchk</command> to check tables. See 
+            <xref linkend="check-table"/>.            
+          </para>
+        </important>
 
       </refsection>
 


Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml	2007-03-24 23:31:01 UTC (rev 5551)
+++ trunk/refman-5.0/client-utility-programs.xml	2007-03-25 04:47:56 UTC (rev 5552)
Changed blocks: 1, Lines Added: 37, Lines Deleted: 25; 3299 bytes

@@ -1312,35 +1312,47 @@
           <command>myisamchk</command>, see
           <xref linkend="myisamchk-memory"/>.
         </para>
-
-        <para>
-          You must ensure that no other program is using the tables
-          while you are running <command>myisamchk</command>. Otherwise,
-          when you run <command>myisamchk</command>, it may display the
-          following error message:
-        </para>
-
+        
+        <important>
+          <para>
+            <emphasis>You must ensure that no other program is using the
+            tables while you are running
+            <command>myisamchk</command></emphasis>. Otherwise, when you
+            run <command>myisamchk</command>, it may display the
+            following error message: 
+          </para>
+          
 <programlisting>
 warning: clients are using or haven't closed the table properly
 </programlisting>
+          
+          <para>
+            This means that you are trying to check a table that has been
+            updated by another program (such as the
+            <command>mysqld</command> server) that hasn't yet closed the
+            file or that has died without closing the file properly,
+            which can sometimes lead to the corruption of one or more
+            <literal>MyISAM</literal> tables.
+          </para>
+          
+          <para>
+            If <command>mysqld</command> is running, you must force it
+            to flush any table modifications that are still buffered in
+            memory by using <literal>FLUSH TABLES</literal>. You should
+            then ensure that no one is using the tables while you are
+            running <command>myisamchk</command>, the most effective
+            means of doing so being to shut down the MySQL server while
+            running <literal>myisamchk</literal>. 
+          </para>
+          
+          <para>
+            However, the easiest way to avoid this problem is to use
+            <literal>CHECK TABLE</literal> instead of
+            <command>myisamchk</command> to check tables. See 
+            <xref linkend="check-table"/>.            
+          </para>
+        </important>
 
-        <para>
-          This means that you are trying to check a table that has been
-          updated by another program (such as the
-          <command>mysqld</command> server) that hasn't yet closed the
-          file or that has died without closing the file properly.
-        </para>
-
-        <para>
-          If <command>mysqld</command> is running, you must force it to
-          flush any table modifications that are still buffered in
-          memory by using <literal>FLUSH TABLES</literal>. You should
-          then ensure that no one is using the tables while you are
-          running <command>myisamchk</command>. The easiest way to avoid
-          this problem is to use <literal>CHECK TABLE</literal> instead
-          of <command>myisamchk</command> to check tables.
-        </para>
-
       </refsection>
 
       <refsection id="myisamchk-general-options">


Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml	2007-03-24 23:31:01 UTC (rev 5551)
+++ trunk/refman-5.1/client-utility-programs.xml	2007-03-25 04:47:56 UTC (rev 5552)
Changed blocks: 1, Lines Added: 37, Lines Deleted: 25; 3299 bytes

@@ -1313,35 +1313,47 @@
           <command>myisamchk</command>, see
           <xref linkend="myisamchk-memory"/>.
         </para>
-
-        <para>
-          You must ensure that no other program is using the tables
-          while you are running <command>myisamchk</command>. Otherwise,
-          when you run <command>myisamchk</command>, it may display the
-          following error message:
-        </para>
-
+        
+        <important>
+          <para>
+            <emphasis>You must ensure that no other program is using the
+            tables while you are running
+            <command>myisamchk</command></emphasis>. Otherwise, when you
+            run <command>myisamchk</command>, it may display the
+            following error message: 
+          </para>
+          
 <programlisting>
 warning: clients are using or haven't closed the table properly
 </programlisting>
+          
+          <para>
+            This means that you are trying to check a table that has been
+            updated by another program (such as the
+            <command>mysqld</command> server) that hasn't yet closed the
+            file or that has died without closing the file properly,
+            which can sometimes lead to the corruption of one or more
+            <literal>MyISAM</literal> tables.
+          </para>
+          
+          <para>
+            If <command>mysqld</command> is running, you must force it
+            to flush any table modifications that are still buffered in
+            memory by using <literal>FLUSH TABLES</literal>. You should
+            then ensure that no one is using the tables while you are
+            running <command>myisamchk</command>, the most effective
+            means of doing so being to shut down the MySQL server while
+            running <literal>myisamchk</literal>. 
+          </para>
+          
+          <para>
+            However, the easiest way to avoid this problem is to use
+            <literal>CHECK TABLE</literal> instead of
+            <command>myisamchk</command> to check tables. See 
+            <xref linkend="check-table"/>.            
+          </para>
+        </important>
 
-        <para>
-          This means that you are trying to check a table that has been
-          updated by another program (such as the
-          <command>mysqld</command> server) that hasn't yet closed the
-          file or that has died without closing the file properly.
-        </para>
-
-        <para>
-          If <command>mysqld</command> is running, you must force it to
-          flush any table modifications that are still buffered in
-          memory by using <literal>FLUSH TABLES</literal>. You should
-          then ensure that no one is using the tables while you are
-          running <command>myisamchk</command>. The easiest way to avoid
-          this problem is to use <literal>CHECK TABLE</literal> instead
-          of <command>myisamchk</command> to check tables.
-        </para>
-
       </refsection>
 
       <refsection id="myisamchk-general-options">


Thread
svn commit - mysqldoc@docsrva: r5552 - in trunk: refman-4.1 refman-5.0 refman-5.1jon25 Mar