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

• Chapter1 Database knowledge
• 1-1 Disk, memory, IO
• 1-2 Data storage development process
• 1-3 Database engine introduction
• Chapter2 Install redis
• 2-1 A brief introduction to redis
• 2-2 redis installation practice
• 2-3 Summary of redis installation practices
• Chapter3 redis use
• 3-1 Introduction to epoll
• 3-2 redis principle
• 3-3 Review of redis and NIO principles
• 3-4 redis use
• 3-5 value type in redis - string
• 3-6 value type in redis - numerical value
• 3-7 redis--binary security
• 3-8 Solving the problem of value type in redis
• 3-9 value type in redis--bitnmap
• 3-10 Value type in redis-bitmap example 1
• 3-11 Value type in redis-bitmap example 2
• 3-12 value type in redis--list
• 3-13 value type in redis--hash
• 3-14 value type in redis--set
• 3-15 Solving NIO problems in redis
• 3-16 value type in redis--sorted_set
• 3-17 value type in redis--skiplist
• 3-18 Why is redis so fast?
• 3-19 Why is X so fast?
• 3-20 Why is Redis transaction very transactional?
• 3-21 IO multi-threading working principle
• 3-22 Redis single thread demonstration
• 3-23 redis multi-thread demonstration
• Chapter4 Redis interview details
• 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 encountered cache penetration?
• 4-6 How to avoid cache avalanches
• 4-7 Caching after-class answers
• 4-8 How does redis delete expired keys (how to recycle them during caching)
• 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 Briefly describe the principle of persistence
• 4-15 Why use setnx (redis instruction to implement distributed lock)
• 4-16 redis persistence rdb and aof
• 4-17 Why is single-threaded redis fast? What are the thread models?
• 4-18 What are the deletion strategies for expired keys in redis?
• 4-19 How to recycle redis cache
• 4-20 What are the redis cluster solutions?
• 4-21 How redis transactions are implemented
• 4-22 The principle of redis master-slave replication
• 4-23 Breakdown, penetration, avalanche, preheating solutions
• Chapter5 mysql course
• 5-1 The implementation principle of mysql transaction isolation
• 5-2 Current read, snapshot read, what exactly is read?
• 5-3 How is the atomicity and persistence of mysql implemented?
• 5-4 MySQL's concurrent access core mechanism - MVCC detailed explanation
• 5-5 Analysis of the principles of shared locks, exclusive locks, intention locks, and self-increasing locks
• 5-6 mysql course Q&A
• 5-7 mysql server parameter setting 03_connection
• 5-8 mysql server parameter setting 04_log storage
• Chapter6 mysql interview
• 6-1 What is ACID guaranteed by?
• 6-2 What problem does MVCC solve?
• 6-3 What is the implementation principle of MVCC?
• 6-4 What is the principle of mysql replication?
• 6-5 The difference between mysql clustered index and non-clustered index
• 6-6 Basic principles of mysql index
• 6-7 What are the mysql index structures and what are their advantages and disadvantages?
• 6-8 What are the types of mysql locks?
• 6-9 Why does mysql need master-slave synchronization?
• 6-10 How to read mysql execution plan
• 6-11 What is MVCC
• 6-12 What is mysql master-slave replication
• 6-13 What are the design principles of indexes?
• 6-14 If fresh graduates want to find a job, what database knowledge do they need to master?
• 6-15 Programmer resume modification: create a perfect resume in minutes