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.

TIGER: Thermal-Aware File Assignment in Storage Clusters

Effectively Mitigating I/O Inactivity In Vcpu Scheduling

Itad: I/O Thermal Aware Data Center Model

Towards Thermal-Aware Hadoop Clusters

Thermal-Aware Task Placement with Dynamic Thermal Model in an Established Datacenter

An End-to-end and Adaptive I/O Optimization Tool for Modern HPC Storage Systems

Thermal-aware layout planning for heterogeneous datacenters

iDataCool: HPC with Hot-Water Cooling and Energy Reuse

An Effective File Migration Algorithm in Cluster File Systems

Regulating CPU Temperature With Thermal-Aware Scheduling Using a Reduced Order Learning Thermal Model

I/O Workload Management for All-Flash Datacenter Storage Systems Based on Total Cost of Ownership

TERN: A Self-Adjusting Thermal Model for Dynamic Resource Provisioning in Data Centers

Power and thermal-aware virtual machine scheduling optimization in cloud data center

Energy-Efficient Real-Time Task Allocation in a Data Center.

Study of hot air recirculation and thermal management in data centers by using temperature rise distribution

Thermal-aware virtual machine placement based on multi-objective optimization

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

Towards Thermal-Aware Workload Distribution in Cloud Data Centers Based on Failure Models

Cost-Aware Region-Level Data Placement in Multi-Tiered Parallel I/O Systems.

TESLA: Thermally Safe, Load-Aware, and Energy-Efficient Cooling Control System for Data Centers

Artificial Intelligence-Based Temperature Twinning and Pre-Control for Data Center Airflow Organization