文献类型：期刊文献

英文题名：Research on performance optimization of OLTP systems based on innoDB

作者：Kong, Xiangsheng[1]

第一作者：孔祥盛

通讯作者：Kong, X.

机构：[1] Department of Computer and Information, Xinxiang University, Xinxiang, China

第一机构：新乡学院计算机与信息工程学院

通讯机构：[1]Department of Computer and Information, Xinxiang University, Xinxiang, China|[1107118]新乡学院计算机与信息工程学院;[11071]新乡学院;

年份：2012

卷号：46

期号：2

起止页码：638-642

外文期刊名：Journal of Theoretical and Applied Information Technology

收录：EI(收录号：20130215899584);Scopus(收录号：2-s2.0-84872020103)

语种：英文

外文关键词：Database systems - Lakes

摘要：The technology of flash memory SSDs (solid state drives) which are increasingly adopted in a wide spectrum of storage systems has the potential of changing the database architecture and principles. With the high random access speed and high IOPS of the SSD, this paper describes a secondary buffer pool & read-ahead solution based on OLTP for MySQL InnoDB which can reduce I/O requests & latency and improve flash-based database system performance a lot. Based on the buffer pool & read-ahead solution, this paper provide an experience on running online transaction processing workloads (TPCC) which show that the database performance will achieve up to 120%-320% improvements. ? 2005-2012 JATIT & LLS. All rights reserved.