Architecture of InnoDB thread with related variables in MySQL 8.

Preamble

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)

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.