Data scrubbing method and apparatus, and computer readable storage medium

The method according to claim 0, wherein the copying, by the server, data from the target table to the temporary table, and generating index information in the temporary index according to the data in the temporary table comprises:

• copying, by the server, the data from the target table to the temporary table;
• counting, by the server, a quantity of data blocks newly added to the target table in the data copying process;
• determining, by the server, whether the quantity of the newly added data blocks is less than a preset threshold;
• setting, by the server, the status of the temporary index to an available state, and generating the index information in the temporary index according to the data in the temporary table, if the quantity of the newly added data blocks is less than the preset threshold;
• and
• copying, by the server, data in the newly added data blocks to the temporary table, and performing the step of counting a quantity of data blocks newly added to the target table in the data copying process, if the quantity of the newly added data blocks is not less than the preset threshold.

A server comprising:

• one or more processors, memory, and a plurality of machine readable instructions stored in the memory, wherein the plurality of machine readable instructions, when executed by the one or more processors, cause the server to perform a plurality of operations comprising:
• adding, by the server, a share update exclusive lock to a target table, to prevent a system from performing a data definition language (DDL) operation on the target table;
• creating, by the server, a temporary table, a table definition of the temporary table being the same as a table definition of the target table;
• creating, by the server, a temporary index of the temporary table, an attribute of the temporary index being the same as an attribute of an index of the target table;
• copying, by the server, data from the target table to the temporary table, and generating index information in the temporary index according to the data in the temporary table;
• adding, by the server, an access exclusive lock to the target table, to prevent the system from performing a data manipulation language (DML) operation on the target table;
• exchanging, by the server, the data in the temporary table with the data in the target table and the index information in the temporary index with index information in the index of the target table;
• and
• releasing, by the server, the share update exclusive lock and the access exclusive lock on the target table.

A non-transitory computer readable storage medium storing a plurality of machine readable instructions in connection with a server having one or more processors, wherein the plurality of machine readable instructions, when executed by the one or more processors, cause the server to perform a plurality of operations including:

• adding, by the server, a share update exclusive lock to a target table, to prevent a system from performing a data definition language (DDL) operation on the target table;
• creating, by the server, a temporary table, a table definition of the temporary table being the same as a table definition of the target table;
• creating, by the server, a temporary index of the temporary table, an attribute of the temporary index being the same as an attribute of an index of the target table;
• copying, by the server, data from the target table to the temporary table, and generating index information in the temporary index according to the data in the temporary table;
• adding, by the server, an access exclusive lock to the target table, to prevent the system from performing a data manipulation language (DML) operation on the target table;
• exchanging, by the server, the data in the temporary table with the data in the target table and the index information in the temporary index with index information in the index of the target table;
• and
• releasing, by the server, the share update exclusive lock and the access exclusive lock on the target table.