GitPedia

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

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

From enhancedformysql·Updated June 14, 2026·View on GitHub·

This book uses MySQL challenges as case studies to explore problem analysis and resolution strategies. Readers will gain a deeper appreciation for logical reasoning, data structures, algorithms, and more through practical examples and insightful discussions. The project is first published in 2024. It has gained significant community traction with 1,928 stars and 156 forks on GitHub. Key topics include: algorithms, cap, consistency, data-structure, dynamic-programming.

Latest release: book-release-v4— The Art of Problem-Solving in Software Engineering: How to Make MySQL Better - Fourth Edition Released
April 23, 2025View Changelog →

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

Introduction

This book uses MySQL challenges as case studies to explore problem analysis and resolution strategies. Readers will gain a deeper appreciation for logical reasoning, data structures, algorithms, and more through practical examples and insightful discussions.

Table of Contents

Preface

Part1 Problems

Chapter 1: Traditional Methods for Solving MySQL Problems

Chapter 2: Mysterious MySQL Problems

Part2 Basics

Chapter 3: How to Solve Software Problems Effectively

Chapter 4: Fundamentals of Computer Science

Chapter 5: MySQL Internals

Chapter 6: How to Scientifically Test MySQL Performance?

Part3 Analyzing and Addressing MySQL Problems

Chapter 7: Key Improvements of MySQL 8.0 Over MySQL 5.7

Chapter 8: Refining MySQL 8.0: Next-Level Improvements

Chapter 9: Major Enhancements in Group Replication

Chapter 10: Major Improvements for MySQL Secondary Replay

Part4 Tuning

Chapter 11: Performance Tuning

Part5 Conclusion

Chapter 12: Future Directions

References

Appendix

Errata

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

Prerequisite reading

Computer Science Basics

Explore MySQL: A Beginner’s Journey into Database Internals

MySQL Uncovered: Internals, Trace Analysis, and Performance

PostgreSQL Uncovered: Internals, Trace Analysis, and Performance

Architecture of a Database System

Access the Book on GitHub Pages

Online URL

Support

If you find this project helpful, consider donating:
Donate

Copyright © wangbin579 2025. All rights reserved.

Contributors

Showing top 1 contributor by commit count.

wangbin579

wangbin579

82 commits

View all contributors on GitHub →

This article is auto-generated from enhancedformysql/The-Art-of-Problem-Solving-in-Software-Engineering_How-to-Make-MySQL-Better via the GitHub API.Last fetched: 6/17/2026