Article
Topic
Learning
Download
Q&A
Programming Dictionary
Game
Recent Updates
LOGIN
简体中文(ZH-CN)
English(EN)
繁体中文(ZH-TW)
日本語(JA)
한국어(KO)
Melayu(MS)
Français(FR)
Deutsch(DE)
Next Section: Does redis have thread safety issues?
(609 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
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)
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Intermediate
Front-end Vue3 actual combat [handwritten vue project]
2857 people are watching
Elementary
APIPOST tutorial [Popularization of technical concepts related to network communication]
1795 people are watching
Intermediate
Issue 22_Comprehensive actual combat
5521 people are watching
Elementary
Issue 22_PHP Programming
5172 people are watching
Elementary
Issue 22_Front-end development
8713 people are watching
Intermediate
Big data (MySQL) video tutorial full version
4525 people are watching
Elementary
Go language tutorial-full of practical information and no nonsense
2794 people are watching
Elementary
GO Language Core Programming Course
2814 people are watching
Intermediate
JS advanced and BootStrap learning
2563 people are watching
Intermediate
SQL optimization and troubleshooting (MySQL version)
3374 people are watching
Intermediate
Redis+MySQL database interview tutorial
2963 people are watching
Elementary
Deliver food or learn programming?
5708 people are watching
Students who have watched this course are also learning
491214 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X
About us
Disclaimer
Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!