force index | BestHub

Architect's Guide

Oct 1, 2024 · Databases

Efficient Full‑Table Updates in MySQL: Handling Row‑Based Binlog, Deep Pagination, and Batch Processing

The article explains why executing a full‑table UPDATE on large MySQL tables using row‑based binlog can overload replication, discusses the inefficiencies of deep pagination and IN clauses, and presents a batch‑processing strategy that leverages SQL_NO_CACHE and FORCE INDEX to safely and efficiently migrate data.

Full Table UpdateMySQLSQL_NO_CACHE

0 likes · 8 min read

Efficient Full‑Table Updates in MySQL: Handling Row‑Based Binlog, Deep Pagination, and Batch Processing

JD Tech

Mar 29, 2024 · Databases

Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index

This article examines a MySQL slow‑query incident caused by the optimizer using the primary clustered index instead of an appropriate secondary index, explains the underlying index structures, and presents solutions such as FORCE INDEX and migrating complex queries to Elasticsearch for long‑term performance improvement.

DatabaseElasticsearchIndex Optimization

0 likes · 9 min read

Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index

php中文网 Courses

Nov 9, 2022 · Databases

MySQL Slow Query Optimization: Live Demonstration on a Production To-Do List

This article walks through a real‑world MySQL slow‑query case, detailing analysis, index checks, character‑set alignment, forced index usage, and IN‑clause considerations that together reduced a 5‑second query to under one second.

IN clauseIndex OptimizationMySQL

0 likes · 4 min read

MySQL Slow Query Optimization: Live Demonstration on a Production To-Do List