Database Optimization – ITFROMZERO

MySQL Prefix Indexes: The ‘Weight Loss’ Secret for Indexes Without Sacrificing Speed

By admin August 18, 2026

Don't let indexes become a burden on your hard drive. Discover how to use Prefix Indexes in MySQL to speed up queries and save memory for long data columns.

Database

PostgreSQL Optimization: Using Partial and Covering Indexes to Reduce Storage by 90% and Speed Up Queries

By admin August 16, 2026

Don't let indexes slow down your system. Discover how to combine Partial and Covering Indexes in PostgreSQL to optimize performance and save storage space 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

Mastering Vietnamese Search in MySQL: From Sluggish LIKE to Optimized Full-Text Search

By admin August 8, 2026

Don't let search features slow down your system. Discover how to combine Shadow Columns and MySQL Full-Text Search for seamless accented and unaccented Vietnamese queries.

MySQL

MySQL Hash Join: A Lifesaver for Queries Lacking Indexes on MySQL 8.0.18+

By admin July 30, 2026

What is MySQL Hash Join? Learn how it works, how to configure join_buffer_size, and practical tips to significantly speed up JOIN queries lacking indexes.

Fedora

Deploying MySQL 8 on Fedora Server: Production Configuration Guide and SELinux Troubleshooting

By admin July 22, 2026

Learn how to install MySQL 8 on Fedora Server for production. Detailed guide on handling SELinux, configuring Firewalld, and optimizing RAM for peak performance.

MySQL

Solving MySQL Replication Lag: Speed Up Syncing with Parallel Replication

By admin July 5, 2026

Eliminate MySQL Replication Lag using Parallel Replication (MTS) and real-world I/O optimization techniques to keep your systems perfectly in sync.

MySQL

Mastering MySQL Optimizer Hints: When to Take the Wheel from the Optimizer?

By admin July 5, 2026

Don't let MySQL decide everything. Discover how to use Optimizer Hints in MySQL 8 to optimize indexes, control JOIN order, and instantly speed up queries.

Database

Analyzing MySQL Slow Query Log with pt-query-digest: Pinpointing the Real Culprit Behind Database Slowdowns

By admin June 27, 2026

pt-query-digest from Percona Toolkit analyzes MySQL Slow Query Log by grouping and ranking queries by their performance impact. A step-by-step guide: enable logging, install the tool, read the report, and optimize real-world queries.

MySQL

Optimizing MySQL Pagination for Millions of Rows: Use Seek Method Instead of OFFSET

By admin June 27, 2026

LIMIT OFFSET is the most common performance trap for MySQL tables with millions of rows — the larger the OFFSET, the more rows MySQL must scan and discard. This article breaks down the root cause and walks through two optimization techniques: Late Row Lookup and the Seek Method (Keyset Pagination), with real benchmark data.