Skip to main content

Architecture

Overview​

MySQL 8.4.5 features a pluggable storage engine architecture that shields applications from the underlying complexity by presenting a consistent and easy-to-use API that applies across storage engines. The architecture is designed for high performance, scalability, and reliability.

Core Architecture Components​

Server Layer Architecture​

  • Connection Layer: Handles client connections, authentication, and security

  • SQL Layer: Processes SQL statements, query optimization, and caching

  • Storage Engine Layer: Pluggable storage engines (InnoDB, MyISAM, Memory, etc.)

  • File System Layer: Physical storage and file management

InnoDB Storage Engine Architecture​

The InnoDB architecture includes both in-memory and on-disk structures that comprise the InnoDB storage engine:

In-Memory Structures:​

  • Buffer Pool - Caches table and index data

  • Change Buffer - Caches changes to secondary index pages

  • Adaptive Hash Index - Improves performance for frequently accessed pages

  • Log Buffer - Holds redo log data before writing to disk

On-Disk Structures:​

  • Tables - InnoDB tables with clustered indexes

  • Indexes - B-tree indexes for efficient data retrieval

  • Tablespaces - Containers for InnoDB data files

  • Redo Log - Transaction logs for crash recovery

  • Undo Log - Rollback information for transactions

MySQL 8.4 Enhanced Features:​

MySQL 8.4.0 adds support for automatic updates of histograms and enhanced data masking capabilities. The architecture supports:

  • Automatic Histogram Updates: Optimizes query performance automatically

  • Enhanced Security: Built-in data masking and de-identification

  • Improved Performance: Better query optimization and execution

Scalability Features:​

MySQL 8.4.5 supports large databases with up to 50 million records and handles databases with 200,000 tables containing approximately 5 billion rows. Each table supports up to 64 indexes, with each index supporting 1 to 16 columns.