论文部分内容阅读
彩铃回铃音系统(简称CRBT系统)主要面向手机终端用户提供彩铃业务。本文的主要研究对象彩铃回铃音WEB系统(以下简称CRBT WEB系统)是CRBT系统的重要部分,它的目标是面向终端用户提供高效可靠的WEB服务,用户可以通过WEB系统实现针对彩铃音的各种操作。随着业务需求的不断提高和网络环境的日趋复杂,原CRBT WEB系统在新的业务需求和网络环境下的缺陷逐步显现。本文针对原CRBT WEB系统存在的性能问题展开分析和研究,主要工作如下。对原有的CRBT WEB系统进行了深入的分析,在针对系统进行大量性能测试的基础上,发现由于CRBT WEB系统的WEB应用程序在做查询时向数据库服务器请求了过多不必要的数据,导致数据库访问效率低、并发访问慢等较为严重的性能问题。针对原CRBT WEB系统查询数据慢、多用户并发访问速度慢的问题,通过优化MySQL查询,运用数据库连接池技术,并根据CRBT WEB系统的实际情况对数据库连接池的最大连接数、最小连接数等重要参数提出了适合的配置方案,以提高CRBT WEB系统的查询速度和并发访问速度。新的CRBT WEB系统根据本文所提出的方法和策略进行设计与优化实现。从新的CRBT WEB系统试运行的情况来看,该系统已经完全能符合用户的性能要求。
CRBT system (CRBT system) mainly provides CRBT service to mobile terminal users. The main research object of this paper The CRBT WEB system (CRBT WEB system) is an important part of CRBT system. The goal of CRBT system is to provide efficient and reliable WEB services for end users. The users can use the WEB system to implement CRBT Kind of operation With the continuous improvement of business requirements and the increasingly complicated network environment, the defects of the original CRBT WEB system under new business demands and network environments are gradually emerging. In this paper, the original CRBT WEB system performance problems analysis and research, the main work is as follows. Based on the in-depth analysis of the existing CRBT WEB system and based on a large number of performance tests conducted on the system, it was found that as the WEB application of the CRBT WEB system requests excessively unnecessary data from the database server when making a query, Database access inefficient, slow access and other more serious performance issues. For the original CRBT WEB system slow query data, multi-user concurrent access slow, optimize the MySQL query, the use of database connection pool technology, and according to the actual situation of the CRBT WEB database connection pool, the maximum number of connections, the minimum number of connections Important parameters proposed a suitable configuration to improve the CRBT WEB system query speed and concurrent access speed. The new CRBT WEB system is designed and optimized according to the methods and strategies proposed in this paper. From the new CRBT WEB system trial run situation, the system has been fully able to meet the user’s performance requirements.