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 Nagarajan Ponnusamy | Jul 1, 2024 | MySQL
In the ever-evolving landscape of database management, ensuring data redundancy, improving performance, and achieving robust disaster recovery mechanisms are paramount for any organization. One of the most effective strategies to achieve these goals is through MySQL...
by Santhinesh Nagendran | Aug 31, 2023 | MySQL, Performance insights, troubleshooting
In this blog we would be navigating through the little details particularly about threads, connections, and sessions, these each element plays a distinct role, contributing towards the orchestration of database operations. As we embark on this knowledge journey, we...
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...
