Architecture of InnoDB thread with related variables in MySQL 8

In this post we are going to share the MySQL 8 InnoDB architecture diagram with related variables.

From the official MySQL document we have seen some InnoDB variables related to MySQL 8.0.20. The architecture was prepared on this basis. In addition, we will provide a list of variables that are used in this diagram and its corresponding versions.

INNODB ARCHITECTURE IN MYSQL 8

To better understand the scheme we also added some old variables (sync_binlog / innodb_log_buffer / innodb_flush_log_at_trx_commit / innodb_flush_method, etc.).
We marked the MySQL 8 variables with yellow color.

VARIABLES IN MYSQL 8

• innodb_buffer_pool_in_core_file (8.0.14)
• innodb_doublewrite_batch_size (8.0.20)
• innodb_doublewrite_dir (8.0.20)
• innodb_doublewrite_files (8.0.20)
• innodb_doublewrite_pages (8.0.20)
• innodb_fsync_threshold (8.0.13)
• innodb_idle_flush_pct (8.0.18)
• innodb_log_checkpoint_fuzzy_now (8.0.13)
• innodb_parallel_read_threads (8.0.14)
• innodb_redo_log_archive_dirs (8.0.17)
• innodb_spin_wait_pause_multiplier (8.0.16)
• innodb_temp_tablespaces_dir (8.0.13)