HP 5992-4755 manual Benchmark Software, Hardware Test Environment, Test Software Environment

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