09月22日, 2014 138次
mysql CREATETABLEt1(fld1INT);
QueryOK, 0 rowsaffected (0.01 sec)
mysql COMMIT;
QueryOK, 0 rowsaffected (0.00 sec)
mysql XA test
QueryOK, 0 rowsaffected (0.00 sec)
mysql INSERTINTOt1VALUES (1);
QueryOK, 1 rowaffected (0.00 sec)
mysql XAEND test
QueryOK, 0 rowsaffected (0.00 sec)
mysql XA test
QueryOK, 0 rowsaffected (0.00 sec)
Nowkilltheserver.
mysql XARECOVER;
2006 (HY000): MySQLserverhasgoneaway
Noconnection. Tryingto reconnect
Connectionid: 1
Currentdatabase: test
+ -+ + + +
| formatID | gtrid_length | bqual_length | data |
+ -+ + + +
| 1 | 4 | 0 | test |
+ -+ + + +
1 rowin set (0.02 sec)
mysql XA test
QueryOK, 0 rowsaffected (0.02 sec)
mysql SHOWBINLOGevents\G;
*************************** 3. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000001
Pos: 154
Event_type: Anonymous_Gtid
Server_id: 0
End_log_pos: 219
Info: @@SESSION.GTID_NEXT= ANONYMOUS
*************************** 4. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000001
Pos: 219
Event_type: Query
Server_id: 0
End_log_pos: 319
Info: XA 74657374 , ,1
*************************** 5. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000001
Pos: 319
Event_type: Query
Server_id: 0
End_log_pos: 418
Info: use `test`; INSERTINTOt1VALUES (1)
*************************** 6. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000001
Pos: 418
Event_type: Query
Server_id: 0
End_log_pos: 509
Info: XAEND 74657374 , ,1
*************************** 7. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000001
Pos: 509
Event_type: XA_prepare
Server_id: 0
End_log_pos: 549
Info: XA 74657374 , ,1
*************************** 8. row ***************************
Log_name: nisha-PORTEGE-Z30-A-bin.000002
Pos: 219
Event_type: Server_id: 0
End_log_pos: 313
Info: XA 74657374 , ,1
8 rowsin set (0.00 sec)