mysql的XA事务恢复过程详解
2019-09-01
编程之家收集整理的这篇文章主要介绍了mysql的XA事务恢复过程详解,编程之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
MysqL/bin/MysqLd: ready for connections.
Version: '5.1.39' socket: '/tmp/MysqL.sock' port: 3306 MysqL Community Server (GPL)
意味着有三个XA的事务没有提交或回滚。
MysqL> xa recover;
+----------+--------------+--------------+------------------------------------------------------------+
| formatID | gtrid_length | bqual_length | data |
+----------+--------------+--------------+------------------------------------------------------------+
| 131075 | 30 | 28 | 1-7f000001:bae5:4b6928eb:f06397f000001:bae5:4b6928eb:f0650 |
| 131075 | 30 | 28 | 1-7f000001:bae5:4b6928eb:fb5c37f000001:bae5:4b6928eb:fb5cd |
| 131075 | 30 | 28 | 1-7f000001:bae5:4b6928eb:f03ea7f000001:bae5:4b6928eb:f0400 |
+-