InnoDB Archives - ITFROMZERO - Share tobe shared!

Optimizing MySQL InnoDB Table Fragmentation: Using OPTIMIZE TABLE to Reclaim Disk Space

By IT From Zero October 7, 2026

Why does deleting millions of records fail to free up MySQL disk space? Here is how to detect InnoDB table fragmentation and safely use OPTIMIZE TABLE to reclaim disk space on production.

MySQL

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

By IT From Zero 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

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

By IT From Zero 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 IT From Zero 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

Fixing the “The table is full” Error in MySQL: When Hundreds of GBs are Still Free

By IT From Zero August 24, 2026

Don't panic when MySQL reports 'The table is full' despite having free disk space. This guide shows how to relax innodb_data_file_path limits and optimize tablespaces effectively.

MySQL

Is MySQL COUNT(*) Slow? Don’t Let Your Dashboard Freeze When Data Hits Millions of Rows

By IT From Zero July 30, 2026

Why does MySQL COUNT(*) slow down on large InnoDB datasets? This article analyzes the impact of MVCC and provides 4 optimization techniques using Counter Tables, Metadata, and Redis.

Centos

Installing MySQL 8 on CentOS Stream 9: Official Repository, SELinux, and Performance Tuning

By IT From Zero July 3, 2026

Guide to installing MySQL 8 on CentOS Stream 9 from the official repository — avoiding the common pitfall of getting MariaDB instead. Covers SELinux configuration, firewalld access control, and InnoDB buffer pool tuning for production servers.

MySQL

MySQL InnoDB Locking: Understanding Row, Gap, and Next-Key Locks to Prevent System Crashes

By IT From Zero June 27, 2026

A deep dive into Row, Gap, and Next-Key Locks in MySQL InnoDB. Real-world experience for preventing deadlocks and optimizing performance for high-scale systems.

MySQL

Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM

By IT From Zero June 26, 2026

Choosing the wrong MySQL data types causes unnecessarily bloated databases, high I/O, and wasted RAM. This article shares real-world experience from a 50GB production database: how to choose correctly between INT/BIGINT, VARCHAR/TEXT, ENUM, and TIMESTAMP to optimize performance right from schema design.

MySQL

How to Use MySQLTuner to Diagnose and Quickly Optimize MySQL Server Configuration

By IT From Zero June 13, 2026

MySQLTuner is a Perl script that analyzes your running MySQL configuration and delivers specific optimization recommendations in just a few minutes. This guide walks through installation, interpreting the output, and applying key settings like innodb_buffer_pool_size and thread_cache_size in practice.