Redis+MySQL database interview tutorial
Redis is the most widely used storage middleware in the field of Internet technology. The understanding and application practice of Redis have become essential skills for mid-to-senior back-end developers today. MySQL is the preferred relational database for most Internet companies. Therefore, programmers cannot only understand the addition, deletion, modification, and query of the database and some simple usage skills. They also need to be proficient in some principles of MySQL to better deal with the problems encountered in actual work.
81045
person learning
72
class hour
2022-11-24
update time
16 Hours20 minutes21 seconds
Total course duration
有朋自远方来，虽远必诛！
You will learn
Redis is the most widely used storage middleware in the field of Internet technology. The understanding and application practice of Redis have become essential skills for mid-to-senior back-end developers today. MySQL is the preferred relational database for most Internet companies. Therefore, programmers cannot only understand the addition, deletion, modification, and query of the database and some simple usage skills. They also need to be proficient in some principles of MySQL to better deal with the problems encountered in actual work.
Redis+MySQL database interview tutorial
Section1 Tuning SQL statements based on execution plans
14 minutes37 seconds
Section2 Basic principles of indexing: block reading and disk read-ahead
15 minutes22 seconds
Section3 index data structure
18 minutes16 seconds
Section4 B-tree and B+ tree
25 minutes25 seconds
Section5 Some frequently asked interview questions about MySQL index
07 minutes30 seconds
Section6 Return to table, index coverage, leftmost match
10 minutes13 seconds
Section7 Online tuning
15 minutes33 seconds
Section8 What should I do if the index fails?
11 minutes34 seconds
Section9 Share some of my daily tips for learning and improvement
13 minutes51 seconds
Section10 Four characteristics of mysql transactions
13 minutes56 seconds
Section11 Random reading and writing vs. sequential reading and writing
12 minutes26 seconds
Section12 What is the use of redolog&binlog?
10 minutes46 seconds
Section13 Multi-version concurrency control-MVCC
13 minutes30 seconds
Section14 MVCC-hidden fields, undolog
15 minutes39 seconds
Section15 MVCC-readview
20 minutes47 seconds
Section16 What is the nature of the phantom reading problem? How to deal with it?
01 Hours01 minutes11 seconds
Section17 mysql master-slave replication delay problem
12 minutes19 seconds
Section18 Reasons for master-slave replication
11 minutes57 seconds
Section19 Reasons for master-slave replication-2
14 minutes57 seconds
Section20 MTS
12 minutes03 seconds
Section21 How to solve the master-slave replication delay problem
17 minutes15 seconds
Section22 What is the use of GTID?
14 minutes20 seconds
Section23 mysql group submission and double 1 operation
12 minutes42 seconds
Section24 Completely solve the mysql master-slave replication problem
25 minutes53 seconds
Chapter1 MySQL
Section1 What is ACID guaranteed by?
04 minutes21 seconds
Section2 How to read mysql execution plan
06 minutes40 seconds
Section3 What is MVCC
05 minutes31 seconds
Section4 What is the implementation principle of MVCC?
11 minutes56 seconds
Section5 What problem does MVCC solve?
04 minutes33 seconds
Section6 What are the mysql index structures and what are their advantages and disadvantages?
05 minutes22 seconds
Section7 What are the isolation levels of mysql?
07 minutes09 seconds
Section8 What is the principle of mysql replication?
05 minutes49 seconds
Section9 Basic principles of mysql index
06 minutes34 seconds
Section10 Briefly describe the index types in mysql and their impact on database performance
06 minutes18 seconds
Section11 The difference between mysql clustered index and non-clustered index
04 minutes49 seconds
Section12 What are the design principles of indexes?
06 minutes01 seconds
Section13 How to deal with slow queries in mysql
03 minutes27 seconds
Section14 What are the basic characteristics of transactions
05 minutes54 seconds
Section15 What are the types of mysql locks?
09 minutes18 seconds
Section16 Why does mysql need master-slave synchronization?
04 minutes49 seconds
Section17 What is mysql master-slave replication
02 minutes19 seconds
Chapter2 MySQL interview questions
Section1 What is Redis?
13 minutes43 seconds
Section2 Tips for defeating the interviewer in redis interview
16 minutes05 seconds
Section3 redis value type
13 minutes02 seconds
Section4 Application of redis in flash sale scenario
18 minutes07 seconds
Section5 IO threads
17 minutes16 seconds
Section6 How to use redis
19 minutes54 seconds
Section7 redis avalanche, penetration, breakdown, preheating
18 minutes51 seconds
Section8 Database consistency & AOF persistence mechanism
15 minutes03 seconds
Section9 What to do if redis hangs up
01 Hours02 minutes54 seconds
Section10 Architecture design from a redis perspective
10 minutes25 seconds
Section11 What is a lock? Analysis of lock upgrade process
25 minutes41 seconds
Section12 Single machine lock distributed lock technology selection
23 minutes22 seconds
Section13 Redis cluster solves single point of failure problem
12 minutes30 seconds
Section14 CAP theorem
16 minutes06 seconds
Section15 What should I do if the client hangs up?
08 minutes09 seconds
Section16 redis application scenarios
51 minutes48 seconds
Chapter3 Redis
Section1 Tell me about the application scenarios of redis in your project
06 minutes49 seconds
Section2 Is redis single-threaded or multi-threaded?
31 minutes50 seconds
Section3 Does redis have thread safety issues?
02 minutes05 seconds
Section4 Have you ever encountered cache penetration?
13 minutes37 seconds
Section5 Have you ever experienced cache penetration?
11 minutes26 seconds
Section6 How to avoid cache avalanches
17 minutes49 seconds
Section7 Caching after-class answers
03 minutes20 seconds
Section8 How redis deletes expired keys (how the cache is recycled)
03 minutes50 seconds
Section9 How cache is eliminated
02 minutes01 seconds
Section10 How to warm up cache
05 minutes40 seconds
Section11 How to solve the inconsistency between database and cache
23 minutes47 seconds
Section12 Briefly describe the problem of master-slave inconsistency
03 minutes17 seconds
Section13 Describe the way redis persists
05 minutes00 seconds
Section14 Describe the persistence principle
01 minutes27 seconds
Section15 Why use setnx (redis instruction to implement distributed lock)
02 minutes35 seconds
Chapter4 Redis interview questions
Data Name
The courseware is currently not available for download, and the staff are organizing it. Please pay more attention to this course in the future~
王林 Lecturer Other Courses
Popular courses
JAVA Beginner's Video Tutorial
753 class hour
2982563
Little Turtle's zero-based introduction to learning Python video tutorial
60 class hour
546669
Quick introduction to web front-end development
8 class hour
220790
Master PS video tutorials from scratch
268 class hour
1003302
Latest courses
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
[Web front-end] Node.js quick start
16 class hour
16696
Complete collection of foreign web development full-stack courses
12 class hour
13480
Go language practical GraphQL
10 class hour
11115
550W fan master learns JavaScript from scratch step by step
1 class hour
1264
