Mysql source code learning notes peek thread _ MySQL

The Mysql source code learning notes peek at the thread bitsCN.com. the code is messy and comments are written randomly. it seems that there is no unified specification, and the code styles in different files are also different, maybe Mysql has gone through the hands of many cool people. It may also be because I have a relatively simple understanding, adapted to my own code style, and finally started my source code journey with reverence. I am a Cainiao.

Mysql can be started. how can I learn it? You can't start from main. Mysql, as a relatively low-level large-scale software, involves all aspects of database implementation. it does not have a solid theoretical foundation of the database and is quite familiar with Mysql modules, starting from main, we are bound to introduce ourselves into a dead end. we can't afford to worry about anything.

After thinking, I want to debug the server through the client to learn the server code. That is to say, through the action of the client, we can see the response of the server. For example, from the client login action to see how the SERVER communicates, user identification, authentication, and task allocation, through create table, let's look at how the SERVER parses DDL statements and uses different physical storage methods for different storage engines, and use INSERT statements to see how the SERVER performs Btree operations. Through the SELECT statement, we can see how to create and optimize the SQL statement syntax tree. through the ROLL BACK, we can see how the SERVER transaction is implemented. Here, we mainly learn the idea of Mysql database implementation through tracking the code, and do not conduct too many investigations on the specific code (I am not very familiar with C ++). I am good at reading and not understanding it, haha.
As a result, the following SQL statements have been prepared for SERVER analysis.

1. LOGIN)
Mysql.exe