CN115080567A - A method, device, equipment and medium for arranging table space of a database - Google Patents

Abstract

The application provides a method, a device, equipment and a medium for sorting table spaces of a database, wherein the method comprises the following steps: responding to data table processing operation performed on the database, and displaying a first data table and a first table space on the graphical user interface; the first data table comprises a second data table comprising a first shard table space; determining a third data table from the second data table according to the first table space and a preset sorting requirement; predicting that the third data table is sorted, wherein the database comprises a second table space, and determining a fourth data table from the second data table according to the second table space and a preset sorting requirement; and when the preset finishing starting condition is met, finishing the third data table and the fourth data in sequence according to a preset finishing method. The database management system can help database management personnel to work more efficiently, labor cost is reduced, and database arrangement efficiency is improved.

Description

A method, device, equipment and medium for arranging table space of database

technical field

The present application relates to the technical field of databases, and in particular, to a method, apparatus, device and medium for organizing table space of a database.

Background technique

A database is a "warehouse that organizes, stores and manages data according to data structures". It is a collection of large amounts of data stored in the computer for a long time, organized, sharable, and uniformly managed. A tablespace is a logical division of a database, and a tablespace can only belong to one database. All database objects are stored in the specified tablespace. But the main storage is the table, so called the table space.

After the content in the data table is deleted in the database, the table space will not be deleted automatically. In order to ensure that the database space can be effectively released, the database space needs to be sorted out to release the table space occupied by the deleted data. The sorting method in the prior art is to set up special database administrators to perform manual detection according to their own work experience, and then sort according to the detection situation, which has high labor cost and low sorting efficiency, which cannot meet the needs of actual business for database space.

SUMMARY OF THE INVENTION

In view of this, the purpose of this application is to provide a method, device, equipment and medium for arranging table space of a database, which can reflect the change process of the database from the initial data table and the initial table space to the first data table and the first table space, It helps database administrators work more efficiently; it can also automatically select the third data table and the fourth data table that can be processed successively, and process them in sequence, which reduces labor costs and improves the efficiency of database sorting.

In a first aspect, an embodiment of the present application provides a method for organizing a table space of a database. A graphical user interface is provided through a terminal device, and the graphical user interface displays an initial data table and an initial table space contained in the database; the method includes:

In response to a data table processing operation performed on the database, the graphical user interface displays a first data table and a first table space included in the database after the data table processing is performed; the first data table includes a A second data table of a fragmented tablespace;

According to the first table space and preset sorting requirements, from the second data table, determine a third data table that can be sorted;

It is predicted that after the third data table is sorted, the database includes a second table space, and according to the second table space and preset sorting requirements, it is determined from the second data table that the A fourth data table other than the third data table that can be sorted;

When the preset start sorting condition is satisfied, the third data table and the fourth data are sorted in sequence according to the preset sorting method, so as to release the table space of the database.

In some technical solutions of the present application, the above-mentioned first table space includes: a first free table space, a first fragmented table space and a first used table space; displaying the first table space on the graphical user interface includes:

The first table free table space is displayed on the GUI in a first presentation mode; the first fragmented table space is displayed in a second presentation mode in the graphical user interface; and the third table space is displayed in the graphical user interface The display mode displays the first used table space; wherein, the first display mode, the second display mode and the third display mode are all different.

In some technical solutions of the present application, the above-mentioned first data table further includes a fifth data table that does not include the first fragmented table space; displaying the first data table on the graphical user interface includes:

The second data table is displayed in a first-level display mode on the graphical user interface, and the fifth data table is displayed in a second-level display mode in the graphical user interface; the first-level display mode is higher than the first-level display mode. Second-level display.

In some technical solutions of the present application, after the above method has obtained the fourth data table, the method includes:

The third data table is displayed in a third-level display mode on the graphical user interface, and the fourth data table is displayed in a fourth-level display mode in the graphical user interface; the third-level display mode is higher than the third-level display mode. Four-level display method.

