{"height":"190","provider_name":"Hatena Blog","categories":["DB"],"author_url":"https://blog.hatena.ne.jp/HTN20190109/","author_name":"HTN20190109","blog_url":"https://htn20190109.hatenablog.com/","title":"\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3ID","image_url":null,"description":"MySQL (5.6)https://dev.mysql.com/doc/refman/5.6/ja/innodb-trx-table.html SELECT CONNECTION_ID(); --\u5b9f\u884c\u4e2d\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u78ba\u8a8dSELECT * FROM INFORMATION_SCHEMA.INNODB_TRX \\G SQL\u6587\u306f\u4e00\u822c\u30af\u30a8\u30ea\u30ed\u30b0\u3084\u30b9\u30ed\u30fc\u30af\u30a8\u30ea\u30ed\u30b0\u304b\u3089\u78ba\u8a8d (8.0.18)-- \u30b3\u30cd\u30af\u30b7\u30e7\u30f3ID\u3068\u30b9\u30ec\u30c3\u30c9ID\u306e\u53d6\u5f97select connection_id(),ps_thread_id(connection_id()),ps_current_thread_id()\\G select *\u2026","width":"100%","url":"https://htn20190109.hatenablog.com/entry/2020/03/29/184042","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2020%2F03%2F29%2F184042\" title=\"\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3ID - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2020-03-29 18:40:42","provider_url":"https://hatena.blog","type":"rich","version":"1.0","blog_title":"HTN20190109\u306e\u65e5\u8a18"}