MySQL 新技术研究与实践

xychamp

贡献于2013-01-16

字数:0 关键词: MySQL 数据库服务器 SQL

1 MySQL 新技术研究与实践 周振兴 @Taobao DBA 2010-12-06 iData Forum Power by Taobao DBA 关于主题 • Performance – Hardware – Software • Patches – InnoDB-SSD Online file added ...... – OSC from FB Power by Taobao DBA is about the Capacity 200,0000,0000 请求 Cache Miss Capacity 20% === 1 亿 用户 Performance is also about the Cost && Technology Power by Taobao DBA Flashcache 原理 /dev/sda /dev/sdb /dev/mapper/cachedev 这就是 Flashcache : 将两个块设备,虚拟成一个带 缓存的块设备 File System VFS http://orczhou.com Power by Taobao DBA 安装 • 参考 Flashcache README ./flashcache_create cachedev /dev/fio /dev/sda12 mount /dev/mapper/cachedev /u01 Power by Taobao DBA WB vs WT • Write back – High performance – main version of flashcache • Write through – more safe – Less performance Power by Taobao DBA Flashcache 0 2 4 6 8 10 12 TPS Power by Taobao DBA A fixed bug • MySQL hungs with Flashcache • Latest version has fixed it iostat 1 sda12 0 0 0 0 0 0 0 0 0 0 0 fio 0 0 0 0 0 0 0 0 0 0 0 dm-0 0 0 0 0 0 0 0 0 0 0 100 Power by Taobao DBA InnoDB Plugin/Percona • Percona is Cool • InnoDB is Fine Power by Taobao DBA 压缩特性 • Sample Page Power by Taobao DBA 压缩特性 • 空间节约 • 性能提升 Power by Taobao DBA Buffer Pool Power by Taobao DBA Patch From Taobao • InnoDB-SSD • No more connection • Online tablespace added • ... Table DML statistics ... Power by Taobao DBA Why patch • Should we change the something? Power by Taobao DBA Contributor • 林晓斌 From Taobao.com Power by Taobao DBA Patch.1 SSD • Write Through – 读优化 Power by Taobao DBA Patch.2 No more connection • Close the door • Why not – max_connection Power by Taobao DBA Patch.3 Online data added • InnoDB share table space – You must restart your Database 我们不想因此而降低可用性 Power by Taobao DBA Q & A • That’s all

下载文档,方便阅读与编辑

文档的实际排版效果,会与网站的显示效果略有不同!!

需要 6 金币 [ 分享文档获得金币 ] 0 人已下载

下载文档

相关文档