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.

Troubleshooting MySQL 8 Redo Log File IO operations

Introduction Redo log file IO operations can significantly impact the performance of a MySQL database. The redo log is used to recover the database after a crash or unexpected shutdown. It records all changes made […]

Troubleshooting MySQL 8 locks and wait events, How they influence MySQL performance?

Locks and wait events can significantly impact MySQL performance as they can cause queries to wait, leading to slower response times and decreased performance. The main cause of lock and wait events is contention for […]

Why do we recommend EXPLICIT LOCKING for PostgreSQL Tables in concurrent Transaction Processing Systems?

In PostgreSQL, if explicit locking is not enforced, duplicate records can be inserted when multiple concurrent transactions try to insert the same record simultaneously. This can occur when two or more transactions are executed concurrently […]

How to handle errors inside a PostgreSQL transaction using savepoint?

In PostgreSQL, errors inside a transaction can also be handled using savepoints. A savepoint is a point within a transaction that can be rolled back, without rolling back the entire transaction. Here is an example […]

How can we combine Bloom Filter Offloading and Storage Indexes on MyRocks?

MyRocks is a storage engine for the MySQL database that uses RocksDB, a high-performance key-value store, as its underlying storage engine. By combining Bloom filter offloading and storage indexes, it is possible to further improve […]

How OR Logic can influence PostgreSQL performance in outer joins?

Using OR logic in outer joins can have a significant impact on PostgreSQL performance, especially when joining large tables. Here are a few factors to consider: To mitigate the impact of OR logic on PostgreSQL […]

Troubleshooting correlated subqueries performance in MySQL

Correlated subqueries in MySQL can be slow because they require the subquery to be executed for each row in the outer query. This means that the subquery is executed repeatedly, and the results are used […]

How to optimally delete records referenced from another table in PostgreSQL?

When deleting records from a table that are referenced by other tables in PostgreSQL, there are several ways to ensure that the deletion is performed optimally and does not violate any foreign key constraints. Here […]

Anatomy of PostgreSQL I/O Subsystem

The I/O subsystem is a critical component of PostgreSQL, responsible for reading and writing data to and from disk. Here is an overview of the anatomy of PostgreSQL’s I/O subsystem: Monitoring the I/O subsystem is […]

Understanding How Plan Cache Based Execution Statistics implemented in PostgreSQL?

Plan Cache Based Execution Statistics is a feature in PostgreSQL that collects and aggregates execution statistics for SQL statements that are stored in the plan cache. This allows users to monitor and analyze the performance […]