数据库连接池在刷卡缴费系统高并发下的设计和调优方法分析  

Analysis onthe Design and Optimization Method of Database Connection Pool Under High Concurrency of Credit Card Payment System

作　　者：王璐[1] Wang Lu(Southwest Oil and Gas Field Branch,Petro China Co Ltd.,Chengdu 610051,Sichuan Province,China)

机构地区：[1]中国石油天然气股份有限公司西南油气田燃气分公司,四川成都610051

出　　处：《科学与信息化》2021年第20期30-31,共2页Technology and Information

摘　　要：随着当代科技的高速发展,互联网技术已成为人们日常生活中必不可少的一部分,用户对于网络的需求也是与日俱增,网络访问的高效与便捷已成为当下人们的共识。然而网络技术提高的同时也带来了问题,用户每次请求都需要向数据库获得链接,而数据库创建连接通常需要消耗相对较大的资源,创建时间也较长。这样一来就容易造成用户等待时间过长,系统崩溃等问题,因此数据库连接池应运而生,解决了高并发情况下的访问难题。本文首先对数据库连接池的原理及关键技术进行了概述,通过对高并发下的数据库连接池进行设计系统并加以分析,随后通过实验分析后的结果研究策略如何优化数据库连接池,使其性能达到最大化。With the rapid development of contemporary science and technology,Internet technology has become an indispensable part of people's daily life.Users'demand for the Internet is also increasing day by day.The efficiency and convenience of Internet access have become the consensus of people nowadays.However,the improvement of network technology also brings problems.Users need to obtain a link from the database every time they request.However,the database connection creation usually consumes relatively large resources and takes a long time.In this way,it is easy to cause problems such as long waiting time for users and system crashes.Therefore,a database connection pool has emerged to solve the access problem under high concurrency.This article firstly summarizes the principles and key technologies of database connection pools,designs and analyzes database connection pools under high concurrency,and then analyzes the results of experiments to study how to optimize database connection pools,so as to achieve the maximized performance.

关 键 词：数据库连接池 高并发 优化策略 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]