Optimization Design Method of Cache Extension in MySQL Database
Jianyun Ni, Shuzhi Xie, Zihao Li, Chao Jia · 2018
MySQL database has been widely used by many large, medium and small enterprises with its open source, lightweight and multi thread, support high concurrency. In the face of high concurrency access to large amounts of data in the network system, the overall design of the database plays an important role in determining system performance. How to optimize the database so that it does not affect the overall performance of the server system during data access becomes a top priority. Based on this situation, this thesis introduces how to optimize the design of MySQL database on large data volume and high concurrency issues. Starting from the choice of different storage engines, through a lot of experiments, verify and analyze different storage engines and caching technologies to solve the database query and Insert equal amount of concurrent execution efficiency.