MySQL Lists: commits: svn commit - mysqldoc@docsrva: r17506 - in trunk: . refman-5.1 refman-5.4 refman-5.5

List:	Commits	« Previous Message Next Message »
From:	paul.dubois	Date:	November 6 2009 6:05pm
Subject:	svn commit - mysqldoc@docsrva: r17506 - in trunk: . refman-5.1 refman-5.4 refman-5.5
View as plain text
Author: paul
Date: 2009-11-06 18:05:15 +0100 (Fri, 06 Nov 2009)
New Revision: 17506

Log:
 r27680@arctic:  paul | 2009-11-06 11:03:38 -0600
 Updates to SHOW ENGINE INNODB STATUS output


Modified:
   trunk/refman-5.1/se-innodb-core.xml
   trunk/refman-5.4/introduction.xml
   trunk/refman-5.4/se-innodb-core.xml
   trunk/refman-5.5/se-innodb-core.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:27523
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46199
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
   + 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:27680
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46199
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546


Modified: trunk/refman-5.1/se-innodb-core.xml
===================================================================
--- trunk/refman-5.1/se-innodb-core.xml	2009-11-06 16:53:24 UTC (rev 17505)
+++ trunk/refman-5.1/se-innodb-core.xml	2009-11-06 17:05:15 UTC (rev 17506)
Changed blocks: 4, Lines Added: 21, Lines Deleted: 1; 1902 bytes

@@ -9193,6 +9193,12 @@
 =====================================
 Per second averages calculated from the last 18 seconds
 ----------
+BACKGROUND THREAD
+----------
+srv_master_thread loops: 53 1_second, 44 sleeps, 5 10_second, 7 background,
+  7 flush
+srv_master_thread log flush and writes: 48
+----------
 SEMAPHORES
 ----------
 OS WAIT ARRAY INFO: reservation count 413452, signal count 378357

@@ -9205,6 +9211,7 @@
 Mutex spin waits 0, rounds 0, OS waits 0
 RW-shared spins 108462, OS waits 37964; RW-excl spins 681824, OS waits
 375485
+Spin rounds per wait: 0.00 mutex, 20.00 RW-shared, 0.00 RW-excl
 ------------------------
 LATEST FOREIGN KEY ERROR
 ------------------------

@@ -9381,6 +9388,17 @@
         </para>
 
         <para>
+          <emphasis role="bold"><literal>BACKGROUND
+          THREAD</literal></emphasis>
+        </para>
+
+        <para>
+          The <literal>srv_master_thread</literal> lines shows work done
+          by the main background thread. This section is displayed only
+          by <literal>InnoDB Plugin</literal>.
+        </para>
+
+        <para>
           <emphasis
role="bold"><literal>SEMAPHORES</literal></emphasis>
         </para>
 

@@ -9394,7 +9412,9 @@
           problems in operating system thread scheduling. Setting the
           <literal role="sysvar">innodb_thread_concurrency</literal>
           system variable smaller than the default value might help in
-          such situations.
+          such situations. The <literal>Spin rounds per wait</literal>
+          line (<literal>InnoDB Plugin</literal> only) shows the number
+          of spinlock rounds per OS wait for a mutex.
         </para>
 
         <para>


Modified: trunk/refman-5.4/introduction.xml
===================================================================
--- trunk/refman-5.4/introduction.xml	2009-11-06 16:53:24 UTC (rev 17505)
+++ trunk/refman-5.4/introduction.xml	2009-11-06 17:05:15 UTC (rev 17506)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 102; 5078 bytes

@@ -820,58 +820,29 @@
         <para>
           The output from
           <literal role="stmt" condition="show-engine">SHOW ENGINE
-          INNODB STATUS</literal> includes more information. These
-          changes are based on patches developed by Google, about which
-          more information can be found here:
+          INNODB STATUS</literal> includes more information due to
+          changes made for <literal>InnoDB Plugin</literal>. A
+          description of revisions to statement output follows.
         </para>
 