In some technical solutions of the present application, the above-mentioned preset start sorting conditions include at least one of the following:

A first touch operation for the sorting control is detected;

The preset waiting time has expired;

and detecting a second touch operation on the third data table.

In some technical solutions of the present application, the third data table is sorted in sequence according to the preset sorting method, including:

Sorting the third data table according to a preset sorting method when detecting that the first touch operation for the sorting controls or the preset waiting time is exhausted;

Sorting the sorted third data table in sequence according to a preset sorting method;

When a second touch operation on the third data table is detected, the third data table is sorted in sequence according to a touch sequence corresponding to the second touch operation according to a preset sorting method.

In some technical solutions of the present application, the third data table is sorted in sequence according to the preset sorting method, including:

performing a copying operation on the third data table to obtain a sixth data table with the same data content contained in the third data table;

The sixth data table after data reorganization is renamed, and the third data table is replaced to complete the sorting.

In a second aspect, an embodiment of the present application provides an apparatus for organizing a table space of a database, which resides in a terminal device, and the terminal device provides a graphical user interface, and the graphical user interface displays an initial data table and an initial table space contained in the database; The device includes:

The first display module is configured to display the first data table and the first table space contained in the database after the data table processing is performed on the graphical user interface in response to the data table processing operation performed on the database; a data table including a second data table containing the first fragmented table space;

a first determining module, configured to determine a third data table that can be sorted out from the second data table according to the first table space and preset sorting requirements;

The second determination module is used to predict that after the third data table is sorted, the database contains a second table space, and according to the second table space and preset sorting requirements, from the second data table , determine a fourth data table that can be organized in addition to the third data table;

The sorting module is used for sorting the third data table and the fourth data in sequence according to a preset sorting method when a preset sorting start condition is satisfied, so as to release the table space of the database.

In a third aspect, an embodiment of the present application provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, when the processor executes the computer program The steps of implementing the above-mentioned method for organizing tablespaces of a database.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the above-mentioned method for organizing table space of a database is executed. step.

The technical solutions provided by the embodiments of the present application may include the following beneficial effects:

The method of the present application includes: in response to a data table processing operation performed on the database, displaying a first data table and a first table space included in the database after the data table processing is performed on the graphical user interface; the first data The table includes a second data table that includes a first fragmented table space; according to the first table space and preset sorting requirements, a third data table that can be sorted is determined from the second data table; prediction After the third data table is sorted, the database includes a second table space, and according to the second table space and preset sorting requirements, it is determined from the second data table that the third table space is excluded. A fourth data table other than the three data tables that can be sorted; when the preset start sorting conditions are met, the third data table and the fourth data are sorted in sequence according to the preset sorting method, so as to release the data of the database. tablespace. The application can reflect the change process of the database from the initial data table and the initial table space to the first data table and the first table space, helping the database administrator to work more efficiently; it can also automatically select the third data table that can be processed successively and the fourth data table, and process them in sequence, which reduces labor costs and improves the efficiency of sorting out the database.

In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, the preferred embodiments are exemplified below, and are described in detail as follows in conjunction with the accompanying drawings.

Description of drawings

In order to illustrate the technical solutions of the embodiments of the present application more clearly, the following drawings will briefly introduce the drawings that need to be used in the embodiments. It should be understood that the following drawings only show some embodiments of the present application, and therefore do not It should be regarded as a limitation of the scope, and for those of ordinary skill in the art, other related drawings can also be obtained according to these drawings without any creative effort.

FIG. 1 shows a schematic flowchart of a method for arranging table space of a database provided by an embodiment of the present application;

FIG. 2 shows a schematic diagram of sorting out a third data table provided by an embodiment of the present application;

FIG. 3 shows a schematic diagram of a table space arrangement device for a database provided by an embodiment of the present application;

FIG. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed ways

