Blog

No Picture
PostgreSQL DBA

How pg_dump is different in PostgreSQL 16?

How pg_dump is different in PostgreSQL 16? The pg_dump command is a tool used to export data from a PostgreSQL database into a file. The tool has been included in PostgreSQL since version 7.0 and […]
No Picture
MySQL Performance

How MySQL optimizer works?

How does MySQL optimizer work? The MySQL optimizer is responsible for determining the most efficient way to execute a SQL statement. It evaluates different query execution plans and chooses the one that it estimates will […]
No Picture
MySQL Internals

How does checkpointing work in MySQL?

How does checkpointing work in MySQL? In MySQL, checkpointing is the process of flushing dirty pages from the buffer pool to disk, in order to ensure that the data on disk is in a consistent […]
No Picture
MySQL Performance

Understanding Latches in MySQL

Understanding Latches in MySQL In MySQL, latches are used to protect shared data structures and ensure consistency in the database. They are used by the storage engine to synchronize access to shared resources such as […]
No Picture
ClickHouse

Kafka Education Series: Kafka Internals

Kafka Education Series: Kafka Internals Kafka is a distributed streaming platform that allows you to collect, store, and process large streams of data in real-time. It is designed to handle high throughput, low latency, and […]
No Picture
MySQL Performance

What is a parse call in MySQL?

What is a parse call in MySQL? In MySQL, a parse call refers to the process of analyzing a SQL statement and preparing it for execution. When a client sends a SQL statement to the […]