-<programlisting>
-<ulink url="http://code.google.com/p/google-mysql-tools/wiki/InnodbStatus"/>
-<ulink url="http://code.google.com/p/google-mysql-tools/wiki/NewShowInnodbStatus"/>
-</programlisting>
-
         <para>
-          A description of revisions to statement output follows.
+          A new <literal>BACKGROUND THREAD</literal> section has
+          <literal>srv_master_thread</literal> lines that show work done
+          by the main background thread.
         </para>
 
-        <para>
-          Output includes a <literal>BACKGROUND THREAD</literal>
-          section:
-        </para>
-
 <programlisting>
 ----------
 BACKGROUND THREAD
 ----------
-srv_master_thread loops: 12 1_second, 12 sleeps, 0 10_second, 2 background,
-  2 flush
-srv_master_thread log flush: 12 sync, 15 async
-srv_wait_thread_mics 0 microseconds, 0.0 seconds
-spinlock delay for 6 delay 20 rounds is 15 mics
+srv_master_thread loops: 53 1_second, 44 sleeps, 5 10_second, 7 background,
+  7 flush
+srv_master_thread log flush and writes: 48
 </programlisting>
 
         <para>
-          The <literal>srv_master_thread</literal> lines shows work done
-          by the main background thread.
-        </para>
-
-        <para>
-          The <literal>srv_wait_thread_mics</literal> line indicates how
-          many microseconds threads wait to use
-          <literal>InnoDB</literal> due to
-          <literal role="sysvar">innodb_thread_concurrency</literal>
-          limits.
-        </para>
-
-        <para>
-          The <literal>spinlock</literal> line shows the number of
-          microseconds the spinloop spins before sleeping (the time
-          spent busy-waiting).
-        </para>
-
-        <para>
           The <literal>SEMAPHORES</literal> section includes a line to
-          show the number of spinlock rounds per OS wait for a mutex:
+          show the number of spinlock rounds per OS wait for a mutex.
         </para>
 
 <programlisting>

@@ -883,69 +854,6 @@
 </programlisting>
 
         <para>
-          Lines in the <literal>FILE I/O</literal> section that show
-          information for individual I/O threads display additional
-          information to indicate the number of pages read and written,
-          the number of system calls for those operations, and the time
-          in milliseconds to complete them (total and average per
-          request).
-        </para>
-
-<programlisting>
---------
-FILE I/O
---------
-I/O thread 0 state: waiting for i/o request (insert buffer thread)
-  reads 0 writes 0 requests 0 io secs 0.000000 io msecs/request 0.000000
-  max_io_wait 0.000000
-I/O thread 1 state: waiting for i/o request (log thread)
-  reads 0 writes 3 requests 3 io secs 0.006906 io msecs/request 2.302000
-  max_io_wait 6.861000
-I/O thread 2 state: waiting for i/o request (read thread)
-  reads 33 writes 0 requests 2 io secs 0.005925 io msecs/request 2.962500
-  max_io_wait 5.895000
-...
-Summary of background IO slot status: 0 issued, 0 done, 0 claimed, sleep set 0
-</programlisting>
-
-        <para>
-          The <literal>Summary of background IO slot status</literal>
-          line describes the state of pending IO requests.
-          <literal>InnoDB</literal> provides real or simulated
-          asynchronous I/O to perform disk I/O for many uses. Requests
-          are put into request arrays with a fixed number of slots per
-          array. Other threads read the requests, remove them from the
-          array and perform the I/O. The counts indicate the number of
-          requests in the following states:
-        </para>
-
-        <itemizedlist>
-
-          <listitem>
-            <para>
-              <literal>issued</literal>: The request is in the array and
-              the I/O operation is in progress.
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <literal>done</literal>: The I/O operation has completed,
-              but the thread that requested the operation has not been
-              notified.
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              <literal>claimed</literal>: The I/O operation has yet to
-              be started.
-            </para>
-          </listitem>
-
-        </itemizedlist>
-
-        <para>
           <emphasis role="bold">New Status Variable</emphasis>
         </para>
 


