autcommit vs. manual commit behavior
Hello,
I've noticed some behavior that indicates a difference between autocommit and manual commit. I'm working on mysql v4.0.21 and v4.1.18, on Redhat Enterprise Linux v3.0, using InnoDB tables.
If I have two mysql sessions open, here's what happens:
Scenario 1:
Session 1: Autocommit == 0. I make a change to a record and commit manually.
Session 2: I can't see the change in the record unless I quit and log back into mysql.
Scenario 2:
Session 1: Autocommit == 1. I make a change to a record.
Session 2: I can see the change immediately.
I see the same behavior when session 1 is a perl script rather than a mysql session.
Is this a known issue? Is there a workaround in v4, or does v5 resolve this? I have been searching for this issue but have not been able to find it online or in the mysql documentation.
Thanks,
Aaron
Subject
Written By
Posted
autcommit vs. manual commit behavior
May 19, 2006 02:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.