基于数学建模方法的数据库系统性能调优研究

Research on Database System Performance Tuning Based on Mathematical Modeling Methods

目前的数据库系统性能调优往往都需要经过反复的测试、分析和资源重新分配才能完成。存在着效率较低、时间过长、影响业务系统运行、容易引起资源浪费等的问题,而且大多数的调优过程是相互独立的,没有考虑业务应用特征对数据库系统性能的影响因素。所提出的数学建模方法可以在一定程度上避免以上问题。

The cun＇ent database system performance tuning often need to go through repeated testing, analysis, and reallocation of resourees to complete. There is low efficiency, long time, affect business systems running easily lead to waste of resources, and most of the tuning process is independent of each other, and do not consider the factors of the business applications the characteristics of the performance of the database system. The proposed mathematical modeling method can avoid the above problems to some extent.