MySQL Database

  1. Transactions and Concurrency
    1. Transaction Fundamentals
      1. Transaction Definition
        1. Logical Unit of Work
          1. All-or-Nothing Principle
            1. Data Consistency Guarantee
            2. ACID Properties
              1. Atomicity
                1. Transaction Completeness
                  1. Rollback Capabilities
                    1. Partial Execution Prevention
                    2. Consistency
                      1. Data Integrity Maintenance
                        1. Constraint Enforcement
                          1. Valid State Transitions
                          2. Isolation
                            1. Concurrent Transaction Separation
                              1. Interference Prevention
                                1. Visibility Control
                                2. Durability
                                  1. Permanent Change Guarantee
                                    1. Crash Recovery
                                      1. Data Persistence
                                  2. Transaction Control
                                    1. Transaction Control Language (TCL)
                                      1. Transaction Management Commands
                                        1. State Transition Control
                                          1. Error Handling
                                          2. Starting Transactions
                                            1. START TRANSACTION
                                              1. BEGIN Statement
                                                1. Autocommit Mode Control
                                                2. Committing Transactions
                                                  1. COMMIT Statement
                                                    1. Permanent Change Application
                                                      1. Transaction Completion
                                                      2. Rolling Back Transactions
                                                        1. ROLLBACK Statement
                                                          1. Change Reversal
                                                            1. Error Recovery
                                                            2. Savepoints
                                                              1. SAVEPOINT Creation
                                                                1. Partial Rollback
                                                                  1. Nested Transaction Simulation
                                                                    1. RELEASE SAVEPOINT
                                                                  2. Concurrency Control
                                                                    1. Concurrency Problems
                                                                      1. Dirty Reads
                                                                        1. Uncommitted Data Reading
                                                                          1. Transaction Interference
                                                                          2. Non-Repeatable Reads
                                                                            1. Inconsistent Read Results
                                                                              1. Data Modification Between Reads
                                                                              2. Phantom Reads
                                                                                1. Row Set Changes
                                                                                  1. Range Query Inconsistencies
                                                                                  2. Lost Updates
                                                                                    1. Concurrent Modification Conflicts
                                                                                      1. Update Overwriting
                                                                                    2. Isolation Levels
                                                                                      1. READ UNCOMMITTED
                                                                                        1. Lowest Isolation Level
                                                                                          1. All Concurrency Problems Possible
                                                                                            1. Maximum Performance
                                                                                            2. READ COMMITTED
                                                                                              1. Committed Data Only
                                                                                                1. Dirty Read Prevention
                                                                                                  1. Default for Many Systems
                                                                                                  2. REPEATABLE READ
                                                                                                    1. Consistent Read Results
                                                                                                      1. MySQL Default Level
                                                                                                        1. Phantom Read Possibility
                                                                                                        2. SERIALIZABLE
                                                                                                          1. Highest Isolation Level
                                                                                                            1. Complete Transaction Isolation
                                                                                                              1. Performance Impact
                                                                                                            2. Locking Mechanisms
                                                                                                              1. Lock Types
                                                                                                                1. Shared Locks (S-Locks)
                                                                                                                  1. Exclusive Locks (X-Locks)
                                                                                                                    1. Intent Locks
                                                                                                                    2. Lock Granularity
                                                                                                                      1. Table-Level Locking
                                                                                                                        1. Row-Level Locking
                                                                                                                          1. Page-Level Locking
                                                                                                                          2. Lock Duration
                                                                                                                            1. Transaction-Duration Locks
                                                                                                                              1. Statement-Duration Locks
                                                                                                                                1. Manual Lock Control
                                                                                                                              2. Deadlock Management
                                                                                                                                1. Deadlock Detection
                                                                                                                                  1. Cycle Detection Algorithms
                                                                                                                                    1. Automatic Detection
                                                                                                                                    2. Deadlock Resolution
                                                                                                                                      1. Victim Selection
                                                                                                                                        1. Transaction Rollback
                                                                                                                                          1. Retry Mechanisms
                                                                                                                                          2. Deadlock Prevention
                                                                                                                                            1. Lock Ordering
                                                                                                                                              1. Timeout Mechanisms
                                                                                                                                                1. Application Design

                                                                                                                                          Previous

                                                                                                                                          10. Indexing for Performance

                                                                                                                                          Go to top

                                                                                                                                          Next

                                                                                                                                          12. Stored Routines and Triggers