Extended analysis method, device and terminal equipment of database partition table

Abstract

The present invention relates to the technical field of database expansion, in particular to a database partition table expansion analysis method, device and terminal equipment. The database partition table expansion analysis device includes a judgment module, a search module and a division module. The judging module is used to judge whether the set partition time reaches the time threshold, and the search module is used to search the target partition serial number with the largest value in the partition information table of the database if the set partition time reaches the time threshold, The partition information table is used to store basic information of multiple partition tables, and the basic information includes partition descriptions and partition serial numbers of the partition tables. The division module divides the partition table corresponding to the target partition serial number into multiple sub-partition tables according to the time format of the partition description of any other partition table and the time content of the partition description corresponding to the partition serial number adjacent to the target partition serial number.

Description

technical field [0001] The present invention relates to the technical field of database expansion, in particular to an expansion analysis method, device and terminal equipment of a database partition table. Background technique [0002] Due to the rapid development of the Internet business, resulting in a dramatic increase in data, in order to cope with this phenomenon, many Internet companies use a large number of MySQL partition tables to cope with this rapid development, so the maintenance of MySQL partition tables is becoming more and more important. [0003] The MySQL partition table divides a complete table into different files according to certain rules, and each part of the file only retains part of the data, that is, the data in a table is divided into multiple parts and stored in different tables. The table is packaged as a whole. In this way, only part of the files are accessed during query and access, effectively increasing the access speed and writing speed. A...

AI Technical Summary

Problems solved by technology

[0004] However, since the MySQL partition table cannot be automatically extended, it must rely on manual expansion. Once the time for new data writing exceeds the time defined by the partition rules, on the one hand, the newly written data cannot be written to the predetermined partition, and on the other hand, it will cause subsequent A large amount of data is concentrated in one partition, which slows down the query and write response, and ultimately affects the normal operation of online business

Images