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.1 | john.russell | 24 Nov |
