DBA – ITFROMZERO – Share tobe shared!

Mastering InnoDB Tablespace: Tips for Handling Bloated ibdata1 Files and Optimizing I/O

By admin August 25, 2026

Running out of disk space due to ibdata1? Discover how to configure File-Per-Table, General Tablespace, and SSD/HDD tiering to optimize I/O and manage MySQL storage effectively.

Database

pg_repack Guide: Efficiently Resolving PostgreSQL Bloat with Zero Downtime

By admin August 11, 2026

PostgreSQL bloat wastes resources and degrades performance. Discover how to use pg_repack to efficiently reclaim disk space with zero downtime.

MySQL

Add Columns to a 200 Million Record Table in 0.1 Seconds: The Power of ALGORITHM=INSTANT in MySQL 8.0

By admin June 8, 2026

Discover how to use ALGORITHM=INSTANT in MySQL 8.0 to add or drop columns on tables with hundreds of millions of records in milliseconds, completely eliminating downtime.