MinervaDB Blog

No Picture
PostgreSQL Internals

PostgreSQL maintenance_work_mem: How It Is Used for VACUUM

In PostgreSQL, the maintenance_work_mem configuration parameter controls how much memory the system allocates for maintenance operations, including VACUUM. When you run a VACUUM operation, PostgreSQL sorts and processes data pages. This process helps reclaim disk […]
No Picture
MySQL Performance

MySQL Performance Schema: Unraveling Query Execution

Understanding Query Execution with Performance Schema As the scale and complexity of database workloads continue to increase, consequently, understanding the nuances of query execution becomes essential for MySQL Database Administrators (DBAs) and Developers. In this […]
No Picture
PostgreSQL Performance

PostgreSQL Index Bloat: Analysis and Detection

Introduction: Index bloat can significantly impact the performance and storage efficiency of a PostgreSQL database. Therefore, to identify and understand the extent of index bloat, we can use the SQL query provided below. In this […]
No Picture
InnoDB

InnoDB Flush Locks: Troubleshooting Guide

InnoDB Flush Locks InnoDB writes data to disk by using a method called “fuzzy checkpointing,” which spreads out writes to avoid sudden I/O bursts and maintain performance.  However, under certain circumstances, such as when there […]
No Picture
InnoDB

Tuning InnoDB history list performance

Tuning the InnoDB history list performance involves adjusting various parameters related to the purge process. The key parameters that can be tuned to optimize the history list performance in InnoDB are: To tune these parameters, follow […]