1-1 Tuning SQL statements based on execution plans

1-2 Basic principles of indexing: block reading and disk read-ahead

1-3 index data structure

1-4 B-tree and B+ tree

1-5 Some frequently asked interview questions about MySQL index

1-6 Return to table, index coverage, leftmost match

1-7 Online tuning

1-8 What should I do if the index fails?

1-9 Share some of my daily tips for learning and improvement

1-10 Four characteristics of mysql transactions

1-11 Random reading and writing vs. sequential reading and writing

1-12 What is the use of redolog&binlog?

1-13 Multi-version concurrency control-MVCC

1-14 MVCC-hidden fields, undolog

1-15 MVCC-readview

1-16 What is the nature of the phantom reading problem? How to deal with it?

1-17 mysql master-slave replication delay problem

1-18 Reasons for master-slave replication

1-19 Reasons for master-slave replication-2

1-20 MTS

1-21 How to solve the master-slave replication delay problem

1-22 What is the use of GTID?

1-23 mysql group submission and double 1 operation

1-24 Completely solve the mysql master-slave replication problem

2-1 What is ACID guaranteed by?

2-2 How to read mysql execution plan

2-3 What is MVCC

2-4 What is the implementation principle of MVCC?

2-5 What problem does MVCC solve?

2-6 What are the mysql index structures and what are their advantages and disadvantages?

2-7 What are the isolation levels of mysql?

2-8 What is the principle of mysql replication?

2-9 Basic principles of mysql index

2-10 Briefly describe the index types in mysql and their impact on database performance

2-11 The difference between mysql clustered index and non-clustered index

2-12 What are the design principles of indexes?

2-13 How to deal with slow queries in mysql

2-14 What are the basic characteristics of transactions

2-15 What are the types of mysql locks?

2-16 Why does mysql need master-slave synchronization?

2-17 What is mysql master-slave replication

3-1 What is Redis?

3-2 Tips for defeating the interviewer in redis interview

3-3 redis value type

3-4 Application of redis in flash sale scenario

3-5 IO threads

3-6 How to use redis

3-7 redis avalanche, penetration, breakdown, preheating

3-8 Database consistency & AOF persistence mechanism

3-9 What to do if redis hangs up

3-10 Architecture design from a redis perspective

3-11 What is a lock? Analysis of lock upgrade process

3-12 Single machine lock distributed lock technology selection

3-13 Redis cluster solves single point of failure problem

3-14 CAP theorem

3-15 What should I do if the client hangs up?

3-16 redis application scenarios

4-1 Tell me about the application scenarios of redis in your project

4-2 Is redis single-threaded or multi-threaded?

4-3 Does redis have thread safety issues?

4-4 Have you ever encountered cache penetration?

4-5 Have you ever experienced cache penetration?

4-6 How to avoid cache avalanches

4-7 Caching after-class answers

4-8 How redis deletes expired keys (how the cache is recycled)

4-9 How cache is eliminated

4-10 How to warm up cache

4-11 How to solve the inconsistency between database and cache

4-12 Briefly describe the problem of master-slave inconsistency

4-13 Describe the way redis persists

4-14 Describe the persistence principle

4-15 Why use setnx (redis instruction to implement distributed lock)