InnoDB Empty Transactions

Hi,

InnoDB showing empty transactions.

Are they any how related to sleep connections?


TRANSACTIONS

Trx id counter 8BE5FD59
Purge done for trx’s n:o < 8BE5FC9A undo n:o < 0
History list length 1963
LIST OF TRANSACTIONS FOR EACH SESSION:
—TRANSACTION 0, not started
MySQL thread id 13193589, OS thread handle 0x494e1940, query id 280671343 x.x.x.x appuser
—TRANSACTION 8BE5FD51, not started
MySQL thread id 13193588, OS thread handle 0x49257940, query id 280671344 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193587, OS thread handle 0x48f4b940, query id 280671335 x.x.x.x appuser
—TRANSACTION 8BE5FD58, not started
MySQL thread id 13193586, OS thread handle 0x484e2940, query id 280671349 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193582, OS thread handle 0x4876c940, query id 280671292 x.x.x.x appuser
—TRANSACTION 8BE5FD3F, not started
MySQL thread id 13193581, OS thread handle 0x48627940, query id 280671332 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193576, OS thread handle 0x4935b940, query id 280671075 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193574, OS thread handle 0x48d02940, query id 280671057 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193573, OS thread handle 0x49298940, query id 280671053 x.x.x.x appuser
—TRANSACTION 8BE5FD12, not started
MySQL thread id 13193572, OS thread handle 0x49112940, query id 280671035 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193571, OS thread handle 0x495e5940, query id 280671008 x.x.x.x appuser
—TRANSACTION 0, not started
MySQL thread id 13193565, OS thread handle 0x48523940, query id 280670838 x.x.x.x appuser
—TRANSACTION 8BE5FCD7, not started
MySQL thread id 13193557, OS thread handle 0x4941e940, query id 280671163 x.x.x.x appuser
—TRANSACTION 8BE5FCB5, not started
MySQL thread id 13193550, OS thread handle 0x49090940, query id 280670996 x.x.x.x appuser
—TRANSACTION 8BE5FCA9, not started
MySQL thread id 13193548, OS thread handle 0x4835c940, query id 280670874 x.x.x.x appuser
—TRANSACTION 8BE5FCEB, not started
MySQL thread id 13193545, OS thread handle 0x4982e940, query id 280670772 x.x.x.x appuser
—TRANSACTION 8BE5FCA5, not started
MySQL thread id 13193543, OS thread handle 0x48bfe940, query id 280670810 x.x.x.x appuser
—TRANSACTION 8BE5FCA0, not started
MySQL thread id 13193542, OS thread handle 0x48afa940, query id 280670860 x.x.x.x appuser

Those transactions are in “not started” status, that means that they have no run any query. You can use the “MySQL thread id” to find the thread on the show processlist output.

In order to get one of these “empty” transactions just do the following:

mysql> START TRANSACTION;

that’s all, show engine innodb status will show this new transaction as “not started” and show processlist as “SLEEP”.

Regards.