DBA

No Picture
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 […]
No Picture
MySQL Performance

How to optimize indexes in MySQL

Optimizing Indexes in MySQL Indexes in MySQL are used to improve the performance of SELECT, UPDATE, and DELETE statements by reducing the amount of data that needs to be scanned. Properly optimizing indexes can help […]
No Picture
MySQL DBA

Quick Run-Book on MySQL Group Replication

The checklist for operating MySQL Group Replication MySQL Group Replication is a plugin for MySQL that allows you to create a group of MySQL servers that work together to provide a replicated and highly available […]
No Picture
DBA

How to use a Binary Search Key

Understanding how Binary Search Key works?  A binary search key is used to quickly search for a specific value in a sorted array or list. The basic idea behind the binary search algorithm is to […]
No Picture
PostgreSQL DBA

How to monitor PostgreSQL replication lag

PostgreSQL Advanced DBA Series: Monitoring PostgreSQL replication lag There are several ways to monitor replication lag in PostgreSQL: pg_stat_replication: This is a PostgreSQL system view that provides information about the replication status, including the replication lag. […]
No Picture
MariaDB

What’s new and changed with MariaDB 10.8?

What’s new and changed with MariaDB 10.8? Added support for IN,OUT and INOUT qualifying parameters for stored functions in MariaDB 10.8, MariaDB already supports IN, OUT and INOUT parameters. This contribution was made by ManoharKB […]
No Picture
MariaDB

MariaDB 10.4 shutdown new feature for Data Reliability

How can you shutdown MariaDB 10.4 safely without Data Reliability concerns ? MariaDB 10.4 has several interesting new features solving database performance and reliability concerns, You can learn more about MariaDB 10.4 new features here . […]