MySQL Performance
What is a parse call in MySQL?
What is a parse call in MySQL? In MySQL, a parse call refers to the process of analyzing a SQL statement and preparing it for execution. When a client sends a SQL statement to the […]
Articles by Shiv Iyer
PostgreSQL DBA
Step-by-step PostgreSQL 15 multi-master Replication for High Availability
Step-by-step PostgreSQL 15 multi-master Replication for High Availability Here is a general step-by-step guide for setting up multi-master replication in PostgreSQL 15 for high availability: Step 1: Prepare the master nodes: Make sure that the […]
PostgreSQL Performance
How Least Recently Used (LRU) list is managed in PostgreSQL?
How Least Recently Used (LRU) list is managed in PostgreSQL? In PostgreSQL, the least recently used (LRU) list is a mechanism used to manage the buffer cache. The buffer cache is a memory area used […]
PostgreSQL Performance
How PostgreSQL Vacuum works?
How does PostgreSQL Vacuum work? In PostgreSQL, the vacuum process is responsible for reclaiming space from deleted or updated rows in tables. The vacuum process works by scanning the table and removing any rows that […]
MySQL Performance
Troubleshooting MySQL Locks and Wait Events Performance – MinervaDB DBA Series
Troubleshooting MySQL Locks and Wait Events Performance – MinervaDB MySQL DBA Tricks and Techniques Series Overview Relational Database Management Systems are built to manage ACID (Atomicity, Consistency, Isolated and Durable) complaint Database Infrastructure for Real-Time […]
MySQL Performance
Troubleshooting MySQL Thread Performance
Troubleshooting MySQL Thread Performance – MySQL DBA Scripts Series(Tricks and Techniques) Overview This post is about how we can troubleshoot MySQL Thread performance intuitively. Several folks have asked me by now about how I do […]
MySQL Performance
MySQL DBA Script – Monitoring MySQL Application (SQL) efficiency: Latency and Throughput
Troubleshooting MySQL performance for both Latency and Throughput (MySQL DBA Scripts) Overview Being a full-time MySQL Performance Engineer, the most important part of my job is troubleshooting MySQL performance using the relevant matrix for Root […]
PostgreSQL Limitations
PostgreSQL Limitations – Understanding What PostgreSQL can do for you and when not recommend PostgreSQL
A Brief History of PostgreSQL
PostgreSQL History The object-relational database management system now known as PostgreSQL is derived from the POSTGRES package written at the University of California at Berkeley. With over two decades of development behind it, PostgreSQL is […]
MinervaDB
MySQL 8 Query Rewriter Plugins and DDL Rewriter
Optimizing MySQL 8 performance with Query Rewriter Plugins and DDL Rewriter When you are building a Database Systems Infrastructure for performance of an WebScale application, the optimal query performance is very important for both customer […]