No Detail Found!

Research on performance optimization of oltp systems based on innodb.

Author(s)
Xiangsheng Kong Department of Computer & Information, Xinxiang University, Xinxiang, China
Abstract
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 & readahead 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.
Publication Details
Page(s) 638-642
DOI DOI not available
Published Journal: Journal of Theoretical and Applied Information Technology, Volume: 46, Issue: 2, Year: 2012

Request the full text from PASTIC

0

Citations

0

Downloads

41

Views