More than 5 years have passed since last update.

MySQL 5.6 -- トランザクションID、取得、SQL

mysql5.6

Posted at 2017-12-20

以下のSQLで、確認できます。

    SELECT
      CONCAT('Call function CONNECTION_ID:', CONNECTION_ID(),
        ' Trx_IDs:', GROUP_CONCAT(trx_id SEPARATOR ','),
        ' thread_IDs:', GROUP_CONCAT(trx_mysql_thread_id SEPARATOR ',')
      ) AS infos
    FROM information_schema.INNODB_TRX
    ORDER BY trx_id

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up