Blog

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 […]
No Picture
PostgreSQL Performance

How PostgreSQL Vacuum works?

How does PostgreSQL Vacuum work? In PostgreSQL, the vacuum process is responsible for reclaiming space from deleted or updated rows in tables. The vacuum process works by scanning the table and removing any rows that […]
No Picture
MySQL Performance

How to optimize indexes in MySQL

Optimizing Indexes in MySQL Indexes in MySQL are used to improve the performance of SELECT, UPDATE, and DELETE statements by reducing the amount of data that needs to be scanned. Properly optimizing indexes can help […]
No Picture
PostgreSQL DBA

How to implement Parallelized Vacuum in PostgreSQL 15?

How to implement Parallelized Vacuum in PostgreSQL 15? In PostgreSQL 15, the parallelized vacuum feature allows you to run multiple vacuum processes in parallel, which can significantly improve the performance of the vacuum operation. Here […]