| Online game industry is a new sunrise industries, has experienced the early20th century formation stage, and the rapid development in recent years, and now China’s online game industry in the formative stage and quickly move toward maturity. Statistics show that in2009China’s online game market, the market reached26.093billion yuan, user scale will reach107million.Variety of online games have the same base, produce and save data. One Game can produce50GB data everyday with only100000CCU. And after several months the data will over TB, even PB.How to accurately and efficiently save, and analyze the massive amounts of data, which is research direction.This paper describes the structure of the database table in a typical online game first, summed up the problems generated to the database when the game is run continuously. Such as operation slow down with the data expansion, or data maintenance problem in the game logic changed. And describes the importance and necessity to optimize the database. This paper studies the results of five aspects to optimized direction and method of the online game database.(1) Optimize theSQL. Find the low efficiency of system implementation statement, add the effective index to the table, modify the low efficiency of the query method, to do the first level optimization.(2) Adjust the parameters of the MySQL Server. To theonline game’s database, adjusting the server program parameters, to get achieve higher performance.(3) Modify the application of online games by using a connection pool, increasing application layer caching mechanism to reduce the number of operations on the database to achieve the purpose under the same conditions to support more data.(4) Change the hardware which the database server used, increase the I/O performance, so the database can support more data.(5) Use the special distributed storage, so thedatabase is able to save the huge amounts of data. And to provide a basis for subsequent data analysis. |
PDF Full Text Request