[learning record of MySQL principle and source code] morning reading meeting of XRS online school — continuously updated

Time:2021-8-6

Important note

The service end morning reading meeting of XRS online school will open a free open class in Sifu and upload a series of sharing videos of the morning reading meeting tohttps://ke.sifou.com/course/1650000023669742, we can learn and communicate together~

Completely open, completely open, completely open. Welcome to exchange and learn together and grow at a high speed on the shoulders of giants (thank you, senior gods ~)~

  • The theme of the second stage is [current]

The second stage – MySQL source code exploration

  • The theme of the first stage is

[MySQL principle and practice] explore the underlying principle and Implementation Based on the MySQL 45 lecture of geek time

Course materials

Note: the courseware ppt data needs to be uploaded after some processing, and the video can be accessed directlyhttps://ke.sifou.com/course/1…Watch~

Phase II course materials [source code interpretation]

Course name lecturer Courseware address remarks
[MySQL principle and practice] 08-21 - Zhao Yu - MySQL lexical analysis Zhao Yu Link:https://pan.baidu.com/s/1F5kT…Extraction code: 5rm4
[MySQL principle and practice] 08-25-chen Chaofei MySQL syntax analysis Chao Fei Chen Link:https://pan.baidu.com/s/1yRcS…Extraction code: 2jqy
[MySQL principle and practice] 08-26 Zhao Yu MySQL communication protocol and query Zhao Yu Link:https://pan.baidu.com/s/1R1xh…Extraction code: 3dyv
[MySQL principle and practice] 08-28-chen Lei - MySQL executor Chen Lei Link:https://pan.baidu.com/s/11WiC…Extraction code: 78k9
[principle and practice of MySQL] exploration on the implementation principle of 08-31-hu yi-update statement Hu Yi Link:https://pan.baidu.com/s/1wteI…Extraction code: wuxa
[MySQL principle and practice] exploration on the implementation principle of 09-01-jingluo-delete statement (Part I) Jingluo Link:https://pan.baidu.com/s/1vtWm…Extraction code: ju59
[principle and practice of MySQL] exploration on the implementation principle of 09-02-jingluo-delete statement (Part 2) Jingluo Link:https://pan.baidu.com/s/1vtWm…Extraction code: ju59
[MySQL principle and practice] 09-04-li le-select statement implementation principle exploration Li le No data available
[MySQL principle and practice] 09-07-tian Zhize - locking a single line of records Tian Zhize Link:https://pan.baidu.com/s/1rU_U…Extraction code: bfkw
[principle and practice of MySQL] 09-08 - Jingluo - people who explore the source code find his line of records Jingluo Link:https://pan.baidu.com/s/1_fF2…Extraction code: g6rr
[MySQL principle and practice] 09-10 Shi Hongbao next key lock locking analysis Shi Hongbao No data available
[MySQL principle and practice] 09-14 - Liu Zhiqiang - Analysis of MySQL insert locking process Liu Zhiqiang Link:https://pan.baidu.com/s/1ak02…Extraction code: fx3w
[MySQL principle and practice] 09-15 Cui Guangwei lock analysis of a simple SQL in MySQL Cui Guangwei Link:https://pan.baidu.com/s/10UKm…Extraction code: 72tm
[MySQL principle and practice] 09-17-han Donghui mvcc visibility implementation of current reading Han Donghui Link:https://pan.baidu.com/s/1Kr-f…Extraction code: igrd
[principle and practice of MySQL] 09-18 - Li le - Implementation of two-stage submission of transactions Li le Link:https://pan.baidu.com/s/1SHaz…Extraction code: i1ze
[MySQL principle and practice] 09-22 - text cloud - implementation comparison of transactions under different isolation levels Wen Benyun http://note.youdao.com/s/bFZorCsr
[principle and practice of MySQL] 09-24-han Wenjie implementation in mvcc memory Han Wenjie http://note.youdao.com/s/UXND0XUd http://note.youdao.com/s/UqfB6sqP http://note.youdao.com/s/2Ch02vNs
[principle and practice of MySQL] 09-25-li Zongyuan visibility implementation of mvcc consistent reading Li Zongyuan https://www.zybuluo.com/lixiang9194/note/1744672
[MySQL principle and practice] 09-28 - Guo Zhaoran - Implementation of data recording of MySQL source code Guo Zhaoran Update after finishing
[principle and practice of MySQL] 09-29 - Jingluo - Implementation of row record chain and groupby Jingluo Link:https://pan.baidu.com/s/1lNel…Extraction code: 9yg3
[principle and practice of MySQL] 10-21 - Zhao Yu - "establishment of master-slave relationship" in the implementation of row based replication Zhao Yu https://mp.weixin.qq.com/s/Bl…
[principle and practice of MySQL] 10-22-qin riqiang data directory and storage implementation of MySQL Qin riqiang Link:https://pan.baidu.com/s/13gzT…Extraction code: 4q5e
[principle and practice of MySQL] 10-26 - Zhao Yu - Implementation of "master-slave replication" based on row replication Zhao Yu https://mp.weixin.qq.com/s/0z…
[MySQL principle and practice] 10-29-chen Lei several optimization items of MySQL optimizer Chen Lei Link:https://pan.baidu.com/s/19F1y…Extraction code: j9ix
[principle and practice of MySQL] 11-02 - Jingluo - Primary Discussion on the bottom implementation of aggregate function Jingluo Link:https://pan.baidu.com/s/1X5zo…Extraction code: mcna
[MySQL principle and practice] 11-03 Hu Yi MySQL source code exploration and implementation of explain Hu Yi Link:https://pan.baidu.com/s/1bfJm…Extraction code: vjk8
[MySQL principle and practice] 11-04 Jingluo MySQL source code groupby implementation exploration Jingluo Link:https://pan.baidu.com/s/1hGrZ…Extraction code: 8qhd

