List:Commits« Previous MessageNext Message »
From:john.russell Date:November 24 2010 6:05pm
Subject:svn commit - mysqldoc@docsrva: r23991 - trunk/innodb-plugin-1.1
View as plain text  
Author: jrussell
Date: 2010-11-24 19:05:56 +0100 (Wed, 24 Nov 2010)
New Revision: 23991

Log:
Incorporate some feedback on I_S columns from Vasil.


Modified:
   trunk/innodb-plugin-1.1/innodb-i-s-innodb-trx.xml


Modified: trunk/innodb-plugin-1.1/innodb-i-s-innodb-trx.xml
===================================================================
--- trunk/innodb-plugin-1.1/innodb-i-s-innodb-trx.xml	2010-11-24 17:50:39 UTC (rev 23990)
+++ trunk/innodb-plugin-1.1/innodb-i-s-innodb-trx.xml	2010-11-24 18:05:56 UTC (rev 23991)
Changed blocks: 5, Lines Added: 14, Lines Deleted: 13; 3491 bytes

@@ -33,13 +33,12 @@
       <row>
         <entry><literal>TRX_STATE</literal></entry>
         <entry>Transaction execution state. One of <literal>RUNNING</literal>,
-          <literal>LOCK WAIT</literal>, <literal>ROLLING_BACK</literal>
+          <literal>LOCK WAIT</literal>, <literal>ROLLING BACK</literal>
           or <literal>COMMITTING</literal>.</entry>
       </row>
       <row>
         <entry><literal>TRX_STARTED</literal></entry>
-        <entry>Transaction start time; the transaction is created by executing a
-          transactional query.</entry>
+        <entry>Transaction start time.</entry>
       </row>
       <row>
         <entry><literal>TRX_REQUESTED_LOCK_ID</literal></entry>

@@ -68,11 +67,12 @@
       </row>
       <row>
         <entry><literal>TRX_OPERATION_STATE</literal></entry>
-        <entry></entry>
+        <entry>The transaction's current operation, or <literal>NULL</literal>.</entry>
       </row>
       <row>
         <entry><literal>TRX_TABLES_IN_USE</literal></entry>
-        <entry>Number of InnoDB tables that are currently opened.</entry>
+        <entry>The number of InnoDB tables used while processing the current SQL
+          statement of this transaction.</entry>
       </row>
       <row>
         <entry><literal>TRX_TABLES_LOCKED</literal></entry>

@@ -83,21 +83,21 @@
       </row>
       <row>
         <entry><literal>TRX_LOCK_STRUCTS</literal></entry>
-        <entry>Number of locks currently held on InnoDB tables, across all
-          transactions. (A single lock structure can apply to many
-          rows.)</entry>
+        <entry>The number of locks reserved by the transaction.</entry>
       </row>
       <row>
         <entry><literal>TRX_LOCK_MEMORY_BYTES</literal></entry>
-        <entry>Total size taken up by the lock structures in memory.</entry>
+        <entry>Total size taken up by the lock structures of this transaction in
+          memory.</entry>
       </row>
       <row>
         <entry><literal>TRX_ROWS_LOCKED</literal></entry>
-        <entry>Total number of rows locked by all the lock structures.</entry>
+        <entry>Approximate number or rows locked by this transaction. Since
+          delete-marked rows may be removed, this number is not precise.</entry>
       </row>
       <row>
         <entry><literal>TRX_ROWS_MODIFIED</literal></entry>
-        <entry>Total number of rows modified by uncommitted transactions.</entry>
+        <entry>The number of modified and inserted rows in this transaction.</entry>
       </row>
       <row>
         <entry><literal>TRX_CONCURRENCY_TICKETS</literal></entry>

@@ -123,7 +123,7 @@
       </row>
       <row>
         <entry><literal>TRX_LAST_FOREIGN_KEY_ERROR</literal></entry>
-        <entry></entry>
+        <entry>Detailed error message for last FK error, or <literal>NULL</literal>.</entry>
       </row>
       <row>
         <entry><literal>TRX_APATIVE_HASH_LATCHED</literal></entry>

@@ -133,7 +133,8 @@
       </row>
       <row>
         <entry><literal>TRX_ADAPTIVE_HASH_TIMEOUT</literal></entry>
-        <entry></entry>
+        <entry>How many new searches on the adaptive hash to wait until we try to keep
+          the search latch again.</entry>
       </row>
     </tbody>
   </tgroup>


Thread
svn commit - mysqldoc@docsrva: r23991 - trunk/innodb-plugin-1.1john.russell24 Nov