MySQL Archives - ITFROMZERO - Share tobe shared!

Mastering Stored Procedures and Cursors in MySQL: Safe Batch Processing and Error Handling

By IT From Zero October 29, 2026

A complete guide to writing MySQL Stored Procedures with Cursors for safe batch data processing, featuring Transaction wrapping, Exception Handlers, and database resource optimization.

MySQL

Guide to Views and Updatable Views in MySQL: Data Abstraction and Performance Optimization

By IT From Zero October 29, 2026

Master creating Views and Updatable Views in MySQL: mask sensitive columns, optimize the MERGE algorithm, and avoid production performance pitfalls.

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.

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.