Phase I course materials [principle and source code exploration]

Course name lecturer Courseware address remarks
[MySQL principle and practice] 06-11-jingluo - how to execute an SQL query statement Jingluo Link:https://pan.baidu.com/s/1Zofy…Extraction code: 84w6
[principle and practice of MySQL] 06-15 - ning Liang & Jing Luo - transaction isolation: why can't I see it after you change it Ning Liang, Jingluo Link:https://pan.baidu.com/s/1G9Au…Extraction code: rhqp
[principle and practice of MySQL] 06-16 - panson - easy to understand index pantheon Link:https://pan.baidu.com/s/13t7r…Extraction code: 4xsp
[principle and practice of MySQL] 06-19 - Liu Zhiqiang - merits and demerits of row lock: how to reduce the impact of row lock on performance Liu Zhiqiang Link:https://pan.baidu.com/s/1QxIH…Extraction code: 9fvh
[principle and practice of MySQL] 06-23-chen Lei - how to choose a common index and a unique index Chen Lei Link:https://pan.baidu.com/s/1mDfG…Extraction code: d1h2
[MySQL principle and practice] 06-24 - Zhao Yu - why MySQL sometimes chooses the wrong index Zhao Yu Link:https://pan.baidu.com/s/1jr4U…Extraction code: 4gsy
[principle and practice of MySQL] 07-01-huangtao-count( ×) What should I do so slowly Yellow peach Link:https://pan.baidu.com/s/1HwDn…Extraction code: anw6
[MySQL principle and practice] 07-06-li le - how to correctly display random messages Li le Link:https://pan.baidu.com/s/11dsu…Extraction code: sd3h
[MySQL principle and practice] 07-09 - Hu Yi - what is unreal reading and what is the problem with unreal reading Hu Yi Link:https://pan.baidu.com/s/1kqQM…Extraction code: ttzm
[MySQL principle and practice] 07-10 - Jingluo - why are there so many locks when only one line of statements is changed Jingluo Link:https://pan.baidu.com/s/1iCfs…Extraction code: e4i9
[MySQL principle and practice] 07-15 Jingluo MySQL lock rambling -- GDB debugging and locking process Jingluo Link:https://pan.baidu.com/s/1iCfs…Extraction code: e4i9
[MySQL principle and practice] 07-16-qin riqiang - how does MySQL ensure high availability Qin riqiang Link:https://pan.baidu.com/s/1k8um…Extraction code: v8ic
[MySQL principle and practice] 07-22 - Shi Hongbao - what are the pitfalls of read-write separation Shi Hongbao Link:https://pan.baidu.com/s/1a_JZ…Extraction code: n4jj
[MySQL principle and practice] 07-24 - Zhao Yu - Q & a article on locking from a dynamic point of view Zhao Yu Link:https://pan.baidu.com/s/1qwK4…Extraction code: 5i9v
[MySQL principle and practice] 07-30 - Jingluo - can I use join Jingluo Link:https://pan.baidu.com/s/1xswA…Extraction code: n7in
[principle and practice of MySQL] 08-03-jingluo-exploration on the implementation of count bottom layer in MySQL Jingluo Link:https://pan.baidu.com/s/1UFD5…Extraction code: uwwc
[principle and practice of MySQL] 08-04-cui Guangwei how to optimize the join statement Cui Guangwei Link:https://pan.baidu.com/s/13Krs…Extraction code: mv98
[principle and practice of MySQL] 08-05 - Guo Zhaoran - why can temporary tables have multiple names Guo Zhaoran Link:https://pan.baidu.com/s/1U9Q7…Extraction code: h6sa
[principle and practice of MySQL] 08-06-li le - when will internal temporary tables be used Li le Link:https://pan.baidu.com/s/1cctA…Extraction code: 7imj
[MySQL principle and practice] Why are there so many locks in 08-10-hu yi-insert statement Hu Yi Link:https://pan.baidu.com/s/1_t-V…Extraction code: xn8g
[principle and practice of MySQL] 08-18-jingluo - answer questions Jingluo Link:https://pan.baidu.com/s/107hV…Extraction code: gz9s
[principle and practice of MySQL] 08-19 - text cloud - self incrementing ID Wen Benyun Link:https://pan.baidu.com/s/1lmf8…Extraction code: ww9b

contact us

Lnmpr source code exchange wechat group, welcome to exchange and grow together~

[learning record of MySQL principle and source code] morning reading meeting of XRS online school -- continuously updated

Watch the wonderful video first

XRS online school morning reading meeting – Technology
08-06-li le – when will the internal temporary table be used

[\ [Click to view \]](https://v.youku.com/v_show/id…
[learning record of MySQL principle and source code] morning reading meeting of XRS online school -- continuously updated
[\ [Click to view \]](https://v.youku.com/v_show/id…

More videos are constantly updated

[MySQL principle and practice] July 6, 2020 – Li le – how to correctly display random messages

[MySQL principle and practice] August 3, 2020 – Exploration on the bottom implementation of select count (Col) in Jingluo MySQL

Recommended Today

The selector returned by ngrx store createselector performs one-step debugging of fetching logic

Test source code: import { Component } from ‘@angular/core’; import { createSelector } from ‘@ngrx/store’; export interface State { counter1: number; counter2: number; } export const selectCounter1 = (state: State) => state.counter1; export const selectCounter2 = (state: State) => state.counter2; export const selectTotal = createSelector( selectCounter1, selectCounter2, (counter1, counter2) => counter1 + counter2 ); // […]