In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the accompanying drawings in the embodiments of the present application. The drawings are only for the purpose of illustration and description, and are not used to limit the protection scope of the present application. In addition, it should be understood that the schematic drawings are not drawn to scale. The flowcharts used in this application illustrate operations implemented in accordance with some embodiments of the application. It should be understood that the operations of the flowcharts may be performed out of order and that steps without logical context may be performed in reverse order or concurrently. In addition, those skilled in the art can add one or more other operations to the flowchart, and can also remove one or more operations from the flowchart under the guidance of the content of the present application.

In addition, the described embodiments are only some of the embodiments of the present application, but not all of the embodiments. The components of the embodiments of the present application generally described and illustrated in the drawings herein may be arranged and designed in a variety of different configurations. Thus, the following detailed description of the embodiments of the application provided in the accompanying drawings is not intended to limit the scope of the application as claimed, but is merely representative of selected embodiments of the application. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without creative work fall within the protection scope of the present application.

It should be noted that the term "comprising" will be used in the embodiments of the present application to indicate the existence of the features declared later, but does not exclude the addition of other features.

Embodiments of the present application provide a method, apparatus, device, and medium for sorting table space of a database, which are described below through embodiments.

A database, such as a MySQL database, is a "warehouse that organizes, stores, and manages data according to data structures". It is a collection of large amounts of data stored in the computer for a long time, organized, sharable, and uniformly managed.

A tablespace is a logical division of a database, and a tablespace can only belong to one database. All database objects are stored in the specified tablespace. But the main storage is the table, so called the table space.

When a segment is generated in a tablespace, space is allocated for the initial extent of the segment from the tablespace effective free space. When these initial ranges are full of data, the segment requests another range to be added. This expansion process will continue until the maximum extent value is reached, or there is no free space in the tablespace for the next extent. Ideally, the data of a segment can be stored in a single scope. In this way, all data is stored close to other data in the segment, and fewer pointers are used to find data. But there are a lot of cases where a segment contains multiple ranges, and there is no way to guarantee that these ranges are stored adjacently. When a space requirement is to be met, the database no longer merges adjacent free ranges (unless there is no choice), but instead looks for the largest free range in the tablespace to use. This will gradually form more and more discrete, separated, smaller free spaces, or fragments. The accumulation of fragments will greatly limit the performance of the database and occupy a large amount of table space, so it is necessary to defragment.

The defragmentation method in the prior art is to set up special database administrators to perform manual detection according to their own work experience, and then perform sorting according to the detection situation. The labor cost is high, the sorting efficiency is low, and cannot meet the actual business needs for database space.

Based on this, FIG. 1 shows a schematic flowchart of a method for organizing tablespaces of a database provided by an embodiment of the present application. A graphical user interface is provided through a terminal device, and the graphical user interface displays the initial data table and initial data table included in the database. Table space; wherein, the method includes steps S101-S104; specifically:

S101. In response to a data table processing operation performed on the database, display a first data table and a first table space included in the database after the data table processing is performed on the graphical user interface; the first data table includes a A second data table with the first fragmented tablespace;

S102, according to the first table space and preset sorting requirements, from the second data table, determine a third data table that can be sorted;

S103. Predict that after the third data table is sorted, the database includes a second table space, and according to the second table space and preset sorting requirements, determine from the second data table, a fourth data table that can be organized in addition to the third data table;

S104. When a preset start sorting condition is satisfied, sort the third data table and the fourth data in sequence according to a preset sorting method, so as to release the table space of the database.

The application can reflect the change process of the database from the initial data table and the initial table space to the first data table and the first table space, helping the database administrator to work more efficiently; it can also automatically select the third data table that can be processed successively and the fourth data table, and process them in sequence, which reduces labor costs and improves the efficiency of sorting out the database.

Some embodiments of the present application will be described in detail below. The embodiments described below and features in the embodiments may be combined with each other without conflict.

