Tag: MySQL
Transactions and Locking
Under concurrency, transactions and locks together guarantee data consistency. InnoDB balances performance and isolation through the coordination of MVCC and locking. ACID and Isolation Levels A transaction’s ACID is guaranteed by different …
Under concurrency, transactions and locks together guarantee data consistency. InnoDB balances performance and isolation through the coordination of MVCC and locking. ACID and Isolation Levels A transaction’s ACID is guaranteed by different …
MySQL Indexing Internals and Best Practices
Indexes are the decisive factor for MySQL query performance. Understanding InnoDB’s B+Tree index structure is the only way to write SQL that truly hits indexes. B+Tree and the Clustered Index InnoDB organizes indexes with a B+Tree whose non-leaf …
Indexes are the decisive factor for MySQL query performance. Understanding InnoDB’s B+Tree index structure is the only way to write SQL that truly hits indexes. B+Tree and the Clustered Index InnoDB organizes indexes with a B+Tree whose non-leaf …