Tag：Data Volume
-
Time：2022-1-2
The content discussed today is the separation of hot and cold. Perhaps the concept is not strange and familiar with its use scenarios, but we still need to think carefully about the content of lock. There are still many “pits” in our actual development. Business scenario I I have experienced architecture optimization related to the […]
-
Time：2021-12-28
Reference website:https://www.cnblogs.com/nickup/p/9758691.html Generally, the client queries the data in the database by passing two parameters, pageno (page number) and PageSize (number of entries per page). When the amount of data is small (tuple hundred / thousand), the client uses the data provided by mysqllimitTo solve this problem: Received client {pageno: 1, PageSize: 10}select * from […]
-
Time：2021-12-27
The snowflake algorithm has been mentioned earlier. It is used in itSystem.currentTimeMillis()Get time, there is a saying thatSystem.currentTimeMillis()It is slow because each call will deal with the system once. In the case of high concurrency, a large number of concurrent system calls are easy to affect the performance (calls to it are even slower than […]
-
Time：2021-12-25
At present, the magnitude of the message center is not very large. It looks like more than 200 W data every day, and the concurrency is dozens to 200. In fact, there may not be concurrency in a year or two. It is reasonable to divide the tables. However, we must consider the long-term point. […]
-
Time：2021-12-16
The text and pictures of this article come from the network, only for learning and communication, and do not have any commercial purpose. If you have any questions, please contact us in time for handling. New vision of programming | author Brief book | source Novices and Xiaobai who have just come into contact with […]
-
Time：2021-12-15
MySQL basic introductory statement Add: Insert into table name (fields 1, 2, 3) values (‘value 1 ‘,’ 2 ‘,’ 3 ‘) Delete: Delete from indicates where to delete the condition If no update condition is provided, all updates will be deleted Change: Update table name set field 1 = ‘new value’, field 2 = ‘new […]
-
Time：2021-12-10
No matter how much data is installed in a system, it does not interact with other systems. That is also an island system. It is lonely and has no girlfriend. If a system is very outgoing, constantly teasing the surrounding systems, and is willing to be teased, and becomes a “social flower” in many systems, […]
-
Time：2021-12-6
1、 Write at the beginning Vivo cloud service provides users with the ability to back up contacts, SMS, notes, bookmarks and other data on their mobile phones. The underlying storage adopts MySQL database for data storage. With the development of vivo cloud service business, the number of cloud service users is growing rapidly, and the […]
-
Time：2021-11-29
Usually, enterprises will adopt polling or random methods to produce data to Kafka cluster through Kafka producer, so as to ensure that the data between kafk partitions is evenly distributed as far as possible.On the premise of uniform distribution of partition data, if we design a reasonable number of Kafka partitions according to the amount […]
-
Time：2021-11-9
It is said that MySQL users have reached tens of millions of levels, including enterprise users. It can be said that it is the most popular open source database management system software at present. No product can be omnipotent, nor can it be applicable to all application scenarios. So in what scenario does MySQL work […]
-
Time：2021-11-9
>A technology loving juyoujing’s brother juzuojing Function of index The index is used to quickly find the value of data in the table. If the index is not used, MySQL will search row by row, which is extremely inefficient in the case of large amount of data; If you use the index, you can quickly […]
-
Time：2021-11-6
Interview questions Why separate databases and tables (how to design the database level when designing a highly concurrent system)? What database and table middleware have you used? What are the advantages and disadvantages of different database and table middleware? How do you split the database vertically or horizontally? Interviewer psychological analysis In fact, this must […]
