Design And Implementation Of Database Performance Optimizationa For A Garbage Logistics Management Platform Of Shanghai

With the continuous development of Internet applications and computer information systems,the application scope of database is becoming more and more widely. As application scale ofdatabase constantly expands, complex degree of business is also constantly increasing, andperformance problem of database system is more and more serious so that optimization ofdatabase performance is becoming very important too.Problems of database performance had been deeply analysed in this paper by combining withMySQL optimization techniques in terms of the operation situation of Shanghai Garbage logisticsmanagement platform to look for a various of reasons reducing the application performance of thedatabase, Some actual optimization strategies for the application performance of the database hadbeen proposed in terms the reasons optained by analysis of the problems.The primary reseaarched contents and innovative points made by author of this paper aresummarized as the followings:1)Application research on table separation technology. Analysis of two different databasetable split plan and their application scenarios. According to the characteristics of the systemdatabase, using the project of the horizontal table.2)Application research on the server configuration optimization. In the aspect of hardware,adopt RAID10arrays strategy after analyzed the principle and application of different disk arrayscene. In the aspect of software, improve the concurrent processing capability of database andcache hit ratio by improving the server configuration.3)Application research on SQL statements and index optimization. To optimize the slowquery optimization in the system on the analysis of the basic SQL statements and indexoptimization methods4)Application research on Hibernate optimization. Analyzed the cache mechanism ofHibernate, which is the mainstream persistence layer framework in J2EE system, and put forwardthe method to enhance Hibernate cache utilization. 5)Application research on database backup recovery strategy. According to the characteristicsof this application system, research and design the automatic backup strategy based on Linuxtiming task mechanism.The research work described in this paper has been completed, and the database optimizationstrategy has been actuallychecked in application practice. As experimental results show, theoptimization strategy proposed in this paper has positive significance for performanceoptimization of relational database.