S101. In response to a data table processing operation performed on the database, display a first data table and a first table space included in the database after the data table processing is performed on the graphical user interface; the first data table includes a There is a second data table for the first fragmented tablespace.

The method in this application is applied to a terminal device, where the terminal device includes a mobile device and a fixed device, for example, a mobile phone, a computer, a Pad, and the like. The terminal device of the present application provides a graphical user interface, and displays the initial data table and initial table space contained in the database on the graphical user interface. The initial data table and initial table space here represent the data table and table space before the data table operation is performed on the database. The data table operation on the database includes writing a new data table to the database and deleting an existing data table (or data contained in the data table). When writing a new data table to the database, a target space that can store the new data table needs to be divided in the database, and after the target space is allocated, the new data table is written in the target space. The capacity of the target space is generally equal to the new data table. When the data table in the database is deleted or the data contained in the data table in the database is deleted, the space allocated for the data table or data will be in an idle state, and when a new data table or data is written to this part of the space , the required capacity of the newly written data table or data is the same as that of the deleted data table or data, which greatly limits the space utilization of the database, and this part of the fragmented space needs to be released by the application.

In order to be able to reflect the change process of the database data table, the present application displays it through a graphical user interface. After the staff performs data table processing operations on the database, the display content of the graphical user interface in the present application transitions from the initial data table and initial table space contained in the database to the first data table and the first table space. The first data table and the first table space here are the data table and table space contained in the database after the staff has processed the data table in the database.

The first data table in this application includes a second data table that includes the first fragmented table space and a fifth data table that does not include the first fragmented table space. That is to say, after the staff operates the data table on the database, the database contains two kinds of data tables, one is the data table (second data table) that needs to be released, and the other is the data table that does not need to be released. data sheet (the fifth data sheet). In order to facilitate the observation of the database, the present application uses different display modes when displaying the two data tables: the second data table is displayed in the first-level display mode in the graphical user interface, and the second data table is displayed in the first-level display mode in the graphical user interface. The GUI displays the fifth data table in a second-level presentation manner; the first-level presentation manner is higher than the second-level presentation manner. In order to better highlight the second data table we need to process, this application uses a higher-level presentation method to display the second data table. For example, the first-level display method is the upper half of the display, and the second-level display method is the lower half of the display. According to observation habits, the content of the upper half is generally observed first. That is, the second data table is displayed on the upper half of the graphical user interface, and the fifth data table is displayed on the lower half of the graphical user interface. Or the first-level display method is background highlighting, and the second-level display method is background no fill. It is generally believed that the highlighted part can be observed first, the second data table is displayed with the background highlight, and the fifth data table is displayed without the background.

For the first (initial or second) tablespace in this application, it should be noted that the first (initial or second) tablespace in this application includes: the first (initial or second) free tablespace, the first (initial or second) tablespace The (initial or second) fragmented tablespace and the first (initial or second) used tablespace; the free tablespace here represents the original space in the database that is not fragmented (divided), and this part of the space can be divided or Use directly. Fragmented table space indicates that it has been divided, but the previously allocated data table or data in the data table has been deleted. This part of the space can be written to the data table or data that is the same as the space required for the previously allocated data table or data. . The used table space represents the space that has been allocated in the database, and the data table or data allocated for this part of the space has not been deleted, and this part of the space is still being used. In this application, the fragmented table space needs to be released in time to restore it to a free table space.

In order to facilitate the observation of the usage of the table space of the database and lay a foundation for subsequent operations on the data table, the present application includes: displaying the first table free table in a first display manner when displaying the first table space in the graphical user interface. space; the first fragmented tablespace is displayed in the graphical user interface in a second presentation mode; the first used tablespace is displayed in the graphical user interface in a third presentation mode; wherein, the first presentation The method, the second display method and the third display method are all different. The present application displays the first free tablespace, the first fragmented tablespace, and the first used tablespace through different display methods, which facilitates subsequent operations on the data table. For example, the first used tablespace is displayed in yellow, the first fragmented tablespace is displayed in red, and the first free tablespace is displayed in green.

