Research On Database System Performance Optimization Methods

With the rapid development of Internet technology and industry,the number of online users showed a blowout growth.The data in the network,which makes the management of data to become increasingly important,is also growing.In the real life,a large number of individual users,Internet interest groups and new Internet start-up companies generally construct the lightweight database application system to get integrate into the new era of the Internet world.However,a large number of concurrent users’ access,database system throughput and I / O access frequently and other conditions which are these systems in the face of,will produce system overload,delay and even increase the phenomenon of system services paralysis.At present,The method used to optimize the lightweight database application system is usually existence to achieve technical difficulties,long development cycle and other shortcomings.Aiming at the above problems,to improve the response performance of lightweight concurrent access to the database system,in the original environment of software and hardware system based on the same,this paper focuses on the performance optimization methods of database system,mainly carried out the following research work.(1)The performance optimizations of database system are summarized.On the basis of the summary,according to the design principle of locality and the principle of the Cache,combined with regular expression and Java reflection mechanism,the based on lightweight relational database system access optimization algorithm is proposed with describing the algorithm of the proposed background,design idea,design process and implementation steps.(2)The algorithm is tested on MySQL platform,and the performances of SQL query using both of I/O and memory are compared.The experimental results show that the key value,the index fields,and the general field of concurrent queries to relational database system test,lightweight,when dealing with a large number of users’ online access to concurrent queries,the proposed algorithm has faster processing speed,to ensure that the user can accept a waiting period to complete the query response.It provides an important solution for the performance optimization of lightweight database system,and has a certain value in engineering application.