摘要
阐述了山西省电力公司生产管理系统有着访问人数多、工作流程复杂、安全性要求高等特点。指出用户在线人数和并发请求不断增加,原有的系统性能难以满足需求。提出在不增加硬件资源的情况下进行性能优化以满足系统对高负载的需求,分别从数据库优化、中间件优化以及应用系统部署架构优化等三个方面进行。数据库优化主要是查找并优化资源消耗过大的查询语句,降低资源消耗;中间件优化通过调整数据库连接池设置和Session存活时间等参数来降低资源占用情况;应用系统部署架构优化是改变了原来的集群管理方式和运维综合监管系统(IMS)接口指标计算方式。在进行优化之后,通过监测发现,系统在线人数增加的同时硬件资源负载情况有所降低,达到了系统优化的目的。
Huge visitors,complex workflow and higher safety requirements are the characteristics of the Production Management System of Shanxi Electric Power Corporation.It is pointed out that the growth of online visitors and concurrent made the original system inadequate to fulfill the demand.Performance optimizing including database optimization,middleware optimization and the optimization of application system deployments is proposed to cater to the high load when hardware resource is not increased.After optimizing the performance,it is monitored that while the number of online visitors increase,the load of hardware resource reduces,which accomplished the target of system optimization.
出处
《山西电力》
2012年第2期4-7,共4页
Shanxi Electric Power
关键词
性能
负载均衡
数据库
中间件
performance
load balancing
database
middleware
