Database Optimization – ITFROMZERO

InnoDB Page Compression: A Pro Tip to Reduce Storage by 50% and Extend SSD Lifespan for MySQL

By admin September 5, 2026

Discover how to use InnoDB Page Compression to reduce MySQL storage by 50%. Detailed guide on configuration, checking actual disk usage, and CPU performance considerations.

MySQL

Mastering OPTIMIZER_TRACE: The Pro Technique for Dissecting MySQL Index Selection Logic

By admin September 1, 2026

A guide to using OPTIMIZER_TRACE for deep analysis of MySQL index selection. Resolve SQL performance issues effectively based on actual execution costs.

MySQL

Is MySQL Sluggish After a Restart? How to Keep Your Buffer Pool “Hot”

By admin August 26, 2026

Don't let MySQL fall into a 'Cold Cache' state after every restart. Detailed guide on how to configure InnoDB Buffer Pool Dump/Load to keep database performance at its peak.

MySQL

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.

MySQL

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.