MySQL案例分析与使用优化技巧.ppt

MySQL DBA Bootcamp for Oracle DBAs 6. Performance Analysis (c) Copyright 2007. MySQL Inc * * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features * Cox communications, stats on downtime - Weather channel, hurricane Katrina - Don’t need tons of esoteric features. 80% of database installs use only 30% of features MySQL—操作使用 Agenda MySQL Performance Tuning MySQL ---项目整体优化 项目选型期--------MySQL体系架构 项目实施初期-----MySQL建模设计 项目实施前期-----MySQL系统选型 项目实施中期-----MySQL 配置参数 项目实施后期-----MySQL 语句调整 MyISAM引擎：数据存储无限制、支持压缩、读响应快速 InnoDB引擎： 支持事务、支持外键、数据缓存技术 Memory 引擎：贮存在 RAM中速度最快; 关机后数据丢失 Archive引擎： 自动压缩数据，高达70%压缩比例 NDB引擎： 无共享数据分布存储集群，99.999%可靠性 CSV引擎： 是EXCL格式的MySQL内置存储引擎 ? 主要特点 ? 适用案例 MyISAM: 20%写、80%读应用；数据仓库系统 InnoDB: 高并发交易系统、统计系统、财务系统 Memory: 临时统计表、热点临时数据 Archive： 历史归档、经营分析系统 NDB : 电信级高可用系统、Session和用户管理系统 CSV : 电子表格，报表等特殊应用情形 MySQL