Benchmark Software

The SysBench test suite is an open source, cross-platform, multi-threaded benchmark tool for evaluating system performance when running a database under a heavy load. Depending on the options used, SysBench can be used to test the following system components:

•File I/O performance

•Scheduler performance

•Memory allocation and transfer speed

•POSIX threads implementation performance

•Database server performance (OLTP benchmark)

The results documented in this document were obtained using the SysBench test suite to generate results in an environment using the MySQL database server on Proliant systems (x86_64) running RHEL. Table 1 lists the software versions used for the benchmark tests.

Table 1 Test Software Environment

Software

Website

SysBench version 0.4.8

http://sysbench.sourceforge.net/

Red Hat Enterprise Linux 5 AS Update 1 (RHEL5 AS u1)

N/A

MySQL database server version 5.0.46 (for an x86_64

 

system)

 

 

 

This paper describes the results of overall database server performance based on the OLTP benchmark. Because this represents a transactional workload, the InnoDB storage engine was used for the MySQL database server. Four different servers from the HP ProLiant family were used for each of the OLTP tests. Each test was performed using read-only queries and then with read/write queries and a varied number of connections. Additionally, each of the tests were performed when the MySQL data files were located on the local attached storage (SAS), as well as Fibre Channel attached Storage Area Network (SAN) on an HP StorageWorks 1500 Modular Smart Array (MSA1500).

Hardware Test Environment

This benchmark was performed within an HP BladeSystem c-Class blade enclosure with enhanced backplane using C-GbE2 Network interconnect switches. Table 2 lists the specifications of the hardware test environment.

Table 2 Test Hardware Environment

Hardware

BL460c

BL465c

BL480c

BL685c

CPU

(2) Quad-Core Intel®

(2) Dual-Core AMD

(2) Quad-Core Intel®

(2) Dual-Core AMD

 

Xeon® processor X5365

Opteron™ processor

Xeon® processor X5365

Opteron processor

 

(3.0 GHz/4MB L2 cache

2218 (2.6 GHz/1MB L2

(3.0 GHz/4MB L2 cache

Model 8218 (2.6

 

per core)

cache per core)

per core)

GHz/1MB L2 cache per

 

 

 

 

core)

Memory

16GB (8x2GB PC2-5300

14GB (6x2GB+ 2x1GB

24GB (12x2GB

12GB (6x2GB PC2-5300

 

DDR2)

PC2-5300 DDR2)

PC2-5300 DDR2)

DDR2)

Disk Storage

2 x 73GB SAS Smart

2 x 73GB SAS Smart

4 x 73GB SAS Smart

2 x 73GB SAS Smart

 

Array E200i controller

Array E200i controller

Array P400i controller

Array E200i controller

 

with Battery Backed

with Battery Backed

with Battery Backed

with Battery Backed

 

Write Cache (BBWC)

Write Cache (BBWC)

Write Cache (BBWC)

Write Cache (BBWC)

 

and Fibre Channel

and Fibre Channel

and Fibre Channel

and Fibre Channel

 

attached MSA1500

attached MSA1500

attached MSA1500

attached MSA1500

12