Table 2 Test Hardware Environment (continued)

Hardware

BL460c

BL465c

BL480c

BL685c

File System

(ext3 – no LVM):

(ext3 – no LVM):

(ext3 – no LVM):

(ext3 – no LVM):

Partitioning

Disk0: /, /boot, swap

Disk0: /, /boot, swap

Disk0: /, /boot, swap

Disk0: /, /boot, swap

 

Disk1: FC attach – 7

Disk1: FC attach – 7

Disk1: FC attach – 7

Disk1: FC attach – 7

 

36GB disks 10k RPM,

36GB disks 10k RPM,

36GB disks 10k RPM,

36GB disks 10k RPM,

 

RAID 0

RAID 0

RAID 0

RAID 0

Operating

RHEL5 AS u1 SMP

RHEL5 AS u1 SMP

RHEL5 AS u1 SMP

RHEL5 AS u1 SMP

System

kernel (2.6.18-53.el5)

kernel (2.6.18-53.el5)

kernel (2.6.18-53.el5)

kernel (2.6.18-53.el5)

 

with errata updates

with errata updates

with errata updates

with errata updates

 

 

 

 

 

SysBench Configuration

The OLTP test mode emulates real database usage by issuing common SQL queries on typical table structures. SysBench populates the following table with oltp-table-size rows at the beginning of the test.

CREATE TABLE `sbtest` (

`id` int(10) unsigned NOT NULL auto_increment, `k` int(10) unsigned NOT NULL default '0', `c` char(120) NOT NULL default '',

`pad` char(60) NOT NULL default '', PRIMARY KEY (`id`),

KEY `k` (`k`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

To test general purpose database performance, the complex test mode was used. The InnoDB storage engine supports ACID compliant transactions; therefore, the SysBench uses BEGIN/COMMIT statements around each of the transactions. Table 3 lists the SQL queries used in testing.

Table 3 SQL Queries

Type of Query

SQL Query Syntax

Point queries

SELECT c FROM sbtest WHERE id=N

Range queries

SELECT c FROM sbtest WHERE id BETWEEN N and M

Range SUM()

SELECT SUM(c) FROM sbtest WHERE id BETWEEN N AND M

queries

 

Ordered range

SELECT c FROM sbtest WHERE id BETWEEN N AND M ORDER BY c

queries

 

Distinct range

SELECT DISTINCT c FROM sbtest WHERE id BETWEEN N AND M ORDER BY c

queries

 

Updates on

UPDATE sbtest SET k=k+1 WHERE id=N

indexed column

 

Updates on

UPDATE sbtest SET c=N WHERE id=N

non-index column

 

Delete queries

DELETE FROM sbtest WHERE id=N

Insert queries

INSERT INTO sbtest VALUES (...)

 

 

Table 4 lists the configuration options that were used for SysBench.

SysBench Configuration

13