Tuning SQL statements based on execution plans
14 minutes37 secondsBasic principles of indexing: block reading and disk read-ahead
15 minutes22 secondsindex data structure
18 minutes16 secondsB-tree and B+ tree
25 minutes25 secondsSome frequently asked interview questions about MySQL index
07 minutes30 secondsReturn to table, index coverage, leftmost match
10 minutes13 secondsOnline tuning
15 minutes33 secondsWhat should I do if the index fails?
11 minutes34 secondsShare some of my daily tips for learning and improvement
13 minutes51 secondsFour characteristics of mysql transactions
13 minutes56 secondsRandom reading and writing vs. sequential reading and writing
12 minutes26 secondsWhat is the use of redolog&binlog?
10 minutes46 secondsMulti-version concurrency control-MVCC
13 minutes30 secondsMVCC-hidden fields, undolog
15 minutes39 secondsMVCC-readview
20 minutes47 secondsWhat is the nature of the phantom reading problem? How to deal with it?
01 Hours01 minutes11 secondsmysql master-slave replication delay problem
12 minutes19 secondsReasons for master-slave replication
11 minutes57 secondsReasons for master-slave replication-2
14 minutes57 secondsMTS
12 minutes03 secondsHow to solve the master-slave replication delay problem
17 minutes15 secondsWhat is the use of GTID?
14 minutes20 secondsmysql group submission and double 1 operation
12 minutes42 secondsCompletely solve the mysql master-slave replication problem
25 minutes53 secondsWhat is ACID guaranteed by?
04 minutes21 secondsHow to read mysql execution plan
06 minutes40 secondsWhat is MVCC
05 minutes31 secondsWhat is the implementation principle of MVCC?
11 minutes56 secondsWhat problem does MVCC solve?
04 minutes33 secondsWhat are the mysql index structures and what are their advantages and disadvantages?
05 minutes22 secondsWhat are the isolation levels of mysql?
07 minutes09 secondsWhat is the principle of mysql replication?
05 minutes49 secondsBasic principles of mysql index
06 minutes34 secondsBriefly describe the index types in mysql and their impact on database performance
06 minutes18 secondsThe difference between mysql clustered index and non-clustered index
04 minutes49 secondsWhat are the design principles of indexes?
06 minutes01 secondsHow to deal with slow queries in mysql
03 minutes27 secondsWhat are the basic characteristics of transactions
05 minutes54 secondsWhat are the types of mysql locks?
09 minutes18 secondsWhy does mysql need master-slave synchronization?
04 minutes49 secondsWhat is mysql master-slave replication
02 minutes19 secondsWhat is Redis?
13 minutes43 secondsTips for defeating the interviewer in redis interview
16 minutes05 secondsredis value type
13 minutes02 secondsApplication of redis in flash sale scenario
18 minutes07 secondsIO threads
17 minutes16 secondsHow to use redis
19 minutes54 secondsredis avalanche, penetration, breakdown, preheating
18 minutes51 secondsDatabase consistency & AOF persistence mechanism
15 minutes03 secondsWhat to do if redis hangs up
01 Hours02 minutes54 secondsArchitecture design from a redis perspective
10 minutes25 secondsWhat is a lock? Analysis of lock upgrade process
25 minutes41 secondsSingle machine lock distributed lock technology selection
23 minutes22 secondsRedis cluster solves single point of failure problem
12 minutes30 secondsCAP theorem
16 minutes06 secondsWhat should I do if the client hangs up?
08 minutes09 secondsredis application scenarios
51 minutes48 secondsTell me about the application scenarios of redis in your project
06 minutes49 secondsIs redis single-threaded or multi-threaded?
31 minutes50 secondsDoes redis have thread safety issues?
02 minutes05 secondsHave you ever encountered cache penetration?
13 minutes37 secondsHave you ever experienced cache penetration?
11 minutes26 secondsHow to avoid cache avalanches
17 minutes49 secondsCaching after-class answers
03 minutes20 secondsHow redis deletes expired keys (how the cache is recycled)
03 minutes50 secondsHow cache is eliminated
02 minutes01 secondsHow to warm up cache
05 minutes40 secondsHow to solve the inconsistency between database and cache
23 minutes47 secondsBriefly describe the problem of master-slave inconsistency
03 minutes17 secondsDescribe the way redis persists
05 minutes00 secondsDescribe the persistence principle
01 minutes27 secondsWhy use setnx (redis instruction to implement distributed lock)
02 minutes35 seconds