###

DOI:

计算机系统应用英文版:2011,20(8):195-198,215

View/Add Comment 过刊浏览高级检索 HTML

←前一篇 | 后一篇→

码上扫一扫！

下载全文

一种基于闪存固态硬盘的辅助缓冲池设计

姜承尧, 陈庆奎, 钱剑飞

(上海理工大学光电信息与计算机工程学院,上海 200093)

Design of Secondary Buffer Pool Based on Flash Memory SSD

JIANG Cheng-Yao, CHEN Qing-Kui, QIAN Jian-Fei

(School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China)

摘要

图/表

参考文献

相似文献

本文已被：浏览 1799次下载 3174次
Received:November 28, 2010 Revised:January 08, 2011

中文摘要: 基于磁盘数据库系统的瓶颈主要在磁盘I/O,通常采用缓冲池的设计,将读到的数据页先放入到内存缓冲池后再进行操作.因此,缓存池的大小直接决定了数据库的性能.通过研究基于闪存固态硬盘的特性,提出了一种基于闪存固态硬盘的辅助缓冲池设计.最后,通过修改开源数据库MySQL InnoDB存储引擎,并通过TPC-C实验对比分析了启用辅助缓冲池后数据库的性能可有100%～320%的提高.

中文关键词: 数据库缓冲池闪存固态硬盘在线事务处理优化

Abstract:Disk based on database performance mainly depends on the disk IO speed. Generally, database system has a large buffer pool, where the db operations take place. Hence, the database performance depends on the size of buffer pool. In this paper, we propose a secondary buffer pool solution based on the flash memory SSD(solid state drive), which uses the high random access speed and high IOPS feature of the SSD. We implemented our solution within MySQL InnoDB. Our real machine experiments running online transaction processing workloads (TPCC) show that after enabling secondary buffer pool, the database performance will achieves up to 100% ~ 320% improvements.

keywords: database buffer pool flash memory SSD online transaction processing optimization

文章编号： 中图分类号： 文献标志码：

基金项目:国家自然科学基金(60573108);上海市科学技术委员会基金(09511501000,09220502800)

Author Name	Affiliation
JIANG Cheng-Yao	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China
CHEN Qing-Kui	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China
QIAN Jian-Fei	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China

Author Name	Affiliation
JIANG Cheng-Yao	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China
CHEN Qing-Kui	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China
QIAN Jian-Fei	School of Optical-Electrical and Computer Engineering, University of Shanghai for Science and Technology, Shanghai 200093, China

引用文本：
姜承尧,陈庆奎,钱剑飞.一种基于闪存固态硬盘的辅助缓冲池设计.计算机系统应用,2011,20(8):195-198,215
JIANG Cheng-Yao,CHEN Qing-Kui,QIAN Jian-Fei.Design of Secondary Buffer Pool Based on Flash Memory SSD.COMPUTER SYSTEMS APPLICATIONS,2011,20(8):195-198,215