A system and method for evaluating database performance load based on machine learning

Abstract

The invention provides a system and method for evaluating database performance load based on machine learning, the method comprises the following steps: Using machine learning algorithm training datato generate performance load learning model, after data processing, these massive data as a training set and use machine learning technology to train, and finally generating performance and load learning model, using this model to predict the new generated feature data, and evaluating the performance and load of the database. On the one hand, the conclusion of the evaluation system is more reasonable than the analysis of the expert model, and it will not miss the important performance load index, and the problem location of database performance and load is more accurate; On the other hand, reducing the knowledge and ability requirements of database operators can greatly save human cost and provide work efficiency.

Description

technical field [0001] The invention is a machine learning-based database performance load evaluation system and method, which belongs to the field of artificial intelligence machine learning and relates to database operation and maintenance. Background technique [0002] Database applications require low response time and high performance, so performance load testing is performed before deploying database applications. However, with the continuous operation of database applications, there are more and more users, and the amount of data is increasing, which leads to an increase in the performance and load of the database. If it is not intervened and processed in time, it may lead to system downtime and other failures of varying degrees. . Therefore, real-time monitoring of data performance and load is now very important. [0003] At present, there are many performance load monitoring tools for databases, but these tools usually simply display some key operating indicators,...

AI Technical Summary

Problems solved by technology

[0005] 1) The expert model is the accumulation of knowledge and experience of senior DBAs over the years, which has high requirements for the experience and proficiency of database operation and maintenance personnel, which virtually increases the labor cost

[0006] 2) In addition to rule definitions, the expert model also has complex scripts and codes, which require stable developers and operation and maintenance teams, and have high requirements for personnel circulation

If there are some small-probability abnormalities that are not involved in the indicators of the expert model, then an advanced DBA is required to find factors that affect performance and load from a large amount of historical data. This process is very time-consuming.

Images