1. Introduction In large-scale Internet applications, as the amount of data continues to grow, the single-database, single-table architecture cannot meet the needs of high concurrency and large data storage. Sub-database and sub-table is a common database architecture optimization solution, which can improve database throughput, reduce the amount of data in a single table, and improve query efficiency. However, sub-database and sub-table also bring many complex problems, such as primary key generation, paging query, distributed transaction, cross-table query, high availability, etc. This article will explain in detail the core concepts, key technologies and implementation methods of sub-database and sub-table…

1. MVCC Architecture Design and Implementation Principles 1.1 Storage Engine Layer Architecture InnoDB uses a layered storage architecture to implement the MVCC mechanism: Memory structure: Buffer Pool: Data page cache pool (default 128MB) Undo Log Buffer: Transaction rollback log cache (default 16MB) Change Buffer: Non-unique index update buffer Disk structure: Clustered index B+ tree (primary key index) Secondary index B+ tree Undo...