摘要
通过分析生产环境中的测试结果,给出了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.
出处
《福建师范大学学报（自然科学版）》
CAS
CSCD
北大核心
2013年第6期49-54,共6页
Journal of Fujian Normal University：Natural Science Edition