S102. Determine a third data table that can be sorted from the second data table according to the first table space and a preset sorting requirement.

After the application has obtained the first data table and the first table space after data table processing on the database, since there are certain requirements for the database when releasing the space for the data table, it is necessary to remove the space that needs to be released. In the second data table, a third data table that meets the sorting requirements is selected, that is, according to the current situation of the database, a third data table that can perform space release is selected from the second data table that needs to be released.

In the specific implementation, the sorting requirements include business support requirements, business time requirements and business space requirements. For example, the first step is to verify whether the current table space supports DDL tasks. Because gh-ost operates DDL through table copying, the space must be at least twice the size of the existing table. In the second step, by judging whether the current is the peak period of the service, the judgment can be made by obtaining the current QPS and TPS of the service. The third step is to verify the risks in the execution process. We can prevent DML locks from causing production failures by obtaining whether there are currently large transactions or large queries of the current table.

When judging the business space requirements, it is necessary to judge according to the current first table space of the database. Specifically, it is necessary to determine whether the capacity of the first free table space in the first table space can meet the capacity required for sorting out the second data table. The second data table corresponding to the capacity of the current first free table space can be used as the third data table.

S103. Predict that after the third data table is sorted, the database includes a second table space, and according to the second table space and preset sorting requirements, determine from the second data table, A fourth data table that can be organized in addition to the third data table.

After the third data table is obtained, the present application performs prediction on the database after the space release of the third data table, and obtains the second table space included in the database after the third data table is sorted. Then, in the same manner as the above-mentioned method for determining the second data table, a fourth data table that can be sorted out in addition to the third data table is determined from the second data table.

After the fourth data table is obtained, the method further includes: predicting that after sorting the fourth data table, the database includes a third table space, and according to the third table space and preset sorting requirements, From the second data table, determine a seventh data table that can be sorted except the third data table and the fourth data table, until the second data table is traversed. That is to say, the application can release space for all the second data tables, but due to the space requirements for the second data tables, the application first selects the data tables that can meet the space requirements and releases the space first, so as to Subsequent data tables with larger space requirements provide space. When the sorted space can meet the required space of the data table, the space of the data table is released until all the second data tables are released.

After the fourth data table is obtained in the present application, the method includes: displaying the third data table in a third-level presentation manner on the graphical user interface, and displaying the third data table in a fourth-level presentation manner in the graphical user interface The fourth data table is displayed; the third-level display method is higher than the fourth-level display method.

If the application still predicts to obtain the seventh data table, the eighth data table .

S104. When a preset start sorting condition is satisfied, sort the third data table and the fourth data in sequence according to a preset sorting method, so as to release the table space of the database.

After obtaining the third data table and the fourth data table that need to be sorted out and can be sorted out, and if necessary, also include the seventh data table, the eighth data table..., these data tables need to be sorted out. Before starting to organize these data tables, the present application also sets conditions for starting to organize, and only when these conditions for starting to organize are satisfied, will these data tables begin to be organized.

The preset start sorting conditions in this application include at least one of the following: detecting a first touch operation for sorting controls; expiring a preset waiting time; and detecting a second touch for the third data table operate. During specific implementation, settings may be selected for the above-mentioned start sorting conditions, one of the settings may be selected, or multiple matching settings may be selected.

In response to the detection of the start sorting condition of the first touch operation for the sorting space, the present application displays the third data table and the fourth data table on the graphical user interface, and also includes the seventh data table, the eighth data table if necessary... In addition, organizer controls are displayed. The database administrator generates a start sorting signal by clicking on the sorting control, and starts sorting the third data table, the fourth data table, and if necessary, the seventh data table, the eighth data table . . .

