MinervaDB Blog: Mastering WebScale Database Infrastructure

Optimizing Database Performance with InnoDB Memory Structures

InnoDB is MySQL’s default storage engine, and understanding its memory structures is essential for optimizing database performance. Therefore, this blog explains InnoDB’s key memory structures and how to tune them effectively. Key InnoDB Memory Structures […]

Reclaiming Storage Space in Redis: Strategies and Limitations

Reclaiming Storage Space in Redis Redis, a powerful in-memory data structure store, serves as a database, cache, and message broker. While its in-memory architecture delivers exceptional performance, it also presents unique memory management challenges. This […]

Reclaim Storage in PostgreSQL Vacuum: How to Recover Space

Reclaim Storage in PostgreSQL Vacuum When you run a standard VACUUM command in PostgreSQL, you might notice that it doesn’t free up space at the operating system level, even though it cleans up dead tuples […]

MariaDB NULL Values: Troubleshooting Unexpected Results

Understanding MariaDB NULL Values When encountering unexpected NULL values in MariaDB databases, a methodical troubleshooting approach is essential. NULL values can appear for numerous reasons, from application logic issues to database configuration problems. This guide […]

PostgreSQL Execution Plan Analysis

PostgreSQL Execution Plan PostgreSQL execution plan analysis is critical for diagnosing query performance issues. Here’s how to interpret optimiser decisions and identify bottlenecks: Generating Execution Plans First, Generate basic plan estimation: EXPLAIN SELECT * FROM […]

pageinspect function: Inspecting Data Storage in PostgreSQL

pageinspect function: When it comes to maintaining high performance and ensuring data integrity in PostgreSQL, understanding how data is stored at the page level provides valuable insights. This knowledge helps database administrators and developers troubleshoot […]

What is new with pg_stat_statements in PostgreSQL 17?

New Features in pg_stat_statements in PostgreSQL 17 1. Tracking of Nested Statements PostgreSQL 17 adds the ability to track nested statements executed within functions, procedures, and DO blocks: Previously, only top-level statements were tracked However, […]

PostgreSQL Checkpointing and Background Writing Process

PostgreSQL Checkpointing PostgreSQL checkpointing is crucial in maintaining data integrity and ensuring consistent database performance. It works in tandem with background writing processes to manage disk I/O efficiently, reducing the risk of data loss in […]

How can we do Kafka Cluster Setup: Guidance on multi-broker clusters, ZooKeeper coordination?

How can we do Kafka Cluster Setup? Guidance on multi-broker clusters and ZooKeeper coordination (though newer versions replace ZooKeeper with KRaft)? Kafka Cluster Setup: Setting up a Kafka cluster involves choosing between ZooKeeper-based (legacy) and […]

PostgreSQL Vacuum and Vacuum full are not two different processes

PostgreSQL Vacuum and Vacuum full are not two different processes PostgreSQL Vacuum: PostgreSQL‘s VACUUM and VACUUM FULL are not separate processes but rather different operational modes of the same maintenance command. Here’s why: Core Implementation […]

The Data Transformation Company

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

MinervaDB Blog