List:Internals« Previous MessageNext Message »
From:Haihao Tang Date:October 11 2010 2:39am
Subject:Confusion of MySQL XA status.
View as plain text  
Hi, all
    In MySQL XA, the transaction has four status, like:
NON-EXISTING ---(XA START)---> ACTIVE ---(XA END)---> IDLE ---(XA
PREPARED)---> PREPARE ---(XA COMMIT / XA ROLLBACK)---> NON_EXISTING

1) In those difference status, how does InnoDB occupy the resources? I
mean, in status IDLE and PREPARE, does InnoDB occupies difference
resources?
2) Why there is the status IDLE? Why not ACTIVE change to PREPARE
after invoking 'XA PREPARED' and ignore IDLE.

Thanks~
Best Regards,

                 Haihao

                2010-10-11
Thread
Confusion of MySQL XA status.Haihao Tang11 Oct
  • Re: Confusion of MySQL XA status.Sergei Golubchik13 Oct
    • Re: Confusion of MySQL XA status.Haihao Tang14 Oct
      • Re: Confusion of MySQL XA status.Sergei Golubchik15 Oct