The start sorting condition for the preset waiting time is exhausted, which is suitable for databases that need to be automated. After the above-mentioned data tables that need to be processed and can be processed are obtained, after the set waiting time is exhausted, the third data table and the fourth data table, including the seventh data table, the fourth data table, the seventh data table, the fourth data table, Eight data sheets... to organize. After tidying up these data sheets, the waiting time is reset until the next time it runs out, tidying up again. That is to say, by setting the waiting time, the periodic automatic sorting of the database can be realized.

In the above two ways of triggering the sorting by the start sorting conditions, when sorting the third data table, the fourth data table, and if necessary, the seventh data table, the eighth data table... The tables (the fourth data table, the seventh data table, the eighth data table...) are arranged according to a preset sorting method. The preset sorting method includes an ascending order of the required space, or a descending order of the required space, and the like. For example, the third data table that can be sorted includes: the space required for data table A is 11G, the space required for data table B is 12G, and the space required for data table C is 13G; if arranged in ascending order of required space, in The order in which the three third data tables are sorted is data table A, data table B, and data table C.

Regarding the start sorting condition for detecting the second touch operation on the third data table, it is mentioned in the above method that the present application obtains the third data table, the fourth data table, and if necessary, the seventh data table The table, the eighth data table... Then, it is displayed on the graphical user interface. After the above content is displayed, the database administrator can organize the third data table by performing a second touch operation. Specifically, the database administrator can start sorting the selected third data table by clicking the third data table to the designated area. That is, which third data table is selected by the database administrator first, then which third data table is selected for sorting. If the database administrator touches the fourth data table (the seventh data table, the eighth data table...) by mistake when the third data table has not been sorted out, a false touch prompt will be displayed on the graphical user interface. When all the third data tables are sorted, the GUI displays that the sorting operation of the fourth data table can be performed, and continues to click on the fourth data table, and so on until all the second data tables are sorted, The collation of the database is complete.

As shown in Figure 2, the process of sorting out the third data table in this application includes:

S201, performing a copy operation on the third data table to obtain a sixth data table with the same data content contained in the third data table;

S202. Rename the sixth data table after data reorganization, and replace the third data table to complete the sorting.

Specifically, this application replaces the data table that needs to be sorted out with another new data table, where the new data table is obtained by duplicating the data table that needs to be sorted out. By duplicating the original third data table, a sixth data table with the same data content as the data contained in the third data table is obtained, and space is released for the sixth data table, that is, data reorganization is performed on the sixth data table, and the The fragmented table space in the sixth data table is removed, then the sixth data table is renamed, and the third data table is replaced to complete the sorting. If it is the fragmented table space left after deleting the data table, you can directly release the fragmented table space.

FIG. 3 shows a schematic structural diagram of a table space arrangement device for a database provided by an embodiment of the present application, which resides in a terminal device, and the terminal device provides a graphical user interface, and the graphical user interface displays the initial data table included in the database. and the initial tablespace; the means include:

The first display module is configured to display the first data table and the first table space contained in the database after the data table processing is performed on the graphical user interface in response to the data table processing operation performed on the database; a data table including a second data table containing the first fragmented table space;

a first determining module, configured to determine a third data table that can be sorted out from the second data table according to the first table space and preset sorting requirements;

The second determination module is used to predict that after the third data table is sorted, the database contains a second table space, and according to the second table space and preset sorting requirements, from the second data table , determine a fourth data table that can be organized in addition to the third data table;

The sorting module is used for sorting the third data table and the fourth data in sequence according to a preset sorting method when a preset sorting start condition is satisfied, so as to release the table space of the database.

The first table space includes: a first free table space, a first fragmented table space and a first used table space; displaying the first table space on the graphical user interface includes:

The first table free table space is displayed on the GUI in a first presentation mode; the first fragmented table space is displayed in a second presentation mode in the graphical user interface; and the third table space is displayed in the graphical user interface The display mode displays the first used table space; wherein, the first display mode, the second display mode and the third display mode are all different.

