What are the common relational databases and non-relational types?
MySQL common database engine and comparison?
Describe the three main paradigms of data?
What is a transaction? How does MySQL support transactions?
Describe a one-to-many and many-to-many application scenarios in database design?
How to implement mall commodity counter based on database?
Common SQL (required)
Describe triggers, functions, views, stored procedures?
MySQL index type
Under what circumstances does the index follow the rule with the leftmost prefix?
What is the difference between a primary key and a foreign key?
What are the common functions of MySQL?
Lists 8 scenarios in which indexes are created but not hit.
How do I turn on slow log queries?
Database Import Export Command (structure + data)?
Database optimization scheme?
What is the difference between char and varchar?
Brief description of MySQL execution plan?
Under the unique index of name, the following differences are outlined:?
Select from TB where name = ' Oldboy-wupeiqi '?
Select from TB where name = ' Oldboy-wupeiqi ' limit 1
1000w data, when using limit offset paging, why the more backward climb slow? How to solve?
What is an index merge?
What is an overlay index?
Brief description of database read/write separation?
A brief description of database sub-Library sub-table? (Horizontal, vertical)
Redis and memcached comparison?
How many DB and function does the database default in Redis?
Python operating module for Redis?
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?
How do I implement a Redis cluster?
How many hash slots are default in Redis?
What are some of the persistence strategies and comparisons of Redis?
Lists the expiration policies supported by Redis.
MySQL has 2000w data, only 20w of data in Redis, how to ensure that Redis is hot data?
Write code to implement FIFO, LIFO, and priority queues based on the Redis list.
How do I implement Message Queuing based on Redis?
How do I implement publishing and subscriptions based on Redis? And the difference between a publish subscription and a message queue?
What is Codis and function?
What is twemproxy and function?
Write code to implement Redis transactional operations.
What is the function of the Watch command in Redis?
How can I implement the mall commodity quantity counter based on Redis?
The implementation mechanism of Redis distributed lock and Redlock is briefly introduced.
What is a consistent hash? Is there a corresponding module in Python?
How to efficiently find all keys in Redis that start with Oldboy?
Database of Python face questions 46 ask to share
