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.

Impact of MySQL Server Misconfiguration on Group Replication Performance

Introduction Incorrect configuration of MySQL Server can significantly impact the performance of Group Replication, which is a crucial component for achieving high availability and scalability in MySQL. Here's how wrong configurations can negatively affect Group [...]

Understanding InnoDB Cluster for MySQL Horizontal Scaling

Understanding InnoDB Cluster: Internal Mechanics for MySQL Horizontal Scaling

Introduction InnoDB Cluster, a key feature of MySQL, provides a high-availability solution that also enables horizontal scaling of MySQL. It integrates several MySQL features – Group Replication, MySQL Shell, and MySQL Router – to facilitate [...]

Adaptive Joins in PostgreSQL 16 (mimicked feature)

Introduction PostgreSQL does not natively offer "Adaptive Hash Joins" as a built-in feature for query execution.Instead, the query planner selects join methods, such as nested loop, hash join, or merge join, during plan generation.Additionally, it [...]

Optimizing JOIN Operations in MySQL 8 for Enhanced Performance and Scalability

Introduction MySQL, particularly the InnoDB engine used in MySQL 8, primarily relies on Nested Loop joins for query execution. However, understanding how joins work and implementing them efficiently is crucial for database performance and scalability. [...]

Optimizing MySQL 8 for Enhanced WRITE Performance: Key Configuration Strategies

Introduction Tuning MySQL 8 for optimised write operations involves adjusting various settings and structures to enhance the performance of insertions, updates, and deletions. Here's a focused approach to tuning these write operations. Strategies to Tune [...]

Enable or Disable Adaptive Hash Indexing in MySQL?

Introduction Deciding whether to enable or disable Adaptive Hash Indexing (AHI) in MySQL involves a careful evaluation of your database's workload characteristics and performance metrics. AHI can significantly speed up read operations for certain types [...]

How to Configure the Number of Background InnoDB I/O Threads in MySQL 8 for Performance?

Introduction In MySQL, configuring the number of background InnoDB I/O threads is crucial for performance optimization, especially on servers with multiple cores and high I/O capacity. InnoDB uses background threads for tasks like flushing dirty [...]

How do InnoDB Parallel Redo Logs work in MySQL 8?

Introduction Parallel redo logging in InnoDB, introduced in MySQL 8.0, significantly improves write-heavy workload performance. It boosts redo log efficiency, especially on multi-core systems. Here's how it works. Background of Redo Logs in InnoDB Introduction [...]

Optimize PostgreSQL Performance: Strategic Use of SKIP_DATABASE_STATS and ONLY_DATABASE_STATS

Optimize PostgreSQL Performance Configuring SKIP_DATABASE_STATS and ONLY_DATABASE_STATS in PostgreSQL requires careful consideration to optimize PostgreSQL performance and maintain efficient database operations. In summary, while these options can customize backups to suit specific needs, their incorrect [...]

Speed Up Your PostgreSQL 16 Backups with Improved pg_dump

Example: When using pg_dump in PostgreSQL 16, you can specify the compression method: Here, -F c specifies custom-format output, -Z specifies the compression level (1 for LZ4, 3 for ZSTD), and -f specifies the output [...]