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 | 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...