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.

MySQL Index Usage and Disk I/O with Performance Schema: A Comprehensive Guide

Introduction : Index usage and disk I/O play a crucial role in optimizing MySQL database performance. Monitoring how indexes are utilized provides valuable insights. Analyzing their impact on disk I/O helps identify potential bottlenecks and […]

Query Diagnostics in MySQL 8: Monitoring Expensive Queries by Latency and Source for Performance Optimization

Decoding MySQL Performance: Monitoring Expensive Queries by Latency and Source Introduction-Query Diagnostics in MySQL 8: Navigating database performance complexity is challenging, especially with intricate queries and vast data volumes. Managing MySQL performance effectively requires monitoring […]

MySQL Database Growth: Monitoring and Managing Disk I/O

MySQL Database Growth Ever experienced sudden slowdowns or unforeseen performance hiccups in your MySQL database? Disk I/O often becomes a crucial performance factor as databases grow and traffic increases. An effective way to manage this […]

MySQL Redo Log Monitoring: Mastering Performance Through Redo Log Activity

Unlocking MySQL Performance: A Deep Dive into Redo Log Monitoring and Optimization Introduction: In MySQL database administration, performance is paramount. Ensuring that your MySQL server runs smoothly involves several key aspects. One of the most […]

Decoding the Backbone: Understanding PostgreSQL Background Processes for Optimal Performance

In PostgreSQL, background processes play a crucial role in managing various tasks that are essential for the database to function efficiently. These background processes are responsible for handling maintenance tasks, background jobs, and other critical […]

PostgreSQL Process and Memory Architecture: Optimizing Performance

PostgreSQL Process and Memory Architecture: PostgreSQL is a multi-process, multi-threaded relational database management system. It consists of various processes and uses a combination of shared and private memory to manage data and provide concurrent access to […]

Ten deadly default values in PostgreSQL configuration file

Introduction: Configuring the PostgreSQL configuration file plays a crucial role in optimizing database performance, stability, and security. However, you must recognize potential pitfalls in the default settings. Some default values do not suit all environments […]

The Data Transformation Company

Data Architecture, Engineering and Operations for SQL, NoSQL, NewSQL, Cloud Native Data Platforms, Analytics and AI