Blog

No Picture
InnoDB

How to restore system statistics in InnoDB?

InnoDB System Statistics: How to Restore and Maintain Them In InnoDB, system statistics play a crucial role in query optimization and performance. These statistics help the MySQL query optimizer make informed decisions about query execution […]
No Picture
InnoDB

How Process Global Area is managed in InnoDB?

  InnoDB: Management of the Process Global Area (PGA) In InnoDB, the Process Global Area (PGA) manages per-connection memory and data structures for each client connection, including query execution buffers, sort buffers, and join buffers. […]
No Picture
MySQL Internals

Understanding cursor implementation in MySQL

In MySQL, a cursor is a database object that allows you to retrieve and manipulate data row by row. It provides a mechanism for iterative processing of query results. Cursors are often used when you […]
No Picture
PostgreSQL DBA

How to implement Encryption-at-Rest for PostgreSQL in Kubernetes?

Implementing encryption-at-Rest for PostgreSQL in Kubernetes involves configuring encryption for the persistent storage where PostgreSQL data resides. Below is a step-by-step explanation of how to achieve this, along with a real-world example: apiVersion: apps/v1kind: Deploymentmetadata:name: […]
No Picture
InnoDB

Reading and Writing Blocks in InnoDB

InnoDB, the default storage engine in MySQL, uses a buffer pool to manage the reading and writing of data blocks. The buffer pool is a cache that holds frequently accessed data pages in memory, reducing […]
No Picture
PostgreSQL DBA

SQL/JSON patches committed to PostgreSQL 15!

PostgreSQL SQL/JSON: PostgreSQL continues evolving its support for modern data formats with each release. Notably, PostgreSQL 15 introduces significant improvements to handle JSON data more efficiently. These updates bring greater flexibility, performance, and ease of […]