BestHub
Sign in
Senior Brother's Insights
Author

Senior Brother's Insights

A public account focused on workplace, career growth, team management, and self-improvement. The author is the writer of books including 'SpringBoot Technology Insider' and 'Drools 8 Rule Engine: Core Technology and Practice'.

434
Articles
0
Likes
684
Views
0
Comments
Recent Articles

Latest from Senior Brother's Insights

100 recent articles max
Senior Brother's Insights
Senior Brother's Insights
Sep 28, 2025 · Databases

Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table

MySQL query optimization involves three distinct index processing stages—Index Key, Index Filter, and Table Filter—each handling different parts of condition matching and data retrieval, and mastering their roles and execution flow can dramatically improve query performance, especially with index condition pushdown.

DatabaseMySQLindex condition pushdown
0 likes · 8 min read
Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table
Senior Brother's Insights
Senior Brother's Insights
Sep 25, 2025 · Databases

Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose

This article explains why selecting only needed columns and ensuring deterministic ordering are essential for MySQL queries, then compares Offset/Limit pagination with cursor‑based pagination, detailing their syntax, advantages, drawbacks such as data drift and performance issues, and offers practical optimization tips.

MySQLOFFSET LIMITdeterministic ordering
0 likes · 12 min read
Offset/Limit vs Cursor Pagination in MySQL: When and How to Choose
Senior Brother's Insights
Senior Brother's Insights
Sep 24, 2025 · Databases

Why Your MySQL Index Isn’t Used and How to Fix It

This article explains how to verify whether MySQL uses an index with EXPLAIN, outlines eight common reasons why an index may be ignored—including better alternatives, low selectivity, stale statistics, full‑table scans, structural limitations, function usage, invisible indexes—and provides practical commands and hints to resolve each issue.

Database PerformanceEXPLAINMySQL
0 likes · 9 min read
Why Your MySQL Index Isn’t Used and How to Fix It
Senior Brother's Insights
Senior Brother's Insights
Sep 18, 2025 · Databases

Why MySQL Table Lookups Slow Queries and How to Eliminate Them

This article explains the concept of table lookups in MySQL, shows how they arise from using secondary indexes, provides concrete query examples, and offers practical optimization techniques such as creating covering indexes, reducing selected columns, and analyzing execution plans to improve performance.

InnoDBMySQLSQL performance
0 likes · 9 min read
Why MySQL Table Lookups Slow Queries and How to Eliminate Them
Senior Brother's Insights
Senior Brother's Insights
Sep 15, 2025 · Databases

Understanding MySQL Clustered vs Non‑Clustered Indexes: When and How to Use Them

This article provides a comprehensive review of MySQL’s two primary index types—clustered (clustered index) and non‑clustered (non‑clustered index)—explaining their storage mechanisms, performance trade‑offs, typical use cases, and best‑practice guidelines for selecting the appropriate index in database design.

Clustered IndexDatabase OptimizationMySQL
0 likes · 14 min read
Understanding MySQL Clustered vs Non‑Clustered Indexes: When and How to Use Them
Senior Brother's Insights
Senior Brother's Insights
Sep 13, 2025 · Databases

When Do Database Indexes Hurt More Than Help?

This article explains how indexes boost query speed but also incur storage, write‑performance, and maintenance costs, offering practical SQL scripts and guidelines for auditing, testing, and safely removing unnecessary indexes.

Database IndexesIndex ManagementMySQL
0 likes · 6 min read
When Do Database Indexes Hurt More Than Help?