Login/Register | Contact Us | 1+ 978-528-4660

VoltDB Performance Guide

Performance Guide

Table of Contents

Preface
1. Organization of this Manual
2. Other Resources
1. Introduction
1.1. What Affects Performance?
1.2. How to Use This Book
2. Hello, World! Revisited
2.1. Optimizing your Application for VoltDB
2.2. Applying Hello World to a Practical Problem
2.3. Partitioned vs. Replicated Tables
2.3.1. Defining the Partitioning Column
2.3.2. Creating the Stored Procedures
2.4. Using Asynchronous Stored Procedure Calls
2.4.1. Understanding Asynchronous Programming
2.4.2. The Callback Procedure
2.4.3. Making an Asynchronous Procedure Call
2.5. Connecting to all Servers
2.6. Putting it All Together
2.7. Next Steps
3. Understanding VoltDB Execution Plans
3.1. How VoltDB Selects Execution Plans for Individual SQL Statements
3.2. Understanding VoltDB Execution Plans
3.3. Reading the Execution Plan and Optimizing Your SQL Statements
3.3.1. Evaluating the Use of Indexes
3.3.2. Evaluating the Table Order for Joins
4. Understanding VoltDB Memory Usage
4.1. How VoltDB Uses Memory
4.2. Actions that Impact Memory Usage
4.3. How VoltDB Manages Memory
4.4. How Memory is Allocated and Deallocated
4.5. Controlling How Memory is Allocated
4.6. Understanding Memory Usage for Specific Applications
5. Managing Time
5.1. The Importance of Time
5.2. Using NTP to Manage Time
5.2.1. Basic Configuration
5.2.2. Troubleshooting Issues with Time
5.2.3. Correcting Common Problems with Time
5.2.4. Example NTP Configuration
5.3. Configuring NTP in a Hosted, Virtual, or Cloud Environment
5.3.1. Considerations for Hosted Environments
5.3.2. Considerations for Virtual and Cloud Environments

List of Figures

2.1. Synchronous Procedure Calls
2.2. Asynchronous Procedure Calls
4.1. The Three Types of Memory in VoltDB
4.2. Details of Memory Usage During and After an SQL Statement
4.3. Controlling the Java Heap Size

List of Examples

5.1. Custom NTP Configuration File
copyright 2012 VoltDB, Inc.