Programming VIP

prefaceThe memdb module in leveldb uses skiplist as a kv memory storage, and the related code implementation is very beautiful. The following is described above:Compare the implementation of query, insert and delete in c + + and golangAnalyze the places in the golang version that can be optimized, and then optimize the t rust versionThen in thi ...

1, Optimize index 1. Not indexed 2. The index is not effective //explain check index usage explain select * from `tb_order` where code='002'; Reason for index failure 3. Wrong index For the same sql, only the input parameters are different. Sometimes it's index a, but sometimes it's index b? This is because mysql will select the wrong ...

I believe that friends with development experience have encountered such a demand. Suppose you are developing a comment function for a news website. Readers can comment on the original text and even reply to each other. This demand is not simple. Replying to each other will lead to infinite branches and infinite ancestor offspring relationship ...

There are many special symbols in MySQL that are quite disgusting. For example, there are single quotation marks ('), double quotation marks ("), backslashes (\) and so on in the string. Students can make up for the possible problems first? In our usual SQL operations, if you don't pay attention to these symbols, you will be given a pot o ...

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer itProblem descriptionThe problem comes from a group friend. In short, he uses mysqlbinlog tool to read binlog for recovery, but finds that the ...

Do you want to accurately find the MySQL articles you want to read? Here → MySQL column directory | click here    MySQL row column conversion must be familiar or even impressive to students who often process data, because it probably bothers you and makes you stunned ~ but when you see this article, this problem is no longer ...

Hello, guys. The last article - "look at my one code pass [series] from a technical perspective" simply analyzed the website information contained in the two-dimensional code after scanning one code pass. Today we continue. This article is mainly to pave the way for the in-depth explanation of cache in the next issue and prepare ...

1. Concept of lock We have learned about multithreading before. How to ensure the accuracy of data in multithreading? Yes, through synchronization. Synchronization is equivalent to locking. What are the benefits of locking? When a thread is really manipulating data, other threads can only wait. When a thread finishes executing, release the lo ...

MongoDB is used in recent projects, so I probably learned the basic operation. Please forgive me for the bad writing. For more details, please go to the official website: https://docs.mongodb.com/manual/aggregation/ 1,$type 1.1 description The     $type operator retrieves the matching data types in the collection based on ...

1, Introduction As we all know, database connection usually uses JDBC to connect to the database, but what does pool mean? There are many kinds of pools, such as database connection pool, object pool, memory pool, thread pool, etc. For example, the [object pool] object pool can be regarded as a container for saving objects, and a certain num ...