Data management method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention provides a data management method and device, electronic equipment and a storage medium. The data management method includes: detecting whether the to-be-managed data table in the database meets a preset filing condition or not; if yes, modifying the pointing direction of a data table pointer pointing to the to-be-managed data table from the to-be-managed data tableto a preset standby data table corresponding to the to-be-managed data table, and performing filing processing on the data stored in the to-be-managed data table, and performing defragmentation processing on the to-be-managed data table after all the data stored in the to-be-managed data table is subjected to filing processing. According to the method, before data in the to-be-managed data tableis archived, the pointing direction of the data table pointer pointing to the to-be-managed data table is modified into the corresponding alternative data table, so that the influence on data writingduring subsequent archiving processing and fragmentation processing is avoided, and the data can be normally written into a database.

Description

technical field [0001] The present application relates to the computer field, and in particular to a data management method, device, electronic equipment and storage medium. Background technique [0002] When the historical stock data in the database is too large, the disk space of the database will be insufficient, and if the data volume of a single table is too large, the speed of data insertion and data query will be reduced. The existing data management method is usually to manually delete unimportant historical data in each data table contained in the database at regular intervals. [0003] However, in the process of implementing this application, the inventor found that, for example, for the current MYSQL database (an open source relational database), deletion is not a real deletion. After deleting data, there will still be a large number of fragments in the data table, which still occupy space At this time, in order to free up space, it is necessary to defragment the...

AI Technical Summary

Problems solved by technology

[0003] However, in the process of implementing this application, the inventor found that, for example, for the current MYSQL database (an open source relational database), deletion is not a real deletion. After deleting data, there will still be a large number of fragments in the data table, which still occupy space At this time, in order to free up space, it is necessary to defragment the data table after data deletion

However, the defragmentation work is relatively cumbersome. Since there may still be some undeleted data after the data table is deleted, it is necessary to filter out the fragmented data before defragmenting, and then organize the fragmented data, which is time-consuming and laborious.

Moreover, when defragmenting the data table, the database cannot perform write operations and can only support read operations, which has a great impact on online services.

Images