2023/04/02 1:39
- What are the database isolation levels, what are their meanings, what is the default isolation level of MYsql, and the advantages and disadvantages of each storage engine
- Under high concurrency, how to safely modify the same row of data, what are optimistic locks and pessimistic locks, what are the 2 types of row-level locks in INNODB, and explain their meaning
- SQL What are the general steps of optimization, how to see the execution plan, how to understand the meaning of each field, and the principle of indexing?
- Other performance optimizations for MySQL
- Will the database deadlock, for example, how does mySQL solve deadlocks
- MYsql’s index implementation
- Differences between clustered and nonclustered indexes
- The difference between BTREE and B+tree in the database
- How mybatis implements bulk insertion
- Please succinctly describe the four transaction isolation level names supported by InnoDB in MySQL, and the difference between the levels?
- How are indexes designed?