by Nagarajan Ponnusamy | Jun 30, 2026 | Innodb, MySQL
Table of Contents Part 1 – Setting the Foundation Introduction Understanding the InnoDB Architecture Meet Our Transaction Part 2 – The Write Path The Buffer Pool – Where Every Transaction Begins Redo Log – Protecting Transactions Before the Data Reaches Disk Undo Log...
by Nagarajan Ponnusamy | Jul 23, 2024 | Innodb, MyISAM, MySQL
Converting MyISAM tables to InnoDB can significantly enhance database performance and reliability. Although MyISAM has its unique advantages, InnoDB offers incredible benefits that often make it the preferred choice for production environments. Why is it Required?...
by Santhinesh Nagendran | Jul 6, 2023 | 8.0, Architecture, Innodb, KnowledgeBase, MySQL
IntroductionHow is the in-memory InnoDB buffer mapped with Disk objects?What is Space or Space_ID ?INFORMATION_SCHEMA.FILESSystem tablespacesUser tablespacesINFORMATION_SCHEMA.INNODB_TABLESPACESSys Schema based...
by Santhinesh Nagendran | Jun 16, 2023 | 8.0, Innodb, MySQL
IntroductionEnvironment OverviewList of Buffer Pool VariablesHow is the InnoDB buffer allocated ?What is innodb_buffer_pool_instances ?What do we have in each Innodb Buffer pool Instance ?What is innodb_buffer_pool_chunk_size ?Number of pages in each Innodb Buffer...
by Santhinesh Nagendran | May 29, 2023 | 8.0, Innodb, MySQL
What is the clone Plugin ?Enable the Clone PluginDefining the Donor nodesWhat privileges do you need for cloning ?How to monitor Cloning process ?Start the cloning processClone Progress and status monitoringRe-establishing the replication with the donor nodeLimitation...
