search

dushaoshuai / dushaoshuai.github.io

https://www.shuai.host
0 stars 0 forks source link

MySQL: InnoDB #95

Closed dushaoshuai closed 1 year ago

dushaoshuai commented 1 year ago 
mindmap
    InnoDB
        ACID
            Atomicity
                autocommit
                START TRANSACTION
                    WITH CONSISTENT SNAPSHOT
                    READ WRITE
                    READ ONLY
                COMMIT
                ROLLBACK
            Consistency
                InnoDB doublewrite buffer
                    innodb_doublewrite
                    innodb_doublewrite_files
                        flush list doublewrite file
                        LRU list doublewrite file
                InnoDB crash recovery
                    todo
            Isolation
                Transaction Isolation Levels
                    READ UNCOMMITTED
                    READ COMMITTED
                    REPEATABLE READ
                    SERIALIZABLE
                SET TRANSACTION
                    GLOBAL | SESSION
                    ISOLATION LEVEL
                    READ WRITE | READ ONLY
            InnoDB Locking
                Shared and Exclusive Locks
                    S
                    X
                Intention Locks
                    IS
                    IX
                Record Locks
                Gap Locks
                Next Key Locks
                Insert Intention Locks
                AUTO INC Locks
                Predicate Locks for Spatial Indexes
            Durability
        Transaction
            Consistent Nonlocking Reads
                consistent read
                    REPEATABLE READ
                    READ COMMITTED
                    exception and anomaly
                multi versioned concurrency control
            Locking Reads
                SELECT ... FOR SHARE
                SELECT ... FOR UPDATE
                NOWAIT
                SKIP LOCKED
                autocommit
        In Memory
            buffer pool
                LRU
                Buffer Pool Configuration
                    size
                    multiple instances
                    keep frequently accessed data in memory
                    read ahead
                    flushing
                    save and restore
              Monitoring
        InnoDB Backup and Recovery
            InnoDB Backup
                physical backups
                    Hot Backups
                    Cold Backups
                logical backups
                    mysqldump
                Replication
            InnoDB Recovery
                todo

参见

链接 该链接涉及
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_autocommit autocommit
https://dev.mysql.com/doc/refman/8.0/en/mysql-acid.html Atomicity, Consistency, Isolation, Durability, transaction, autocommit, commit, rollback, InnoDB doublewrite buffer, InnoDB crash recovery
https://dev.mysql.com/doc/refman/8.0/en/commit.html START TRANSACTION, COMMIT, ROLLBACK, autocommit, InnoDB, REPEATABLE READ, TEMPORARY, table locks, LOCK TABLES, UNLOCK TABLES, The Binary Log
https://dev.mysql.com/doc/refman/8.0/en/innodb-doublewrite-buffer.html Doublewrite Buffer, flush, buffer pool, crash recovery, fsync(), innodb_flush_method, innodb_doublewrite, innodb_doublewrite_files, flush list doublewrite file, LRU list doublewrite file
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html buffer pool, LRU
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html physical backups, hot backups, cold backups, logical backs, mysqldump, replication
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html Shared and Exclusive Locks, row-level locking, shared (S) locks, exclusive (X) locks, transaction
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html consistent read, multi-versioning, snapshot, transactions, anomaly, REPEATABLE READ, SELECT, locks, INSERT, UPDATE, DELETE, commit, START TRANSACTION WITH CONSISTENT SNAPSHOT, multi-versioned concurrency control, locking read, INSERT INTO ... SELECT, UPDATE ... SELECT, and CREATE TABLE ... SELECT
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html transaction, SELECT, locking reads, SELECT ... FOR SHARE, shared mode lock, commit, NOWAIT, SKIP LOCKED, SELECT ... FOR Update, UPDATE, Consistent reads, undo logs, tree-structured, graph-structured, autocommit, START TRANSACTION, LAST_INSERT_ID(), replication