Confusion of MySQL XA status.

[Haihao Tang]

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