Databases
StackOverflow2013
Postsdbo
POWhat is meant by Transaction not started in SHOW ENGINE INNODB STATUS?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is meant by Transaction not started in SHOW ENGINE INNODB STATUS?
    text
    copied!<p>Here are the few lines of response of 'SHOW ENGINE INNODB STATUS;' </p> <hr> <pre><code>TRANSACTIONS ------------ Trx id counter 58EC54C6 Purge done for trx's n:o &lt; 58EC54C3 undo n:o &lt; 0 History list length 2420 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 58EC51E6, not started MySQL thread id 520131, OS thread handle 0x7f0db930e700, query id 24011015 108.89.56.87 xyz ---TRANSACTION 58EC527E, not started MySQL thread id 520061, OS thread handle 0x7f0dbb596700, query id 24011370 108.89.56.87 xyz ---TRANSACTION 58EC53AC, not started MySQL thread id 520065, OS thread handle 0x7f0dbb28a700, query id 24012094 108.89.56.87 xyz ---TRANSACTION 58EC50CE, not started MySQL thread id 520109, OS thread handle 0x7f0dbba69700, query id 24010431 108.89.56.87 xyz ---TRANSACTION 58EC51E8, not started MySQL thread id 520123, OS thread handle 0x7f0dbb4d3700, query id 24011016 108.89.56.87 xyz ---TRANSACTION 58EC51D0, not started MySQL thread id 520072, OS thread handle 0x7f0db865c700, query id 24010944 108.89.56.87 xyz ---TRANSACTION 58EC5184, not started MySQL thread id 520058, OS thread handle 0x7f0db8c74700, query id 24010807 108.89.56.87 xyz </code></pre> <p>I want to know what this 'Transaction transId, not started' means? Does any query failed to execute?</p> <p>I am using innodb. also I am not manually starting transaction. It is considering automatically transaction because I am issuing update query on a table having bulk data. and ya there are getting hundreads of mysql update query on this single table in 5-10 mins.</p> <p>Please let me know what exactly 'Transaction not started' means? Is it showing failed query or just a normal log?</p> <p>Thanks in Advance!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload