基于轻量数据挖掘方法的数据库锁表优化-计算机工程与应用.PDF

16 2012 ，48 （8） Computer Engineering and Applications 计算机工程与应用 基于轻量数据挖掘方法的数据库锁表优化 1 2 周晓云 ，覃雄派 1 2 ZHOU Xiaoyun , QIN Xiongpai 1.徐州师范大学 计算机科学与技术学院，江苏 徐州 221008 2.中国人民大学 信息学院，北京 100872 1.College of Computer Science and Technology, Xuzhou Normal University, Xuzhou, Jiangsu 221008, China 2.School of Information, Renmin University of China, Beijing 100872, China ZHOU Xiaoyun, QIN Xiongpai. Database lock table optimization based on light weight data mining. Computer Engineering and Applications, 2012, 48 （8 ）：16-20. Abstract ：To make database systems always provide consistent high performance under various workload conditions, it is necessary to optimize database system settings. With the system becoming more complex and workloads becoming more fluctuating, it is very hard for DBA to quickly analyze performance data and optimize the system properly, and people resort to promising database system self-optimization techniques to solve the performance problem. A data mining based optimization scheme for lock table of database sys- tems is presented. After training with performance data, a neural network becomes intelligent enough to predict system performance with newly provided configuration parameters. During system running, performance data are collected continuously for a rule engine, which choose the proper parameter of the lock table for adjusting, and the rule engine relies on the trained neural network to precisely provide the amount of adjustment. The selected parameter is adjusted according to the quantitative hints provided with the expectation that the system will perform better. The scheme is tested with TPC-C workload, the system ’s throughput increases by about 16 percent. Key words ：database self-optimization; lock table; rule engine; neural network; predictor; data mining 摘 要：为了保证数据库系统在不同的负载情况下，始终提供强大的事务处理能力，必须对数据库系统进行性能优化。依赖于 DBA ，来分析性能数据，然后进行系