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.

Characterizing TPC-H on a Clustered Database Engine from the OS Perspective

Decision-support Workload Characteristics on a Clustered Database Server from the OS Perspective

Characterizing the Scalability of Decision-Support Workloads on Clusters and SMP Systems.

Hybrid Performance Modeling And Analyzing Of Parallel Systems

Time-sharing Parallel Applications Through Performance-Targeted Feedback-Controlled Real-Time Scheduling.

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

Analyzing & modeling the performance in Xen-based virtual cluster environment

Energy-Proportional Query Processing on Database Clusters.

A Two-Level Parallel Decomposition Approach for Transient Stability Constrained Optimal Power Flow

Approaches to performance improvement and experiments on a cluster system THNPSC-1

Understanding the effect of data center resource disaggregation on production DBMSs

Tmss: A Task Management And Scheduler System In Cluster For Remote Computing Service

Scaling OLTP Applications on Commodity Multi-Core Platforms

Synthesizing Representative I/O Workloads for TPC-H

Designing a High Performance Parallel Personal Cluster

Scheduling Best-Effort and Real-Time Pipelined Applications on Time-Shared Clusters.

24/7 Characterization of petascale I/O workloads

Parallel Database Middleware Based on CORBA

Analysis of Structure and Performance of PC Clusters

Logp Analysis Of User Level Network Cluster System

Automatically Constructing Trusted Cluster Computing Environment