MySQL Archives - Page 2 of 16 - ITFROMZERO

MySQL Group Replication Tutorial: Building an Auto-Failover InnoDB Cluster

By IT From Zero October 25, 2026

A step-by-step guide to setting up a MySQL InnoDB Cluster with Group Replication and MySQL Shell, enabling automated detection and failover in 2–3 seconds.

MySQL

A Guide to Configuring Table Partitioning in MySQL: Boosting Large Table Performance with RANGE and LIST

By IT From Zero October 25, 2026

Are tables over 50 million rows causing sluggish queries and crushing your database during DELETE operations? Table Partitioning (RANGE & LIST) in MySQL isolates data across partitions, accelerates query speeds, and reclaims disk space in seconds.

MySQL

Enable MySQL Slow Query Log and Use pt-query-digest to Find Database Bottlenecks

By IT From Zero October 24, 2026

A guide to enabling MySQL Slow Query Log without restarting the server and using pt-query-digest to dissect and rank CPU-bottlenecking queries in production.

MySQL

Optimizing Index Merge in MySQL: Understanding Intersection, Union, and Handling Optimizer Missteps

By IT From Zero October 22, 2026

MySQL's Index Merge combines multiple indexes using Intersection, Union, or Sort-Union. This article examines hardware overhead, EXPLAIN analysis, and composite index alternatives.

MySQL

Configuring the FEDERATED Storage Engine in MySQL: Connect and Query Remote Tables

By IT From Zero October 22, 2026

The FEDERATED Storage Engine in MySQL lets you directly query remote tables without building an ETL pipeline. This guide covers step-by-step setup, credential security, and critical performance pitfalls to avoid.

MySQL

Using MySQL Triggers in Practice: Validation, Audit Logging, and Avoiding Performance Pitfalls

By IT From Zero October 21, 2026

Practical lessons on using MySQL triggers in production: data validation, automated audit logging, and 4 critical rules to avoid database lock contention.

MySQL

Optimistic vs. Pessimistic Locking in MySQL: Eliminating Race Conditions and Overbooking

By IT From Zero October 20, 2026

A deep dive into Optimistic and Pessimistic Locking in MySQL, featuring practical code examples to prevent race conditions, deadlocks, and negative inventory.

MySQL

Optimizing MySQL Queries with Covering Indexes: The Secret to Eliminating Table Lookups

By IT From Zero October 18, 2026

Table Lookups are the primary cause of I/O bottlenecks on large datasets, even when queries use an index. Master Covering Indexes and Deferred Joins to slash query latency from seconds down to milliseconds.

Database

Configuring MySQL Read/Write Splitting with ProxySQL: Offload Read Queries Without Touching Application Code

By IT From Zero October 18, 2026

MySQL Master hitting 100% CPU while replicas sit idle? A step-by-step guide to configuring automatic Read/Write Splitting with ProxySQL to save production without touching application code.

MySQL

A Guide to Database Sharding for MySQL with Apache ShardingSphere: A Horizontal Scaling Solution

By IT From Zero October 17, 2026

Is MySQL hitting 45M rows, saturating disk I/O, and freezing production? Learn how to deploy Apache ShardingSphere-Proxy to shard horizontally, optimize routing, and avoid common performance traps.