MySQL 8.0.27 Review by adzfolc

Notifications

• In this doc, I will make the rules of my code review and period summary for later review.
• This chapter may cotain comprehensive summary of MySQL/Innodb/MGR.
• Review format
  1. My Code review would be written in source code in format of annonation.
  2. Some key annonations would be begined with __adzfolc__.
  3. Some questions,which make me confused, would be denoted with __adzfolc__ Q:
  4. Some optimizaton would be denoted with __adzfolc__ To Do: refractor.

Keypoint

1. Server
   1. Thread model
   2. MySQL Packet Decode
2. SQL
   1. Parser
   2. Optimizer
      1. SQL Plan
      2. SQL Optimizer
   3. Execution
3. InnoDB
   1. Transaction
      1. How ACID is implmented?
      2. GTID
      3. Locks
      4. Logs
         1. Undolog
         2. Redolog
   2. Binlog
4. Replication
   1. MGR
      1. Basic Paxos and Mutli Paxos
      2. Multi Paxos and Mencius
      3. How Mencius is implemented in MGR
5. Storage
   1. B+ Tree

Notes

• 00_Summary
  00_summary

• 01_Server
  00_server_mmary
  01_thread_model
  02_memory_management
  03_mysqld_main
  04_connection_lifecycle

• 02_sql
  00_sql_parser_and_optimizer

• 03_storage
  00_storage_layer_intro
  01_mysql_meta_data

  • 01_InnoDB
    00_sumary
    01_buffer
    02_file
    04_table
    05_index_and_algo
    06_lock_latch_and_trx
    07_data_dict
    08_innodb_storage_structure
    09_innodb_record_format
    10_innodb_double_write

• 99_QA
  99_QA

Expandsion

• Based on tourtial, I implement a storage engine called Casablanca.Source code path is storage/casablanca.

• 基于教程,我实现了名为 Casablanca 的存储引擎.代码路径在 storage/casablanca.

• Ability

  • CRUD
  • Index

• To Do:

  • 优化索引结构

• Casablanca is still under construction.

Reading

1. MySQL核心内幕
   1. Chp 7 查询解析与优化器
   2. Chp 8 安全管理系统
   3. P230
2. MySQL技术内幕-InnoDB存储引擎 P330
3. MySQL 8.0 Reference Manual P3033
4. MySQL 运维内参 P160 InnoDB 记录格式

Recommend Materials