Name: Database principles and applications [one set for all database interviews]
Uploaded: 2022-05-12T16:32:52+8:00
Duration: 1201 min 29 s

Chapter1Database knowledge: Disk, memory, IO
05 minutes14 seconds; Data storage development process
18 minutes49 seconds; Database engine introduction
08 minutes30 seconds
Chapter2Install redis: A brief introduction to redis
15 minutes06 seconds; redis installation practice
26 minutes30 seconds; Summary of redis installation practices
11 minutes36 seconds
Chapter3redis use: Introduction to epoll
30 minutes39 seconds; redis principle
05 minutes36 seconds; Review of redis and NIO principles
13 minutes01 seconds; redis use
15 minutes29 seconds; value type in redis - string
09 minutes02 seconds; value type in redis - numerical value
16 minutes12 seconds; redis--binary security
12 minutes01 seconds; Solving the problem of value type in redis
17 minutes41 seconds; value type in redis--bitnmap
21 minutes07 seconds; Value type in redis-bitmap example 1
10 minutes55 seconds; Value type in redis-bitmap example 2
12 minutes10 seconds; value type in redis--list
27 minutes30 seconds; value type in redis--hash
12 minutes33 seconds; value type in redis--set
27 minutes20 seconds; Solving NIO problems in redis
02 minutes47 seconds; value type in redis--sorted_set
30 minutes51 seconds; value type in redis--skiplist
17 minutes46 seconds; Why is redis so fast?
18 minutes27 seconds; Why is X so fast?
11 minutes06 seconds; Why is Redis transaction very transactional?
17 minutes00 seconds; IO multi-threading working principle
23 minutes01 seconds; Redis single thread demonstration
19 minutes14 seconds; redis multi-thread demonstration
01 Hours33 minutes05 seconds
Chapter4Redis interview details: Tell me about the application scenarios of redis in your project
06 minutes49 seconds; Is redis single-threaded or multi-threaded?
31 minutes50 seconds; Does redis have thread safety issues?
02 minutes05 seconds; Have you ever encountered cache penetration?
13 minutes37 seconds; Have you ever encountered cache penetration?
11 minutes26 seconds; How to avoid cache avalanches
17 minutes49 seconds; Caching after-class answers
03 minutes20 seconds; How does redis delete expired keys (how to recycle them during caching)
03 minutes50 seconds; How cache is eliminated
02 minutes01 seconds; How to warm up cache
05 minutes40 seconds; How to solve the inconsistency between database and cache
23 minutes47 seconds; Briefly describe the problem of master-slave inconsistency
03 minutes17 seconds; Describe the way redis persists
05 minutes00 seconds; Briefly describe the principle of persistence
01 minutes27 seconds; Why use setnx (redis instruction to implement distributed lock)
02 minutes35 seconds; redis persistence rdb and aof
16 minutes41 seconds; Why is single-threaded redis fast? What are the thread models?
07 minutes22 seconds; What are the deletion strategies for expired keys in redis?
07 minutes58 seconds; How to recycle redis cache
04 minutes52 seconds; What are the redis cluster solutions?
07 minutes34 seconds; How redis transactions are implemented
06 minutes29 seconds; The principle of redis master-slave replication
10 minutes44 seconds; Breakdown, penetration, avalanche, preheating solutions
05 minutes23 seconds
Chapter5mysql course: The implementation principle of mysql transaction isolation
09 minutes30 seconds; Current read, snapshot read, what exactly is read?
08 minutes46 seconds; How is the atomicity and persistence of mysql implemented?
23 minutes30 seconds; MySQL's concurrent access core mechanism - MVCC detailed explanation
41 minutes36 seconds; Analysis of the principles of shared locks, exclusive locks, intention locks, and self-increasing locks
24 minutes13 seconds; mysql course Q&A
01 Hours18 minutes15 seconds; mysql server parameter setting 03_connection
15 minutes15 seconds; mysql server parameter setting 04_log storage
08 minutes02 seconds
Chapter6mysql interview: What is ACID guaranteed by?
04 minutes21 seconds; What problem does MVCC solve?
04 minutes33 seconds; What is the implementation principle of MVCC?
11 minutes56 seconds; What is the principle of mysql replication?
05 minutes49 seconds; The difference between mysql clustered index and non-clustered index
04 minutes49 seconds; Basic principles of mysql index
06 minutes34 seconds; What are the mysql index structures and what are their advantages and disadvantages?
05 minutes22 seconds; What are the types of mysql locks?
09 minutes18 seconds; Why does mysql need master-slave synchronization?
04 minutes49 seconds; How to read mysql execution plan
06 minutes40 seconds; What is MVCC
05 minutes31 seconds; What is mysql master-slave replication
02 minutes19 seconds; What are the design principles of indexes?
06 minutes01 seconds; If fresh graduates want to find a job, what database knowledge do they need to master?
40 minutes24 seconds; Programmer resume modification: create a perfect resume in minutes
02 Hours02 minutes02 seconds

部分浏览器不支持，请下载APP观看

Next Section： mysql为什么需要主从同步2482 plays

Database principles and applications [one set for all database interviews]

部分浏览器不支持，请下载APP观看

Next Section： mysql为什么需要主从同步2482 plays

Database principles and applications [one set for all database interviews]

Allpost a note