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 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 3, 2023 | AWS RDS, Case Study, MySQL
Is Scaling/Autoscaling a blessing or curse ? There might be situations where we might have over provision resources ahead of time while capacity planning or resource planning in the initial stages of any application where we really can’t anticipate how much...
by Santhinesh Nagendran | Apr 28, 2023 | MySQL
We have come across several incidents where update stats have influenced a different choices of indexes causing the change in the execution plan which indeed degrades the query performance. Some of the most frequently asked questions about stats during those incident...