Re: autcommit vs. manual commit behavior

[Aaron Couts]

You are exactly right:

Scenario 3:
Session 1: Autocommit == 0. I make a change to a record and commit manually.
Session 2: Autocommit == 0. I can't see the change in the record unless I quit and log back into mysql.

Scenario 4:
Session 1: Autocommit == 0. I make a change to a record and commit manually.
Session 2: Autocommit == 1. I can see the change immediately.

Scenario 5:
Session 1: Autocommit == 0. I make a change to a record and commit manually.
Session 2: Autocommit == 0. I type commit; and can see the change.

Thanks very much for the detailed explanation.

-Aaron