高并发环境下MySQL软硬件配置优化  

The Optimization of MySQL Software and Hardware Configurations under the Circumstance of Overload

作　　者：范新民[1] 

机构地区：[1]福建师范大学网络与继续教育学院,福建福州350007

出　　处：《福建师范大学学报（自然科学版）》2013年第6期49-54,共6页Journal of Fujian Normal University：Natural Science Edition

摘　　要：通过分析生产环境中的测试结果,给出了MySQL关键配置的优化策略:存储引擎使用InnoDB、表空间配置单表拆分以及写入策略采用非阻塞磁盘缓存机制.同时,给出了这些配置相对应的服务器硬件需求:硬盘使用固态SSD硬盘,内存使用支持ECC校验的企业级内存.Through the analysis of test results under the production environment, the optimal strategies of MySQL＇s critical configurations have been drawn out as follows： InnoDB is taken as storage engine, and non-blocking disk-cache system is taken for splitting the single table of the con- figuration of table space and writing access strategy. At the same time, the corresponding server hardware of these critical configurations has been required as follows： take the solid state SSD as rigid disk, and the enterprise-class RAM supporting the verification of ECC as memory.

关 键 词：MYSQL INNODB SSD ECC校验 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]