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'.

432

Articles

Likes

515

Views

Comments

Latest from Senior Brother's Insights

100 recent articles max

Senior Brother's Insights

Oct 27, 2025 · Databases

How Does MySQL Power High‑Performance OLTP Workloads?

This article explains what OLTP (Online Transaction Processing) is, outlines its key characteristics, and details how MySQL—through ACID‑compliant transactions, the InnoDB storage engine, various indexing strategies, fast locking mechanisms, query optimization, and high‑availability features—effectively supports high‑concurrency, low‑latency transactional workloads.

Database TransactionsInnoDBMySQL

0 likes · 9 min read

How Does MySQL Power High‑Performance OLTP Workloads?

Senior Brother's Insights

Oct 26, 2025 · Databases

Inside InnoDB: Unpacking MySQL’s Table Space, Segments, Extents, Pages & Rows

This article delves into the hierarchical logical architecture of MySQL’s InnoDB storage engine, detailing how table spaces, segments, extents, pages, and rows are organized, their functions, configuration options, and how they together enable efficient data storage, access, and transaction management.

Database ArchitectureInnoDBMySQL

0 likes · 7 min read

Inside InnoDB: Unpacking MySQL’s Table Space, Segments, Extents, Pages & Rows

Senior Brother's Insights

Oct 23, 2025 · Databases

InnoDB vs MyISAM: Which MySQL Storage Engine Fits Your Needs?

This article compares MySQL's InnoDB and MyISAM storage engines across dimensions such as transaction support, locking, file structure, indexing, full‑text search, and COUNT(*) performance, helping developers choose the appropriate engine based on workload and consistency requirements.

Full-text searchInnoDBMySQL

0 likes · 13 min read

InnoDB vs MyISAM: Which MySQL Storage Engine Fits Your Needs?

Senior Brother's Insights

Oct 21, 2025 · Databases

How MySQL Executes a SELECT Query: From Client to Storage Engine

This article walks through the complete lifecycle of a MySQL SELECT statement, detailing how the client, connector, optional query cache, parser, optimizer, and executor interact to transform SQL text into an execution plan and finally return results.

Database InternalsExecutorMySQL

0 likes · 13 min read

How MySQL Executes a SELECT Query: From Client to Storage Engine

Senior Brother's Insights

Oct 19, 2025 · Databases

Understanding MySQL’s Full Architecture: Layers, Components, and Storage Engines

This article provides a detailed overview of MySQL’s four‑layer architecture—including the client, server, storage engine, and system file layers—explaining each layer’s responsibilities, key modules, and the role of various built‑in and third‑party storage engines.

ArchitectureMySQLSQL

0 likes · 10 min read

Understanding MySQL’s Full Architecture: Layers, Components, and Storage Engines

Senior Brother's Insights

Oct 16, 2025 · Databases

Master MySQL JOIN Optimization: Understanding Driving and Driven Tables

This article explains the concepts of driving and driven tables in MySQL JOIN queries, shows how the optimizer chooses their order based on data size, indexes and filters, provides concrete examples with EXPLAIN output, and offers practical tips to control and improve table selection for better performance.

EXPLAINIndexJOIN

0 likes · 8 min read

Master MySQL JOIN Optimization: Understanding Driving and Driven Tables

Senior Brother's Insights

Oct 15, 2025 · Databases

Master MySQL Partitioning: When, How, and Why It Beats Sharding

This guide explains MySQL partitioning fundamentals, shows how to create RANGE, LIST, and KEY partitions with concrete CREATE TABLE examples, compares the performance benefits and maintenance trade‑offs, and clarifies the differences between partitioning and sharding to help you decide when to use each technique.

KEYMySQLPartitioning

0 likes · 7 min read

Master MySQL Partitioning: When, How, and Why It Beats Sharding

Senior Brother's Insights

Oct 14, 2025 · Databases

How Implicit Index Masking and Redundant Conditions Impact MySQL Query Performance

This article explains how MySQL indexes work, why wrapping indexed columns in functions can implicitly mask them, and how adding logical or domain‑knowledge‑based redundant conditions can unlock index usage to dramatically improve query efficiency.

B+TreeImplicit MaskingMySQL

0 likes · 10 min read

How Implicit Index Masking and Redundant Conditions Impact MySQL Query Performance

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.

MySQLNOT NULLStorage Efficiency

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.

MySQLPerformancePostgreSQL

0 likes · 10 min read

PostgreSQL vs MySQL: Which Relational Database Fits Your Project?