Method, device and equipment for keeping database hotspot data and medium

Abstract

The invention relates to the technical field of databases, in particular to a method, a device, equipment and a medium for keeping hotspot data of a database, and the method comprises the following steps: (1) installing a persistent memory and a drive thereof on a server where the database is located; (2) reading storage data on a storage device which needs to be accessed during operation, and allocating space in the persistent memory for corresponding storage; (3) forming a data cache pool memory by using all data distributed in the persistent memory, indexing and retaining hot data; (4) establishing a mapping relation between nodes in a memory of the database cache pool and data stored on the storage device, and repeatedly covering the mapping relation with cycle time T; and (5) restarting the database, and verifying the consistency according to the mapping relation r. According to the method, the persistent memory is used for keeping the database hotspot data, the characteristic that the persistent memory can avoid data loss in the memory is fully utilized, and the situation that in the preheating process after the database is restarted, the response delay of a database user is reduced is prevented, and the access efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, device, equipment and medium for maintaining hotspot data in a database. Background technique [0002] The memory access speed is nanoseconds (10 to the -9 power), and the hard disk access speed is milliseconds (10 to the -3 power), which differs by several orders of magnitude; database access needs to be read from the disk to the memory. After the database is restarted, the data in the memory will be lost, and the data needs to be read from the disk again. There will be a warm-up process. During this process, the response delay of the database user will increase. [0003] Since the performance difference between the memory and the hard disk is more than 1000 times, after the database is restarted, the user's access to the database will increase exponentially, and because the database has just started, after the application is retried, it is found that the database ca...

AI Technical Summary

Problems solved by technology

[0003] Since the performance difference between the memory and the hard disk is more than 1000 times, after the database is restarted, the user's access to the database will increase exponentially, and because the database has just started, after the application is retried, it is found that the database can provide services, and the previous database requests are more concurrent. If one is sent, the service capability of the database will drop sharply, and even cause problems such as database denial of service and crash.

Images