可以使用 onstat -x 命令显示在数据库服务器上的事务信息。
图: onstat -x 命令输出
Transactions address flags userthread locks begin current isol est. retrys coord logpos logpos rb_time a6d8028 A---- a695028 0 - - COMMIT - 0 a6d8348 A---- a695878 0 - - COMMIT - 0 a6d8668 A---- a6960c8 0 - - COMMIT - 0 a6d8988 A---- a696918 0 - - COMMIT - 0 a6d8fc8 A---- a698208 0 - - COMMIT - 0 a6d92e8 A---- a6979b8 0 - - COMMIT - 0 a6d9608 A---- a698a58 0 - - COMMIT - 0 a6d9928 A---- a6992a8 1 - - DIRTY - 0 a6d9c48 A---- a6992a8 0 - - NOTRANS - 0 a6d9f68 A---- a69a348 0 - - COMMIT - 0 a6da288 A---- a69ab98 0 - - COMMIT - 0 a6da5a8 A---- a69b3e8 0 - - COMMIT - 0 a6da8c8 A---- a69bc38 0 - - COMMIT - 0 a6dabe8 A---- a69c488 0 - - COMMIT - 0 a6daf08 A---- a699af8 0 - - COMMIT - 0 a6db228 A---- a6992a8 0 - - COMMIT - 0 a6db548 A---- a69ccd8 1 - - DIRTY - 0 a6db868 A---- a69d528 1 - - DIRTY - 0 a6dbb88 A---- a69ccd8 0 - - COMMIT - 0 a6dbea8 A---- a69dd78 0 - - COMMIT - 0 a6dc1c8 A---- a69e5c8 0 - - COMMIT - 0 a6dc4e8 A-B-- a69ee18 502 33:0x25018 34:0x486fc COMMIT 0:07 0 22 active, 128 total, 23 maximum concurrent
该字段告诉您哪个数据库服务器正在协调两阶段提交
8 active, 128 total, 8 maximum concurrent