大数据环境下的MySQL优化技术探讨  

Discussion on MySQL Optimization Technology in Large Data Environment

作　　者：韦美雁 段华斌 周新林 WEI Mei-yan;DUAN Hua-bin;ZHOU Xin-lin(College of Electronics and Information Engineering,Hunan University of Science and Engineering,Yongzhou 425199;The County of Qiyang Dazhong Bridge Second Middle School,Yongzhou 426100)

机构地区：[1]湖南科技学院电子与信息工程学院,永州425199 [2]湖南祁阳大忠桥第二中学,永州426100

出　　处：《现代计算机》2018年第20期68-72,共5页Modern Computer

基　　金：湖南省教改课题资助(湘教通[2016]400);湖南省"十三五"专业综合改革项目资助(湘教通[2013]223);湖南科技学院计算机应用技术重点学科资助

摘　　要：在如今的信息时代,数据量的激增对数据库的性能要求越来越高,因而会时常遇到性能瓶颈,导致系统负荷极大甚至宕机。为了优化MySQL数据库的性能,从存储引擎的选择、SQL的优化、表的优化等几个方面进行讨论,并提出设计阶段要注意的事项以及应用系统上线后遇到性能瓶颈时的处理措施。In the information age,the increase of the data quantity is more and more demanding for the performance of the database,so the perfor-mance bottleneck is often encountered,which leads to the system load and even the downtime.In order to optimize the performance of the database,the paper discusses the selection of the storage engine,the optimization of the SQL,the optimization of the table and so on,and puts forward the matters needing attention at the design stage and the handling measures of the performance bottleneck after the application system is on line.

关 键 词：MYSQL 存储引擎 优化 逆规范化 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]