Abstract: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 SmallFile 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.

Practice of performance optimization for Tsinghua University instrument sharing platform

A collaborative performance tuning approach for Portal-based web sites

Schema-Driven Performance Evaluation for Highly Concurrent Scenarios.

Analysis and MPI Implementation of LQCD Dslash on Sunway TaihuLight*

A Scheduling Method for Service Chain in Equipment Grid

Research and implementation performance optimization of elective course system at Tsinghua University

Research On Optimization Computing Service Platform Architecture

Performance Analysis and Framework Optimization of Open Source Cloud Storage System

Lessons Learned from Optimizing the Sunway Storage System for Higher Application I/O Performance

A performance optimization framework for hardware/software co design

Performance Analysis and Improvement of Storage Virtualization in an OS-Online System

Research on Performance Optimization of Web Application System based on JAVA EE

SHA: QoS-Aware Software and Hardware Auto-Tuning for Database Systems

Simulation Analysis and Validation of Cache Performance in TransCom Systems

Performance Evaluation and Optimization of Cache Architecture for Simultaneous Multithreading Processor

Speedoo: prioritizing performance optimization opportunities.

Holistic and Opportunistic Scheduling of Background I/Os in Flash-based SSDs

Characterizing and Optimizing TPC-C Workloads on Large-Scale Systems Using SSD Arrays

Online scheduling for FPGA computation in the Cloud

Improving the Effective IO Throughput by Adaptive Read-Ahead Strategy for Private Cloud Storage Service

Implementation of Large Instrument Sharing Platform Based on District, University and Enterprise