MySQL – Page 2 – ITFROMZERO – Share tobe shared!

JSON_TABLE() in MySQL 8: Converting Nested JSON Data into Relational Tables

By admin July 6, 2026

JSON_TABLE() in MySQL 8 converts JSON arrays into relational rows, enabling standard GROUP BY, JOIN, and aggregate operations. This guide compares it with JSON_EXTRACT and application-side processing, analyzes when to use each approach, with real-world examples including NESTED PATH and inconsistent data handling.

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.

MySQL

Configuring MySQL Active-Active Replication: Bidirectional Data Sync and Concurrent Write Conflict Handling

By admin July 2, 2026

A step-by-step guide to configuring MySQL Active-Active (Master-Master) Replication — from setting up binlog users and configuring auto_increment to prevent ID collisions, to handling write conflicts and practical routing tips from a 50GB production database.

MySQL

Multi-tenant Architecture in MySQL: From Hard-Learned Lessons to Scaling SaaS for Thousands of Users

By admin July 1, 2026

Learn how to implement Multi-tenancy in MySQL based on real-world experience. A detailed comparison of Database-per-tenant and Shared Schema, including data security tips using Session Variables.

MySQL

Rescuing MySQL Data: A Hands-On Guide to Handling InnoDB Corruption

By admin June 28, 2026

MySQL crashed due to InnoDB corruption? Don't panic. Follow this 5-step process using innodb_force_recovery to safely and efficiently recover your data.

MySQL

Optimizing my.cnf for MySQL 8: Don’t Let Your Server ‘Choke’ on Default Settings

By admin June 28, 2026

MySQL 8's default configuration is often underpowered. This guide shows you how to optimize my.cnf to maximize RAM and CPU usage for better database load handling.

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.

MySQL

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

By admin 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 admin 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.