The first data table further includes a fifth data table that does not contain the first fragmented table space; displaying the first data table on the graphical user interface includes:

The second data table is displayed in a first-level display mode on the graphical user interface, and the fifth data table is displayed in a second-level display mode in the graphical user interface; the first-level display mode is higher than the first-level display mode. Second-level display.

After obtaining the fourth data table, the apparatus includes:

The second display module is configured to display the third data table in a third-level display mode on the graphical user interface, and display the fourth data table in a fourth-level display mode on the graphical user interface; The third-level display method is higher than the fourth-level display method.

The preset start sorting conditions include at least one of the following:

A first touch operation for the sorting control is detected;

The preset waiting time has expired;

and detecting a second touch operation on the third data table.

The third data table is sorted in sequence according to a preset sorting method, including:

Sorting the third data table according to a preset sorting method when detecting that the first touch operation for the sorting controls or the preset waiting time is exhausted;

Sorting the sorted third data table in sequence according to a preset sorting method;

When a second touch operation on the third data table is detected, the third data table is sorted in sequence according to a touch sequence corresponding to the second touch operation according to a preset sorting method.

The third data table is sorted in sequence according to a preset sorting method, including:

performing a copying operation on the third data table to obtain a sixth data table with the same content as the third data table;

The sixth data table after data reorganization is renamed, and the third data table is replaced to complete the sorting.

As shown in FIG. 4 , an embodiment of the present application provides an electronic device for executing the method for organizing the table space of the database in the present application. The device includes a memory, a processor, a bus, and an electronic device stored in the memory and available in the A computer program running on a processor, wherein, when the processor executes the computer program, the steps of the above-mentioned method for organizing table space of a database are implemented.

Specifically, the above-mentioned memory and processor may be a general-purpose memory and processor, which is not specifically limited here. When the processor runs the computer program stored in the memory, the above-mentioned method for organizing table space of a database can be executed.

Corresponding to the table space sorting method of the database in the present application, an embodiment of the present application further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and the computer program is executed by a processor when the above-mentioned program is executed. The steps of the table space defragmentation method of the database.

Specifically, the storage medium can be a general storage medium, such as a removable disk, a hard disk, etc., when the computer program on the storage medium is run, the above-mentioned method for organizing table space of a database can be executed.

In the embodiments provided in this application, it should be understood that the disclosed system and method may be implemented in other manners. The system embodiments described above are only illustrative. For example, the division of the units is only a logical function division. In actual implementation, there may be other division methods. For example, multiple units or components may be combined or Can be integrated into another system, or some features can be ignored, or not implemented. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be through some communication interfaces, indirect coupling or communication connection of systems or units, and may be in electrical, mechanical or other forms.

The units described as separate components may or may not be physically separated, and components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution in this embodiment.

In addition, each functional unit in the embodiments provided in this application may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit.

The functions, if implemented in the form of software functional units and sold or used as independent products, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be embodied in the form of a software product in essence, or the part that contributes to the prior art or the part of the technical solution. The computer software product is stored in a storage medium, including Several instructions are used to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), magnetic disk or optical disk and other media that can store program codes .

It should be noted that like numerals and letters refer to like items in the following figures, so that once an item is defined in one figure, it does not require further definition and explanation in subsequent figures, Furthermore, the terms "first", "second", "third", etc. are only used to differentiate the description and should not be construed as indicating or implying relative importance.

Finally, it should be noted that the above-mentioned embodiments are only specific implementations of the present application, and are used to illustrate the technical solutions of the present application, rather than limit them. The embodiments describe the application in detail, and those of ordinary skill in the art should understand that: any person skilled in the art can still modify the technical solutions described in the foregoing embodiments within the technical scope disclosed in the application. Changes can be easily conceived, or equivalent replacements are made to some of the technical features; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions in the embodiments of the present application. All should be covered within the scope of protection of this application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims (10)

