HP 5992-4755 - Manual (Page 12)

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
Website Software
http://sysbench.sourceforge.net/ SysBench version 0.4.8
N/A Red Hat Enterprise Linux 5 AS Update 1 (RHEL5 AS u1)
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
BL685c BL480c BL465c BL460c Hardware
(2) Dual-Core AMD
Opteron processor
Model 8218 (2.6
GHz/1MB L2 cache per
core) (2) Quad-Core Intel®
Xeon® processor X5365
(3.0 GHz/4MB L2 cache
per core) (2) Dual-Core AMD
Opteron™ processor
2218 (2.6 GHz/1MB L2
cache per core) (2) Quad-Core Intel®
Xeon® processor X5365
(3.0 GHz/4MB L2 cache
per core) CPU
12GB (6x2GB PC2-5300
DDR2) 24GB (12x2GB
PC2-5300 DDR2) 14GB (6x2GB+ 2x1GB
PC2-5300 DDR2) 16GB (8x2GB PC2-5300
DDR2) Memory
2 x 73GB SAS Smart
Array E200i controller
with Battery Backed
Write Cache (BBWC)
and Fibre Channel
attached MSA1500 4 x 73GB SAS Smart
Array P400i controller
with Battery Backed
Write Cache (BBWC)
and Fibre Channel
attached MSA1500 2 x 73GB SAS Smart
Array E200i controller
with Battery Backed
Write Cache (BBWC)
and Fibre Channel
attached MSA1500 2 x 73GB SAS Smart
Array E200i controller
with Battery Backed
Write Cache (BBWC)
and Fibre Channel
attached MSA1500 Disk Storage
12