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.

MinervaDB and ChistaDATA: Exciting Plans Ahead

Empowering Data Management: The Vision for MinervaDB and ChistaDATA As the founder of both MinervaDB Inc. and ChistaDATA Inc., I am thrilled to share our vision for the next two years. Our companies have been […]

A Comprehensive Guide to Troubleshooting MariaDB Wait Events and Optimizing Database Performance

Introduction Troubleshooting MariaDB wait events is a critical aspect of maintaining a high-performing and reliable database system. When running a complex database like MariaDB, various wait events can impact performance and cause bottlenecks. Therefore, […]

MySQL Temporal Table: SYSTEM-VERSIONED and APPLICATION-VERSIONED Historical Data Tracking

Introduction Temporal tables in MySQL offer a powerful solution for tracking historical changes to data. They provide valuable insights into how records have evolved over time. With the introduction of SYSTEM-VERSIONED and APPLICATION-VERSIONED temporal […]

MySQL UPDATE() and COLUMNS_UPDATED(): Trigger Functions for Efficient Updates

In MySQL, the UPDATE() and COLUMNS_UPDATED() functions are used to identify which columns were updated in a trigger or a stored procedure. These functions are useful when performing specific actions based on modified columns during […]

SQL Aggregation in PostgreSQL: A Comprehensive Guide to Functions and Use Cases

SQL Aggregation in PostgreSQL- Introduction: Aggregation functions in PostgreSQL calculate values for groups of rows, summarize data, and provide meaningful insights. These functions help analyze data and generate reports by retrieving aggregated information from large […]

PostgreSQL Cost-Based Vacuum Delay: Optimizing Database Maintenance

In PostgreSQL, maintaining the database plays a crucial role in optimizing performance and ensuring efficient storage use. Vacuuming is one of the key maintenance tasks that remove dead rows, reclaim space, and improve query performance. […]

PostgreSQL 15 Data Types: Elevating Performance and Functionality

Empowering Your Database with PostgreSQL 15 Data Types Advancements: Performance, Efficiency, and Innovation Introduction: PostgreSQL 15 introduces several new data types and enhances existing ones. These improvements offer greater flexibility and boost performance for database […]

PostgreSQL Parallel Labeling: Harnessing Parallelism for Faster Queries

Parallel Labeling for Functions and Aggregation Parallel Labeling for Functions and Aggregation is a feature in PostgreSQL that allows certain functions and aggregations to run in parallel. It utilizes multiple CPUs and cores to speed […]

MySQL Wait Events Monitoring in MySQL 8 Using Performance Schema

MySQL Wait Events Monitoring MySQL Wait Events Monitoring uses the Performance Schema to track wait events, helping you identify which resources are causing delays. This insight allows you to detect potential performance bottlenecks and optimise […]

MySQL Parallel Query Tuning: Optimizing InnoDB with Multiple CPUs

InnoDB, the default storage engine in MySQL, enhances performance by supporting parallel query execution. This feature efficiently utilizes multiple CPUs or CPU cores, speeding up query processing. Parallel query execution allows InnoDB to split a […]

The Data Transformation Company

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