Database operating and scheduling method and device for performance data acquisition system

Abstract

The invention discloses a database operating and scheduling method for a performance data acquisition system, which comprises: a period division step for dividing a performance data acquisition period into a performance data storage period and a non performance data storage period, wherein the performance data storage period is special for executing performance data storage; a task addition step for creating two task queues, wherein one task queue is used for storing a report generating task, and the other task queue is used for storing an expired data processing task; and a task execution step for taking the task out of the two task queues to perform execution according to the execution principle that the report generating task is superior to the expired data processing task at the non performance data storage period. The method can effectively balance the database load and prevent overload of the database. The invention also provides a database operating and scheduling method for the performance data acquisition system corresponding to the method. The method and the device are particularly applicable in the performance data acquisition field of an equipment management system in the communication field.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to an operation scheduling method and device capable of balancing database loads in a performance data collection system. Background technique [0002] In the performance data collection system, it is often necessary to periodically collect various performance data from multiple collection points of the device. The collection point refers to the physical entity on the device that can provide performance data collection and statistics. Source of performance data. These performance data will be stored in the database, and data reports with larger granularity can be generated periodically. In order to prevent the data stored in the database from growing without limit, the expired data of these reports can also be periodically deleted or dump. [0003] In the current performance data collection system, these operations involving the database are not well planned in te...

AI Technical Summary

Problems solved by technology

[0003] In the current performance data collection system, these operations involving the database are not well planned in terms of execution timing. The storage of performance data is done after the performance data collection is completed, and periodic report generation with larger granularity and expired data are stored. Deletion is scheduled by a timer. Since the relevance and timeliness of these database operations are not considered, this scheduling method itself may be invalid. For example, when a 30-minute report needs to be generated, the data of the first 30 minutes is not completely saved Complete, affecting the correctness of the generated data; at the same time, such scheduling may cause different database operations to overlap at the same time, resulting in excessive database load

In addition, in the prior art, the selection of the acquisition cycle often does not consider the time-consuming data acquisition and storage, which will also lead to the superposition of related database operations, making the bottleneck caused by the database load affect the availability of the system itself

[0004] Therefore, in order to overcome the database-related data storage, report generation, and expired data processing operations (mainly including expired data deletion and dump operations) in the performance data acquisition system, the operations that constitute database pressure are not well planned in terms of execution timing, resulting in The database load is too large, which makes the database load the bottleneck of the system, and the invalid operation problem caused by not considering the timeliness. It is urgent to develop a new scheduling scheme for database operations of the performance data acquisition system.

Images