Characterizing and optimizing TPC-C workloads on large-scale systems using SSD arrays

来源 :Science China(Information Sciences) | 被引量 : 0次 | 上传用户:caesarsarahluckgirl
下载到本地 , 更方便阅读
声明 : 本文档内容版权归属内容提供方 , 如果您对本文有版权争议 , 可与客服联系进行内容授权或下架
论文部分内容阅读
Transaction processing performance council benchmark C(TPC-C) is the de facto standard for evaluating the performance of high-end computers running on-line transaction processing applications. Differing from other standard benchmarks, the transaction processing performance council only defines specifications for the TPC-C benchmark, but does not provide any standard implementation for end-users. Due to the complexity of the TPC-C workload, it is a challenging task to obtain optimal performance for TPC-C evaluation on a large-scale high-end computer. In this paper, we designed and implemented a large-scale TPC-C evaluation system based on the latest TPC-C specification using solid-state drive(SSD) storage devices. By analyzing the characteristics of the TPC-C workload, we propose a series of system-level optimization methods to improve the TPC-C performance. First, we propose an approach based on Small File table space to organize the test data in a round-robin method on all of the disk array partitions; this can make full use of the underlying disk arrays.Second, we propose using a NOOP-based disk scheduling algorithm to reduce the utilization rate of processors and improve the average input/output service time. Third, to improve the system translation lookaside buffer hit rate and reduce the processor overhead, we take advantage of the huge page technique to manage a large amount of memory resources. Lastly, we propose a locality-aware interrupt mapping strategy based on the asymmetry characteristic of non-uniform memory access systems to improve the system performance. Using these optimization methods, we performed the TPC-C test on two large-scale high-end computers using SSD arrays. The experimental results show that our methods can effectively improve the TPC-C performance. For example, the performance of the TPC-C test on an Intel Westmere server reached 1.018 million transactions per minute. Transaction processing performance council benchmark C (TPC-C) is the de facto standard for evaluating the performance of high-end computers running on-line transaction processing applications. Differing from other standard benchmarks, the transaction processing performance council only defines specifications for the TPC -C benchmark, but does not provide any standard implementation for end-users. Due to the complexity of the TPC-C workload, it is a challenging task to obtain optimal performance for TPC-C evaluation on a large-scale high-end computer . This paper, we designed and implemented a large-scale TPC-C evaluation system based on the latest TPC-C specification using solid-state drive (SSD) storage devices. By analyzing the characteristics of the TPC-C workload, we propose a series of system-level optimization methods to improve the TPC-C performance. First, we propose an approach based on Small File table space to organize the test data in a round-robin method on all of the disk array partitions; this can make full use of the underlying disk arrays. Second, we propose using a NOOP-based disk scheduling algorithm to reduce the utilization rate of processors and improve the average input / output service time. Third, to improve the system translation lastly, we propose a locality-aware interrupt mapping strategy based on the asymmetry characteristic of non-uniform memory access systems Using these optimization methods, we performed the TPC-C test on two large-scale high-end computers using SSD arrays. The experimental results show that our methods can effectively improve the TPC-C performance. For example, the performance of the TPC-C test on an Intel Westmere server reached 1.018 million transactions per minute.
其他文献
报告本病45例的临床回顾。确诊前误诊为脑膜炎4人,癔病1人,精神分裂症1人,颅内占位性病变1人,误诊率15.6%,误诊原因是对本病认识不足,未及时作腰穿等进一步检查。发病诱因仅1
髓鞘硷性蛋白(MBP)是神经组织特有的成份,故MBP释放到脑脊液(CSF)中可见于神经组织的破坏性病变。作者采用灵敏的放射免疫方法对50例 Myelin basic protein (MBP) is a spe
应用微生物土壤保健集成技术,实施科学种田良方、良种配套管理,是从土壤源头解决粮食安全和食品安全问题的根本有效措施;是保障农作物优质、高产、高效、农业可持续发展的关
1973年4月~1979年9月,我院共收治“非特异性脑炎”病人215例。其中在1978年11月~1979年9月间收治的37例中,有9例于“脑炎”发病前曾服过“驱虫净”(四咪唑)。现将这9例的临床
班主任中途接班,往往都是纪律成绩出现问题的班级,如何顺利地开展工作,离不开以下几个方面。一、迅速了解学生情况和班级状况。一般接手一个班级,都在一个学期的结束或开始时
病人,女,78岁.2002年7月26日上午8∶00在活动中突然感觉左下肢疼痛,伴大汗淋漓及四肢无力,而被家人扶上床休息,而后疼痛无好转,出现头晕及四肢无力紧急就诊.体检:急性病容,面色苍白,大汗淋漓,体温36.6℃,脉搏46~48次,呼吸24次,血压80/55 mmHg.双肺呼吸音粗,未闻及罗音,心率46~48次,律不齐,可闻及早搏.急诊心电图提示:Ⅱ、Ⅲ、avF导联ST段抬高0.4~0.5 mv
谁影响儿童智商丹麦社会学家研究认为,是父亲!常与父亲相处的儿童智商高。小孩生下后大都由母亲照料,这时如果有父亲介入,便可使婴儿开始体会转变、差别、分离等感情。同父
整风运动给我们带来了无比高涨的革命干劲。在总路线光辉照耀下,全区医藥人员精神振奋,干劲冲天,节约气象,一片光明,千方百计挖掘潜力,给伤病员以经济而技术优良的治疗。今
教育的最终目的不是传授已有的东西,而是要把人的创造力量诱导出来,将人的生命感和价值感“唤醒”。衡量一堂生物课成功与否,不在于教师讲得是否精彩,而在于学生学得是否出彩
网络技术的迅速发展和网络的普及,给教育带来一系列的新变化。如何利用网络资源进行语文探究性教学,培养学生发现、利用和创造信息的能力,提高自己的实践和创新能力,整体提高