Recent stories

The hidden cost of too many indexes in MySQL

The hidden cost of too many indexes in MySQL


Indexes are great, right? They make your queries faster, improve lookups, and are essential to performance tuning.

3 min read
Important pre-checks before running pt-online-schema-change to Add/Drop an index in MySQL

Important pre-checks before running pt-online-schema-change to Add/Drop an index in MySQL


When you're working with large MySQL tables in production, making schema changes like adding or dropping indexes can be ...

6 min read
Improving Backup efficiency on SQL Server 2025 with the new ZSTD algorithm

Improving Backup efficiency on SQL Server 2025 with the new ZSTD algorithm


Native backup compression was introduced in SQL Server 2008 and was a game changer as it reduced the data space ...

6 min read

More stories