Redis+MySQL database interview tutorial

• Chapter1 MySQL
• 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
• Chapter2 MySQL interview questions
• 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
• Chapter3 Redis
• 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
• Chapter4 Redis interview questions
• 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)