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

438

Articles

Likes

2.1k

Views

Comments

Latest from Senior Brother's Insights

100 recent articles max

Senior Brother's Insights

Dec 3, 2025 · Databases

Can MySQL Partition Tables Work When created_at Is NULL? Understanding Default Timestamp Partitioning

This article explains why MySQL partitions based on a timestamp column still function correctly even when the application does not explicitly set the column, by detailing the default CURRENT_TIMESTAMP behavior, partition key evaluation, and practical examples with table definitions and insert statements.

DEFAULT CURRENT_TIMESTAMPMySQLSQL

0 likes · 6 min read

Can MySQL Partition Tables Work When created_at Is NULL? Understanding Default Timestamp Partitioning

Senior Brother's Insights

Nov 16, 2025 · Databases

Master MySQL Character Sets and Collations: Choose the Right Encoding for Optimal Performance

This article explains MySQL's supported character sets and collations, shows how to list them, demonstrates table‑level and column‑level definitions, clarifies naming conventions, and provides practical examples for verifying and altering collations to ensure correct string comparison and storage.

MySQLSQLcharacter set

0 likes · 10 min read

Master MySQL Character Sets and Collations: Choose the Right Encoding for Optimal Performance

Senior Brother's Insights

Nov 4, 2025 · Databases

Why Using UUIDs as MySQL Primary Keys Can Hurt Performance—and How to Fix It

UUIDs provide globally unique identifiers useful in distributed systems, but using them as MySQL primary keys can degrade insert speed, increase storage, and cause page splits; this article explains UUID versions, their structures, performance impacts, and best‑practice techniques such as binary storage, ordered UUIDs, and alternative ID schemes.

MySQLOrdered UUIDUUID

0 likes · 11 min read

Why Using UUIDs as MySQL Primary Keys Can Hurt Performance—and How to Fix It

Senior Brother's Insights

Nov 3, 2025 · Databases

Understanding MySQL Isolation Levels: From Dirty Reads to Serializable

This article explains MySQL's transaction isolation levels, the ACID principles behind them, common anomalies like dirty reads, non‑repeatable reads and phantom reads, the locking mechanisms that enforce isolation, and how to configure the desired level in practice.

ACIDMySQLTransaction

0 likes · 11 min read

Understanding MySQL Isolation Levels: From Dirty Reads to Serializable

Senior Brother's Insights

Oct 31, 2025 · Databases

Master MySQL Transactions: ACID, Locks, and Practical Examples

This article explains what database transactions are, why they matter, details MySQL’s transaction commands, the ACID properties, isolation levels, lock types, MVCC, how to use InnoDB, handle errors, employ savepoints, and provides concrete SQL examples for creating, committing, rolling back, and managing transactions.

ACIDDatabase TransactionsError Handling

0 likes · 12 min read

Master MySQL Transactions: ACID, Locks, and Practical Examples

Senior Brother's Insights

Oct 29, 2025 · Databases

Sharding vs Partitioning: When and How to Scale Your Database

This article explains the concepts, differences, advantages, and disadvantages of database sharding and partitioning, provides practical MySQL examples for horizontal sharding by region and range partitioning, and offers guidance on choosing the right approach for scalability and maintainability.

Data DistributionDatabase ScalingMySQL

0 likes · 10 min read

Sharding vs Partitioning: When and How to Scale Your Database

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 TransactionsHigh AvailabilityInnoDB

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 SearchInnoDBMyISAM

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