• Home
  • Search
  • Code layout optimizations for transaction processing workloads
  • Open Access IconOpen Access
  • Cite Icon73
  • https://doi.org/10.1145/379240.379260Copy DOI Icon

Code layout optimizations for transaction processing workloads

  • Jan 1, 2001
  • Alex Ramirez +6 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Commercial applications such as databases and Web servers constitute the most important market segment for high-performance servers. Among these applications, on-line transaction processing (OLTP) workloads provide a challenging set of requirements for system designs since they often exhibit inefficient executions dominated by a large memory stall component. This behavior arises from large instruction and data footprints and high communication miss rates. A number of recent studies have characterized the behavior of commercial workloads and proposed architectural features to improve their performance. However, there has been little research on the impact of software and compiler-level optimizations for improving the behavior of such workloads.This paper provides a detailed study of profile-driven compiler optimizations to improve the code layout in commercial workloads with large instruction footprints. Our compiler algorithms are implemented in the context of Spike, an executable optimizer for the Alpha architecture. Our experiments use the Oracle commercial database engine running an OLTP workload, with results generated using both full system simulations and actual runs on Alpha multiprocessors. Our results show that code layout optimizations can provide a major improvement in the instruction cache behavior, providing a 55% to 65% reduction in the application misses for 64-128K caches. Our analysis shows that this improvement primarily arises from longer sequences of consecutively executed instructions and more reuse of cache lines before they are replaced. We also show that the majority of application instruction misses are caused by self-interference. However, code layout optimizations significantly reduce the amount of self-interference, thus elevating the relative importance of interference with operating system code. Finally, we show that better code layout can also provide substantial improvements in the behavior of other memory system components such as the instruction TLB and the unified second-level cache. The overall performance impact of our code layout optimizations is an improvement of 1.33 times in the execution time of our workload.

Similar Papers
  • Research Article
  • Citations11

Code layout optimizations for transaction processing workloads

  • May 01, 2001
  • ACM SIGARCH Computer Architecture News
  • Alex Ramirez +6
  • Conference Article
  • Citations6

Improving cache performance of network intensive workloads

  • Jan 01, 2001
  • U Vallamsetty +3
  • Research Article
  • Citations46

Piranha

  • May 01, 2000
  • ACM SIGARCH Computer Architecture News
  • Luiz André Barroso +8
  • Conference Article
  • Citations57

Scaling and Charact rizing Database Workloads: Bridging the Gap between Research and Practice

  • Dec 03, 2003
  • Richard A Hankins +6
  • Book Chapter
  • Citations1

Qcomp: A tool for assessing online transaction processing scalability

  • Jan 01, 1994
  • Neil J Gunther
  • Research Article
  • Citations11

Performance of database workloads on shared-memory systems with out-of-order processors

  • Oct 01, 1998
  • ACM SIGOPS Operating Systems Review
  • Parthasarathy Ranganathan +3
  • Research Article
  • Citations8

Managing energy-performance tradeoffs for multithreaded applications on multiprocessor architectures

  • Jun 12, 2007
  • ACM SIGMETRICS Performance Evaluation Review
  • Soyeon Park +3
  • Conference Article
  • Citations2

Indexing large updatable datasets in multi-version database management systems

  • Jan 01, 2019
  • Christian Riegger +2
  • Conference Article
  • Citations85

KAML: A Flexible, High-Performance Key-Value SSD

  • Feb 01, 2017
  • Yanqin Jin +3
  • Research Article
  • Citations272

Staring into the abyss

  • Nov 01, 2014
  • Proceedings of the VLDB Endowment
  • Xiangyao Yu +4
  • Conference Article
  • Citations6

Clustered DBMS Scalability under Unified Ethernet Fabric

  • Jun 14, 2005
  • K Kant +1
  • Conference Article
  • Citations1

Data locality characterization of OLTP applications and its effects on cache performance

  • Aug 01, 2010
  • Zhang Jing +2
  • Research Article

HIERARCHICAL DEEP REINFORCEMENT LEARNING FRAMEWORK FOR ADAPTIVE CPU SCHEDULING IN HYBRID TRANSACTIONAL-ANALYTICAL DATABASES

  • Jan 01, 2025
  • AI and Data Science Journal
  • Nur Aisyah +1
  • Conference Article
  • Citations6

Leakage power characterization and minimization in 3D stacked multi-core chips with microfluidic cooling

  • Mar 01, 2014
  • He Xiao +3
  • Conference Article
  • Citations21

The IBM z15 High Frequency Mainframe Branch Predictor Industrial Product

  • May 01, 2020
  • Narasimha Adiga +5
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.