A brief introduction to SQL process analysis in MySQL

Analyze the entire flow of this statement in MySQL

Update Set C1=where c2=xxx

A friend test me a question here to list personal Insights

1 Client connections come in first for permission verification

2 authentication passed into SQL interface after receiving user's SQL command

3 SQL commands to the interpreter for validation and parsing

4 after parsing the query optimizer optimizes the query to produce the final query results

5 If the result of the query is retrieved directly from the cache in the cache, it is returned to the client

6 if not, the API interface that calls the storage engine gets returned to the client from the file system, and is written to the cache

MySQL system results reference diagram

A brief introduction to SQL process analysis in MySQL