Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
No Picture
MySQL Performance

MySQL Latches: Understanding How They Work

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

MySQL Parsing: What Is a Parse Call?

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

MySQL Thread Performance Troubleshooting Guide

Troubleshooting MySQL Thread Performance - MySQL DBA Scripts Series(Tricks and Techniques) Overview This post is about how we can troubleshoot MySQL Thread performance intuitively.  Several folks have asked me by now about how I do [...]