List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:October 13 2010 3:18pm
Subject:Re: Confusion of MySQL XA status.
View as plain text  
Hi, Haihao!

On Oct 11, Haihao Tang wrote:
> 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?

I don't understand the question. What resources do you mean here?

> 2) Why there is the status IDLE? Why not ACTIVE change to PREPARE
> after invoking 'XA PREPARED' and ignore IDLE.

Because MySQL follows the standard. Download the DTP-XA standard
from the X/Open site and see the state transition tables there.
 
Regards,
Sergei
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