Article

Large scale Itanium® 2 processor OLTP workload characterization and optimization

Authors:

Badriddine KhessibAuthors Info & Claims

DaMoN '06: Proceedings of the 2nd international workshop on Data management on new hardware

Pages 3 - es

https://doi.org/10.1145/1140402.1140406

Published: 25 June 2006 Publication History

Abstract

Large scale OLTP workloads on modern database servers are well understood across the industry. Their runtime performance characterizations serve to drive both server side software features and processor specific design decisions but are not understood outside of the primary industry stakeholders. We provide a rare glimpse into the performance characterizations of processor and platform targeted software optimizations running on a large-scale 32 processor, Intel® Itanium® 2 based, ccNUMA platform.

References

[1]

Barroso, L. A.; Gharachorloo, K.; Bugnion, E. Memory system characterization of commercial workloads. Computer Architecture, 1998. Proceedings. The 25th Annual International Symposium on, 27 June-1 July 1998 Page(s):3 -- 14

Digital Library

[2]

Black, J. E.; Wright, D. F.; Salgueiro, E. M. Improving the performance of OLTP workloads on SMP computer systems by limiting modified cache lines. Workload Characterization, 2003. WWC-6. 2003 IEEE International Workshop on 27 Oct. 2003 Page(s):21 -- 29

[3]

Hankins, R.; Diep, T.; Annavaram, M.; Hirano, B.; Eri, H.; Nueckel, H.; Shen, J. P. Scaling and characterizing database workloads: bridging the gap between research and practice. Microarchitecture, 2003. MICRO-36. Proceedings. 36th Annual IEEE/ACM International Symposium on, 2003 Page(s):151 -- 162

Digital Library

[4]

Hoflehner, Gerolf; Kirkegaard, Knud; Skinner, Rod; Lavery, Daniel; Lee, Yong-Fong; Li, Wei Compiler Optimizations for Transaction Processing Workloads on Itanium Linux Systems. Proceedings of the 37th annual IEEE/ACM International Symposium on Microarchitecture MICRO 37, December 2004.

Digital Library

[5]

Hewlett-Packard Corporation, HP Integrity TPC-C Results. Transaction Processing Performance Council website, reported November 29, 2005. http://www.tpc.org/results/individual_results/HP/hp_orca1tb_win64_ex.pdf

[6]

Hsu, W.; Smith, A.; Young, H. Characteristics of Production Database Workloads and the TPC Benchmarks. IBM Systems Journal 40, No. 3, 2001

Digital Library

[7]

Intel Corporation, Intel® Itanium® 2 Processor Reference Manual For Software Development and Optimization. ftp://download.intel.com/design/Itanium2/manuals/25111003.pdf, May 2004, Section 11.

[8]

Intel Corporation, Intel Itanium Software Developer's Manual, Volume 1, 2, and 3. http://developer.intel.com/design/Itanium/manuals/iiasdmanual.htm

[9]

Keeton, Kimberly; Patterson, David A.; He, Yong Qiang; Raphael, Roger C.; Baker, Walter E. Performance characterization of a Quad Pentium Pro SMP using OLTP workloads. ACM SIGARCH Computer Architecture News, Proceedings of the 25th annual international symposium on Computer architecture ISCA '98, Vol. 26(3)

Digital Library

[10]

Kundu, Partha; Annavaram, Murali; Diep, Trung; Shen, John A Case for Shared Instruction Cache on Chip Multiprocessors running OLTP. ACM SIGARCH Computer Architecture News, Vol. 32, No. 3, June 2004 Pages: 11--18

Digital Library

[11]

Kunkel, S.; Armstrong, B.; Vitale, P. System optimization for OLTP workloads. Micro, IEEE, Volume 19, Issue 3, May-June 1999, Page(s):56 -- 64

Digital Library

[12]

Lo, J. L; Barroso, L. A.; Eggars, S. J.; Garachorloo, K.; Levy, H. M.; Parekh, S. S. An analysis of database workload performance on simultaneous multithreaded processors. ACM SIGARCH Computer Architecture News, Proceedings of the 25th annual international symposium on Computer architecture ISCA '98, Vo. 26(3). April 1998.

Digital Library

[13]

Mellor-Crummey, John M.; Scott, Michael L. Algorithms for scalable synchronization on shared-memory multiprocessors. ACM Transactions on Computer Systems (TOCS), Vol. 9(1), Feb. 1991.

Digital Library

[14]

Nurvitadhi, Eriko; Chalainanont, Nirut; Lu, Shih-Lien Characterizations of L3 Cache Behavior of SPECjAppServer 2002 and TPC-C. Supercomputing ICS'05, Proceedings of the 19th annual international conference on. June 2005.

Digital Library

[15]

