Table format changing method and device, electronic device and computer readable medium

Abstract

The embodiment of the invention provides a table format changing method and device, an electronic device and a computer readable medium. The table format changing method comprises the steps that a modification recording table of an original table format and a temporary table obtained by alternating the original table format are created; after data in the inserted original table corresponding to modification triggers is modified and the modification triggers are triggered, modification information of the original table is recorded in the modification recording table; all data in the modified original table is written into the temporary table; according to the modification information recorded in the modified original table, a first modification operation is conducted on the data in the temporary table; the modified original table is changed by the modified temporary table, and the modified original table is deleted. By applying the embodiment, it can be achieved that the original tableis not locked in the table format alternation process to avoid the influence on normal operation of other transactions.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method, a device, an electronic device and a readable storage medium for changing a table format. Background technique [0002] At present, when it is necessary to change the table format of the database, the widely used method is the pt-online-schema-change method. The specific processing process is as follows: [0003] The first step is to create a temporary table according to the new table format required by the user; [0004] The second step is to insert a modification trigger into the original table whose table format is to be changed, and the modification trigger may include an insert trigger, an update trigger and a delete trigger; [0005] In the third step, when the user changes the data in the original table, the data is directly modified to the temporary table by triggering the modification trigger; for example, the user performs an update operation on the origina...

AI Technical Summary

Problems solved by technology

[0005] In the third step, when the user changes the data in the original table, the data is directly modified to the temporary table by triggering the modification trigger; for example, the user performs an update operation on the original table, and directly updates the temporary table by triggering the update trigger At this time, the original table is locked, so that other business processes except the user can no longer operate on the original table;

[0009] However, in the third step, modifying the data directly to the temporary table by triggering the change trigger may trigger the locking of the original table. As a result, when the user changes the table format of the original table in the database, other business processes cannot modify the original table. operation, which will affect the normal use of other businesses in the case of a long lock-up time

Images