摘要
总结现阶段MySQL数据库一些常见优化手段,论述了MySQL数据库存储引擎所适用的各类场合以及索引机制的优缺点,以及存储过程的优越性和硬件性能的重要性,在此基础上阐述了数据库切分技术,并提出分库的基本思路与方法,最后列出集群模型。
Common means of optimization of MySQL database at the present stage are summarized. All occa-sions where the storage engine of MySQL database can be applied and the advantages and disadvantages of indexing mechanism are discussed. In addition, the superiority in the storage process and the importance of hardware per-formance are analyzed and discussed. On this basis, database segmentation techniques are introduced, and finally the basic method of database sharding and the cluster model is put forward.
出处
《电子科技》
2013年第9期182-184,共3页
Electronic Science and Technology
关键词
存储引擎
索引
数据库切分
集群
storage engine
index
database sharding
cluster
