DEV Community

Shiv Iyer profile picture

Shiv Iyer

Founder CEO of #MinervaDB #ChistaDATA #MySQL #PostgreSQL #RocksDB #InnoDB #MariaDB #ClickHouse #Linux #Entreprenuer #Investor #Startup #OpenSource #BigData #Analytics #SRE #AI #ML #DevOps #OLTP #OLAP

Location San Francisco Joined Joined on  Personal website https://minervadb.xyz github website

Work

Founder and CEO at MinervaDB

Effective Strategies for Troubleshooting MongoDB Wait Events in Long-Running Query Operations

Effective Strategies for Troubleshooting MongoDB Wait Events in Long-Running Query Operations

1
Comments
3 min read
Proactive Monitoring and Anomaly Detection in MySQL Server Performance

Proactive Monitoring and Anomaly Detection in MySQL Server Performance

1
Comments
2 min read
How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

Comments
3 min read
How does Wave Analytics handle data from external databases in PostgreSQL?

How does Wave Analytics handle data from external databases in PostgreSQL?

Comments
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

2
Comments
3 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

Comments
3 min read
Tips and Tricks for Troubleshooting ClickHouse Wait Events

Tips and Tricks for Troubleshooting ClickHouse Wait Events

1
Comments
2 min read
Impact of Fragmented PostgreSQL Infrastructure on Performance, Scalability, and Security

Impact of Fragmented PostgreSQL Infrastructure on Performance, Scalability, and Security

Comments
3 min read
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

15
Comments
2 min read
Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16

Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16

3
Comments
3 min read
Effective Annotating of Strace Output for MySQL Performance Troubleshooting

Effective Annotating of Strace Output for MySQL Performance Troubleshooting

1
Comments
4 min read
Implementing Index Recommendation by PostgreSQL Optimizer

Implementing Index Recommendation by PostgreSQL Optimizer

3
Comments
3 min read
Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

3
Comments
2 min read
Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Comments
3 min read
Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

5
Comments
2 min read
Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Comments
3 min read
Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

1
Comments
2 min read
The Indispensable Role of Database Architects and Engineers in Optimizing DBaaS and RDS Environments

The Indispensable Role of Database Architects and Engineers in Optimizing DBaaS and RDS Environments

Comments
2 min read
Optimizing PostgreSQL Performance: A Comprehensive Guide to Rowstore Index Implementation and Tuning

Optimizing PostgreSQL Performance: A Comprehensive Guide to Rowstore Index Implementation and Tuning

1
Comments
3 min read
Mastering PostgreSQL Performance: Key Impacts of autovacuum_vacuum_scale_factor Tuning

Mastering PostgreSQL Performance: Key Impacts of autovacuum_vacuum_scale_factor Tuning

Comments
2 min read
Mastering Bound Queries in PostgreSQL: A Step-by-Step Guide with Examples

Mastering Bound Queries in PostgreSQL: A Step-by-Step Guide with Examples

Comments
2 min read
Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

Comments
2 min read
Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

Comments
3 min read
How to optmize PostgreSQL query performance tuning effective_cache_size ?

How to optmize PostgreSQL query performance tuning effective_cache_size ?

Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

1
Comments
3 min read
Troubleshooting SELECT * queries in PostgreSQL

Troubleshooting SELECT * queries in PostgreSQL

Comments
2 min read
Optimizing SQL Server Performance: A Guide to Using sys.dm_exec_query_stats for Query Troubleshooting

Optimizing SQL Server Performance: A Guide to Using sys.dm_exec_query_stats for Query Troubleshooting

Comments
2 min read
Mastering Query Store for SQL Server Performance Troubleshooting: A Step-by-Step Guide

Mastering Query Store for SQL Server Performance Troubleshooting: A Step-by-Step Guide

Comments
3 min read
Troubleshooting ClickHouse Performance from Execution Plan

Troubleshooting ClickHouse Performance from Execution Plan

1
Comments
2 min read
Using DBMS_SQL for Dynamic SQL Execution in EDB Postgres Advanced Server 16

Using DBMS_SQL for Dynamic SQL Execution in EDB Postgres Advanced Server 16

Comments
2 min read
Linear Trees in InnoDB

Linear Trees in InnoDB

Comments
3 min read
SHOW ENGINE INNODB STATUS\G

SHOW ENGINE INNODB STATUS\G

Comments
2 min read
Troubleshooting Fragmented Indexes in PostgreSQL

Troubleshooting Fragmented Indexes in PostgreSQL

2
Comments
3 min read
How misconfiguration of autovacuum_vacuum_scale_factor in PostgreSQL can negatively impact on performance?

How misconfiguration of autovacuum_vacuum_scale_factor in PostgreSQL can negatively impact on performance?

1
Comments
2 min read
Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

2
Comments
2 min read
How to encrypt MySQL data with keys

How to encrypt MySQL data with keys

Comments
2 min read
Impact of Faster CPUs vs. More CPUs on ClickHouse Performance

Impact of Faster CPUs vs. More CPUs on ClickHouse Performance

Comments
1 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Comments
3 min read
Troubleshooting SQL statments with weak selectivity in ClickHouse

Troubleshooting SQL statments with weak selectivity in ClickHouse

Comments
2 min read
How does the wrong checkpointing configuration in PostgreSQL affect the performance?

How does the wrong checkpointing configuration in PostgreSQL affect the performance?

4
Comments
2 min read
Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

1
Comments
2 min read
Step-by-step implementation Filesystem Snapshots in PostgreSQL

Step-by-step implementation Filesystem Snapshots in PostgreSQL

1
Comments
2 min read
Resolving PostgreSQL Error 53300: TOO_MANY_CONNECTIONS - A Comprehensive Troubleshooting and Optimization Guide

Resolving PostgreSQL Error 53300: TOO_MANY_CONNECTIONS - A Comprehensive Troubleshooting and Optimization Guide

1
Comments
2 min read
Python Script for Early Detection of Data Corruption in ClickHouse Databases

Python Script for Early Detection of Data Corruption in ClickHouse Databases

Comments
2 min read
Mastering MySQL Performance: Advanced Counters and Linux Metrics with Expert Scripts

Mastering MySQL Performance: Advanced Counters and Linux Metrics with Expert Scripts

Comments
2 min read
MySqlException (0x80004005): The Command Timeout expired before the operation completed

MySqlException (0x80004005): The Command Timeout expired before the operation completed

1
Comments
2 min read
Tips and Tricks for isolating long running queries in MySQL

Tips and Tricks for isolating long running queries in MySQL

1
Comments
2 min read
Tuning InnoDB for efficient compression

Tuning InnoDB for efficient compression

Comments
2 min read
Implementing nested loop joins in MySQL for performance

Implementing nested loop joins in MySQL for performance

1
Comments
2 min read
How to configure ClickHouse for INSERT performance?

How to configure ClickHouse for INSERT performance?

3
Comments
2 min read
Enhancing Real-Time Analytics and AI/ML with Vectorized Query Computing in ClickHouse

Enhancing Real-Time Analytics and AI/ML with Vectorized Query Computing in ClickHouse

Comments
2 min read
Step-by-Step Guide to Setting Up Point-in-Time Recovery in PostgreSQL 16 with Scripts

Step-by-Step Guide to Setting Up Point-in-Time Recovery in PostgreSQL 16 with Scripts

2
Comments
1 min read
SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

Comments
2 min read
How do you perform the compressed back of the InnoDB Cluster?

How do you perform the compressed back of the InnoDB Cluster?

1
Comments
2 min read
loading...