MySQL Database Guide

This is an opinionated guide for MySQL database knowledge, written by Yunpeng Niu.

45 Lessons on MySQL

My notes about the 45 lessons on MySQL:

• 0. Introduction
• 1. Execution of a select query
• 2. Execution of an update query
• 3. Isolation
• 4. Introduction
• 5. Index
• 6. Lock
• 7. Lock
• 8. MVCC
• 9. Unique Key
• 10. Choose an Index
• 11. Index on a VARCHAR column
• 12. Spike
• 13. Size of a Table File
• 14. Why is COUNT * slow
• 16. How does ORDER BY work
• 17. Random select

30 Lessons on Distributed DB

My notes about the 30 lessons on distributed DB:

• 0. Introduction

Licence

GNU General Public Licence 3.0