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

Likes

684

Views

Comments

Latest from Senior Brother's Insights

100 recent articles max

Senior Brother's Insights

Oct 13, 2025 · Databases

Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space

This article explains why defining MySQL table columns as NOT NULL—unless business logic demands NULL—improves query speed, reduces storage overhead, enhances index efficiency, prevents aggregation distortion, simplifies application code, and strengthens data consistency, while also noting scenarios where NULL is appropriate.

Database OptimizationMySQLNOT NULL

0 likes · 9 min read

Why Setting MySQL Columns to NOT NULL Boosts Performance and Saves Space

Senior Brother's Insights

Oct 12, 2025 · Databases

PostgreSQL vs MySQL: Which Relational Database Fits Your Project?

This article compares PostgreSQL and MySQL, covering their definitions, core similarities, key differences in performance, scalability, features, ecosystem, and community, and provides practical guidance on selecting the right database for various project scenarios.

EcosystemMySQLPostgreSQL

0 likes · 10 min read

PostgreSQL vs MySQL: Which Relational Database Fits Your Project?

Senior Brother's Insights

Oct 10, 2025 · Databases

Why Implicit Type Conversion Breaks Indexes in MySQL Joins and How to Fix It

This article explains how MySQL's implicit type conversion during table joins can render indexes unusable or alter join order, and provides practical solutions such as aligning column types, using optimizer hints, and forcing indexes to restore query performance.

FORCE INDEXImplicit ConversionJOIN optimization

0 likes · 6 min read

Why Implicit Type Conversion Breaks Indexes in MySQL Joins and How to Fix It

Senior Brother's Insights

Oct 8, 2025 · Databases

When Do IS NULL and IS NOT NULL Use Indexes in MySQL? Surprising Findings

This article explores how MySQL decides whether queries with IS NULL or IS NOT NULL predicates can use an index, presenting three concrete examples with varying data sizes and NULL distributions, and explains the underlying storage of NULL values and optimizer cost decisions.

B+TreeIS NOT NULLIS NULL

0 likes · 9 min read

When Do IS NULL and IS NOT NULL Use Indexes in MySQL? Surprising Findings

Senior Brother's Insights

Oct 8, 2025 · Databases

Choosing the Right MySQL Date and Time Type: A Complete Guide

This article explains the five MySQL temporal column types—DATE, DATETIME, TIMESTAMP, YEAR, and TIME—detailing their storage size, valid ranges, typical use‑cases, timezone behavior, and the 2038 problem, helping developers pick the most suitable type for any scenario.

MySQLSQLTemporal Types

0 likes · 9 min read

Choosing the Right MySQL Date and Time Type: A Complete Guide

Senior Brother's Insights

Oct 7, 2025 · Databases

Why MySQL OR Queries Often Skip Indexes—and How to Fix Them

This article explains how MySQL's OR conditions can cause index loss, provides concrete query examples, analyzes why the optimizer falls back to full table scans, and offers practical solutions such as rewriting with UNION or adding missing indexes to restore efficient index usage.

Index OptimizationMySQLOR query

0 likes · 7 min read

Why MySQL OR Queries Often Skip Indexes—and How to Fix Them

Senior Brother's Insights

Oct 5, 2025 · Databases

Master MySQL JSON: From Basics to Advanced CRUD Operations

This article explains MySQL’s native JSON data type introduced in 5.7, covering its binary storage format, built‑in functions, generated‑column indexing, performance advantages over string storage, and detailed CRUD examples with SQL syntax and practical code snippets.

CRUDDatabaseJSON

0 likes · 14 min read

Master MySQL JSON: From Basics to Advanced CRUD Operations

Senior Brother's Insights

Oct 4, 2025 · Databases

Master MySQL Composite Indexes: Unlock the Leftmost Prefix Principle

This article explains what MySQL composite (multi‑column) indexes are, how they are built and ordered, the leftmost‑prefix rule that governs their usage, factors such as cardinality and selectivity for optimal design, and common scenarios where the index may become ineffective.

Composite IndexDatabase OptimizationIndex Selectivity

0 likes · 11 min read

Master MySQL Composite Indexes: Unlock the Leftmost Prefix Principle

Senior Brother's Insights

Oct 3, 2025 · Databases

Avoid These 3 Common MySQL Table Design Mistakes That Kill Performance

This article explains three frequent MySQL table‑design errors—choosing wrong data types and lengths, missing or redundant indexes, and improper storage structures—illustrating how they affect storage, query speed, and scalability, and offers practical guidelines to prevent them.

JSONMySQLperformance

0 likes · 7 min read

Avoid These 3 Common MySQL Table Design Mistakes That Kill Performance

Senior Brother's Insights

Sep 29, 2025 · Databases

Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing

This article walks through the evolution from binary search trees to balanced trees, B‑trees and finally B+ trees, explaining how MySQL's InnoDB and MyISAM storage engines implement these structures to reduce disk I/O and boost query performance.

B+TreeData StructuresDatabase Performance

0 likes · 12 min read

Why MySQL Uses B+ Trees: From BSTs to Efficient Indexing