A collection of 24 FAQs on MySQL transaction management. Clear answers are provided with tutorial exercises on starting and ending transactions; committing and rolling back transactions; transaction isolation levels: read committed and repeatable read; locks and dead locks. Topics included in this FAQ are:
- What Is a Transaction?
- How To Start a New Transaction?
- How To End the Current Transaction?
- How To Create a Table for Transaction Testing?
- How To Switch between Autocommit-On and Autocommit-Off Modes?
- How To Find Out the Current Transaction Mode?
- How To Start a New Transaction Explicitly?
- How To Commit the Current Transaction?
- How To Rollback the Current Transaction?
- What Happens to the Current Transaction If a START TRANSACTION Is Executed?
- What Happens to the Current Transaction If a DDL Statement Is Executed?
- What Happens to the Current Transaction If the Session Is Ended?
- What Happens to the Current Transaction If the Session Is Killed?
- How Does MySQL Handle Read Consistency?
- What Are Transaction Isolation Levels?
- How To View and Change the Current Transaction Isolation Level?
- What Is a Data Lock?
- How To Experiment Data Locks?
- How Long a Transaction Will Wait for a Data Lock?
- What Happens to Your Transactions When ERROR 1205 Occurred?
- What Is a Dead Lock?
- How To Experiment Dead Locks?
- What Happens to Your Transactions When ERROR 1213 Occurred?
- What Are the Impacts on Applications from Locks, Timeouts, and DeadLocks?
Please note that all answers and tutorials are based on MySQL 5.0 with transaction-safe storage engines, like InnoDB. Sometimes you may need to run previous tutorials in order to continue a later tutorial.
Full article @ fyicenter.com
0 Comments:
Post a Comment