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 |
