Python database and cache (46 questions)

1 Enumerate the common relational databases and non-relational types have those?
2 MySQL common database engine and comparison?
3 summarize the three paradigms of data?
4 What is a transaction? How does MySQL support transactions?
5 describe a one-to-many and many-to-many application scenarios in database design?
6 How to implement the mall commodity counter based on the database?
7 Common SQL (required)

See Wu Jianzi Blog: https://www.cnblogs.com/wupeiqi/articles/5729934.html
8 describe triggers, functions, views, stored procedures?
9 MySQL Index kind
10 Under what circumstances does the index follow the rule with the leftmost prefix?
11 What is the difference between a primary key and a foreign key?
What are the common functions of MySQL?
13 lists 8 scenarios in which indexes are created but not hit.
14 How do I turn on slow log queries?
15 Database Import and Export command (structure + data)?
16 Database optimization scheme?
What is the difference between char and varchar?
18 brief description of MySQL execution plan?
19 under the unique index of name, the following differences are outlined:

1000w data, when using limit offset paging, why the more backward over the slow? How to solve?
21 What is an index merge?
22 What is an overlay index?
23 Brief description of database read/write separation?
24 brief description of database sub-Library sub-table? (Horizontal, vertical)
What is the comparison between Redis and memcached?
How many DB and function does the database default in Redis?
Python Operation Redis module?
28 if the amount of data in a list in Redis is very large, what if the implementation loops through each of the values?
How does Redis implement master-slave replication? and the data synchronization mechanism?
What is the role of Sentinel in Redis?
31 How do I implement a Redis cluster?
How many hash slots are there by default in Redis?
33 What are some of the persistence strategies and comparisons of Redis?
34 lists the expiration policies supported by Redis.
MySQL has 2000w data, Redis only 20w of data, how to ensure that Redis is hot data?
36 Write code, the Redis-based list implements the FIFO, LIFO, priority queue.
37 How do I implement Message Queuing based on Redis?
38 How can I implement publishing and subscriptions based on Redis? And the difference between a publish subscription and a message queue?
39 What is Codis and function?
40 What is twemproxy and function?
41 write code to implement Redis transactional operations.
What is the function of the Watch command in Redis?
43 How can I implement the mall commodity quantity counter based on Redis?
44 The implementation mechanism of Redis distributed lock and Redlock is briefly introduced.
45 What is a consistent hash? Is there a corresponding module in Python?
46 How to efficiently find all the keys in Redis that start with Oldboy?

Python database and cache (46 questions)