Ramirez, Alex; Barroso, Luiz André; Gharachorloo, Kourosh; Cohn, Robert; Larriba-Pey, Josep P.; Lowney, Geoffrey; Valero, Mateo Code layout optimizations for transaction processing workloads. ACM SIGARCH Computer Architecture News, Proceedings of the 28th annual international symposium on Computer architecture ISCA '01, Volume 29 Issue 2 May 2001

Digital Library

[16]

Transaction Processing Performance Council TPC Benchmark C, Standard Specification, Revision 5.6. http://www.tpc.org/tpcc/spec/tpcc_current.pdf, December 2005.

[17]

Transaction Processing Performance Council, Top 10 Non-clustered TPC-C by Performance Version 5 Results. http://www.tpc.org/tpcc/results/tpcc_perf_results.asp?resultty pe=noncluster. As of April 2004

Cited By

Zhu LZhang Z(2024)Software Failure Prediction Based On Program State and First-Error CharacteristicsThe Computer Journal10.1093/comjnl/bxae02567:8(2559-2572)Online publication date: 23-Mar-2024
https://doi.org/10.1093/comjnl/bxae025
Yan Cui Yu Chen Yuanchun Shi (2010)Scaling OLTP applications on commodity multi-core platforms2010 IEEE International Symposium on Performance Analysis of Systems & Software (ISPASS)10.1109/ISPASS.2010.5452034(134-143)Online publication date: Mar-2010
https://doi.org/10.1109/ISPASS.2010.5452034
Chai BLiu DZhao JYang W(2009)A Study of High Concurrency Workload Influence on Modern ProcessorProceedings of the 2009 Eighth IEEE International Conference on Dependable, Autonomic and Secure Computing10.1109/DASC.2009.109(642-647)Online publication date: 12-Dec-2009
https://dl.acm.org/doi/10.1109/DASC.2009.109
Show More Cited By

Index Terms

Large scale Itanium® 2 processor OLTP workload characterization and optimization

Recommendations

Micro-architectural Analysis of In-memory OLTP
SIGMOD '16: Proceedings of the 2016 International Conference on Management of Data

Micro-architectural behavior of traditional disk-based online transaction processing (OLTP) systems has been investigated extensively over thepast couple of decades. Results show that traditional OLTP mostly under-utilize the available micro-...
Performance Characterization of Itanium® 2-Based Montecito Processor
Proceedings of the 2009 SPEC Benchmark Workshop on Computer Performance Evaluation and Benchmarking

This paper presents the performance characteristics of the Intel®Itanium®2-based Montecito processor and compares its performance to the previous generation Madison processor. Measurements on both are done using the industry-standard SPEC CPU2006 ...
Software-Controlled Priority Characterization of POWER5 Processor

Due to the limitations of instruction-level parallelism, thread-level parallelism has become a popular way to improve processor performance. One example is the IBM POWER5TM processor, a two-context simultaneous-multithreaded dual-core chip. In each SMT ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

DaMoN '06: Proceedings of the 2nd international workshop on Data management on new hardware

June 2006

49 pages

ISBN:1595934669

DOI:10.1145/1140402

Conference Chairs:
Anastassia Ailamaki
Carnegie Mellon University
,
Peter Boncz
CWI Amsterdam
,
Stefan Manegold
CWI Amsterdam

Copyright © 2006 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 June 2006

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Acceptance Rates

DaMoN '06 Paper Acceptance Rate 6 of 6 submissions, 100%;

Overall Acceptance Rate 94 of 127 submissions, 74%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
361
Total Downloads

Downloads (Last 12 months)3
Downloads (Last 6 weeks)0

Reflects downloads up to 26 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Zhu LZhang Z(2024)Software Failure Prediction Based On Program State and First-Error CharacteristicsThe Computer Journal10.1093/comjnl/bxae02567:8(2559-2572)Online publication date: 23-Mar-2024
https://doi.org/10.1093/comjnl/bxae025
Yan Cui Yu Chen Yuanchun Shi (2010)Scaling OLTP applications on commodity multi-core platforms2010 IEEE International Symposium on Performance Analysis of Systems & Software (ISPASS)10.1109/ISPASS.2010.5452034(134-143)Online publication date: Mar-2010
https://doi.org/10.1109/ISPASS.2010.5452034
Chai BLiu DZhao JYang W(2009)A Study of High Concurrency Workload Influence on Modern ProcessorProceedings of the 2009 Eighth IEEE International Conference on Dependable, Autonomic and Secure Computing10.1109/DASC.2009.109(642-647)Online publication date: 12-Dec-2009
https://dl.acm.org/doi/10.1109/DASC.2009.109
Liu DWang SQin BGong W(2007)Characterizing DSS Workloads from the Processor PerspectiveProceedings of the APWeb/WAIM 2007 DBMAN, WebETrends, PAIS and ASWAN international workshops on Advances in Web and Network Technologies, and Information Management10.1007/978-3-540-72909-9_26(235-240)Online publication date: 16-Jun-2007
https://dl.acm.org/doi/10.1007/978-3-540-72909-9_26

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten