无线网络优化平台数据库性能优化设计思路

Optimized Design of Database Performance for Wireless Network Optimization Platform

由于无线上网记录数据量呈现指数级增长,导致数据加载、数据处理和数据查询出现严重的性能下降。基于此,提出利用时间价值分级、精准索引设计、混合分区设计、并行处理机制和高效SQL设计方法等技术设计角度应对性能瓶颈的优化设计思路。主要从数据增长对系统资源的需求入手逐步诊断性能问题和性能瓶颈,分析数据的增长对数据库性能下降和出现性能瓶颈的影响,针对系统运行中遇到的实际问题进行优化设计。经上海电信无线网络优化平台现网实验测试表明,运用上述优化设计方法组合设计可以很好地解决数据库性能问题,大大提高了数据库性能。

With the rapid development of mobile lnternet, wireless Interact traffic has an exponential growth, leading to highly decreased performance of data loading, processing and query. In view of this, an optimized design which adopts time value classitication, precise index design, hybrid partitioning design, parallel processing mechanism and high- efficiency SQL design is proposed in this paper to deal with the performance bottleneck. Based on the demand of increasing data on system resource, the crux and bottleneck of performance are diagnosed step-by-step. The impact of growing data on both the decreased performance and its bottleneck is analyzed and the optimized design is performed according to the practical problems. The experimental tests on the wireless network optimization platform of Shanghai Telecom demonstrate that the proposed optimized design can greatly enhance the pertbrmance of the database.