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...
by Santhinesh Nagendran | May 8, 2023 | KnowledgeBase, MySQL
What is MySQL ReplicaSet ?Environment OverviewMandatory Configuration Needed for ReplicaSetMySQLShell Pre-checksConfigure both the nodes using dba.configureReplicaSetInstance()Ways of Setting up ReplicaSetReplicaSet From ScratchAdopting an existing GTID based...
by Santhinesh Nagendran | May 5, 2023 | General, KnowledgeBase, MySQL
What is Primary Key ?Issues due to tables without primary keyHow do we end up creating tables without primary key by mistake ?Performance issues caused by tables missing primary key ?How can we find the tables without primary key ?How can we restrict creation of...