Modified: trunk/refman-5.4/se-innodb-core.xml
===================================================================
--- trunk/refman-5.4/se-innodb-core.xml	2009-11-06 16:53:24 UTC (rev 17505)
+++ trunk/refman-5.4/se-innodb-core.xml	2009-11-06 17:05:15 UTC (rev 17506)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 1; 1784 bytes

@@ -8892,6 +8892,12 @@
 =====================================
 Per second averages calculated from the last 18 seconds
 ----------
+BACKGROUND THREAD
+----------
+srv_master_thread loops: 53 1_second, 44 sleeps, 5 10_second, 7 background,
+  7 flush
+srv_master_thread log flush and writes: 48
+----------
 SEMAPHORES
 ----------
 OS WAIT ARRAY INFO: reservation count 413452, signal count 378357

@@ -8904,6 +8910,7 @@
 Mutex spin waits 0, rounds 0, OS waits 0
 RW-shared spins 108462, OS waits 37964; RW-excl spins 681824, OS waits
 375485
+Spin rounds per wait: 0.00 mutex, 20.00 RW-shared, 0.00 RW-excl
 ------------------------
 LATEST FOREIGN KEY ERROR
 ------------------------

@@ -9080,6 +9087,16 @@
         </para>
 
         <para>
+          <emphasis role="bold"><literal>BACKGROUND
+          THREAD</literal></emphasis>
+        </para>
+
+        <para>
+          The <literal>srv_master_thread</literal> lines shows work done
+          by the main background thread.
+        </para>
+
+        <para>
           <emphasis
role="bold"><literal>SEMAPHORES</literal></emphasis>
         </para>
 

@@ -9093,7 +9110,9 @@
           problems in operating system thread scheduling. Setting the
           <literal role="sysvar">innodb_thread_concurrency</literal>
           system variable smaller than the default value might help in
-          such situations.
+          such situations. The <literal>Spin rounds per wait</literal>
+          line shows the number of spinlock rounds per OS wait for a
+          mutex.
         </para>
 
         <para>


Modified: trunk/refman-5.5/se-innodb-core.xml
===================================================================
--- trunk/refman-5.5/se-innodb-core.xml	2009-11-06 16:53:24 UTC (rev 17505)
+++ trunk/refman-5.5/se-innodb-core.xml	2009-11-06 17:05:15 UTC (rev 17506)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 1; 1784 bytes

@@ -8863,6 +8863,12 @@
 =====================================
 Per second averages calculated from the last 18 seconds
 ----------
+BACKGROUND THREAD
+----------
+srv_master_thread loops: 53 1_second, 44 sleeps, 5 10_second, 7 background,
+  7 flush
+srv_master_thread log flush and writes: 48
+----------
 SEMAPHORES
 ----------
 OS WAIT ARRAY INFO: reservation count 413452, signal count 378357

@@ -8875,6 +8881,7 @@
 Mutex spin waits 0, rounds 0, OS waits 0
 RW-shared spins 108462, OS waits 37964; RW-excl spins 681824, OS waits
 375485
+Spin rounds per wait: 0.00 mutex, 20.00 RW-shared, 0.00 RW-excl
 ------------------------
 LATEST FOREIGN KEY ERROR
 ------------------------

@@ -9051,6 +9058,16 @@
         </para>
 
         <para>
+          <emphasis role="bold"><literal>BACKGROUND
+          THREAD</literal></emphasis>
+        </para>
+
+        <para>
+          The <literal>srv_master_thread</literal> lines shows work done
+          by the main background thread.
+        </para>
+
+        <para>
           <emphasis
role="bold"><literal>SEMAPHORES</literal></emphasis>
         </para>
 

@@ -9064,7 +9081,9 @@
           problems in operating system thread scheduling. Setting the
           <literal role="sysvar">innodb_thread_concurrency</literal>
           system variable smaller than the default value might help in
-          such situations.
+          such situations. The <literal>Spin rounds per wait</literal>
+          line shows the number of spinlock rounds per OS wait for a
+          mutex.
         </para>
 
         <para>
Thread
• svn commit - mysqldoc@docsrva: r17506 - in trunk: . refman-5.1 refman-5.4 refman-5.5	paul.dubois	6 Nov 2009