1. A tablespace arrangement method of a database is characterized in that a graphical user interface is provided through terminal equipment, and the graphical user interface displays an initial data table and an initial tablespace contained in the database; the method comprises the following steps:

responding to the data table processing operation performed on the database, and displaying a first data table and a first table space contained in the database subjected to data table processing on the graphical user interface; the first data table comprises a second data table comprising a first shard table space;

according to the first table space and a preset sorting requirement, determining a third data table capable of being sorted from the second data table;

predicting that the database comprises a second tablespace after the third data table is sorted, and determining a fourth data table which can be sorted except the third data table from the second data table according to the second tablespace and a preset sorting requirement;

and when a preset finishing starting condition is met, sequentially finishing the third data and the fourth data according to a preset finishing method so as to release the table space of the database.

2. The method of claim 1, wherein the first tablespace comprises: a first free table space, a first fragmented table space, and a first used table space; presenting the first tablespace at the graphical user interface comprises:

displaying the first table free list space in a first display mode on the graphical user interface; displaying the first fragment table space in a second display mode on the graphical user interface; displaying the first used table space in a third display mode on the graphical user interface; the first display mode, the second display mode and the third display mode are different.

3. The method of claim 1, wherein the first data table further comprises a fifth data table that does not contain the first shard table space; displaying the first data table on the graphical user interface comprises:

displaying the second data table in a first-level display mode on the graphical user interface, and displaying the fifth data table in a second-level display mode on the graphical user interface; the first level display mode is higher than the second level display mode.

4. The method of claim 1, wherein after obtaining the fourth data table, the method comprises:

displaying the third data table in a third-level display mode on the graphical user interface, and displaying the fourth data table in a fourth-level display mode on the graphical user interface; the third level display mode is higher than the fourth level display mode.

5. The method according to claim 1, wherein the preset finishing start condition comprises at least one of:

detecting a first touch operation aiming at the sorting control;

the preset waiting time is exhausted;

and detecting a second touch operation for the third data table.

6. The method according to claim 5, wherein the sorting the third data tables in sequence according to a preset sorting method comprises:

when detecting that the first touch operation aiming at the sorting control or the preset waiting time is exhausted, sorting the third data table according to a preset sorting mode;

sorting the sorted third data tables in sequence according to a preset sorting method;

when a second touch operation for the third data table is detected, sorting the third data table in sequence according to a preset sorting method and a touch sequence corresponding to the second touch operation.

7. The method according to claim 1, wherein the sorting the third data tables in sequence according to a preset sorting method comprises:

copying the third data table to obtain a sixth data table with the same data content as the third data table;

and renaming the sixth data table subjected to data reorganization, replacing the third data table, and finishing the arrangement.

8. A tablespace arrangement device of a database is characterized by residing in a terminal device, wherein the terminal device provides a graphical user interface, and the graphical user interface displays an initial data table and an initial tablespace contained in the database; the device comprises:

the first display module is used for responding to the data table processing operation carried out on the database and displaying a first data table and a first table space contained in the database subjected to data table processing on the graphical user interface; the first data table comprises a second data table comprising a first shard table space;

the first determining module is used for determining a third data table capable of being sorted from the second data table according to the first table space and a preset sorting requirement;

the second determining module is used for predicting that the third data table is sorted, the database comprises a second tablespace, and according to the second tablespace and preset sorting requirements, a fourth data table which can be sorted except the third data table is determined from the second data table;

and the sorting module is used for sequentially sorting the third data and the fourth data according to a preset sorting method when a preset sorting starting condition is met so as to release the table space of the database.

9. An electronic device, comprising: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory communicating via the bus when the electronic device is operating, the machine-readable instructions when executed by the processor performing the steps of the tablespace arrangement method of a database according to any one of claims 1 to 7.

10. A computer-readable storage medium, having stored thereon a computer program for performing, when being executed by a processor, the steps of the method for tablespace arrangement of a database according to any one of claims 1 to 7.

Images