blogs

Blogs

Extract some insightful technical points from the book “The Art of Problem-Solving in Software Engineering:How to Make MySQL Better”.

Professional Journey:

A Brief Overview of My Professional Journey

Table of Contents

Analysis of the Root Causes of MySQL Performance Degradation

How can the scalability of MySQL be improved

How to explain why Repeatable Read surprisingly outperforms Read Committed?

The Significant Differences Between BenchmarkSQL and SysBench

Profile-guided optimization

Performance Degradation in Query Execution Plans

Enhancing the InnoDB Storage Engine

Improving Binlog Group Commit Scalability

Evaluating Performance Gains in MySQL Lock Scheduling Algorithms

The Powerful Impact of Static Arrays in MySQL Modifications

Lack of Durability: Paxos Not Committed to Disk

How to Mitigate Performance Fluctuations in MySQL Group Replication?

logical_reasoning_samples

Traditional Group Replication vs New Group Replication

The Problems with Paxos Variant Algorithms in Group Replication

Book Link:

The Art of Problem-Solving in Software Engineering:How to Make MySQL Better.

Errata

If you find any errata in the book, please open a new issue.