Sysbench configuration, Sql queries – HP 5992-4755 User Manual

Page 13

Table 2 Test Hardware Environment (continued)

BL685c

BL480c

BL465c

BL460c

Hardware

(ext3 – no LVM):
Disk0: /, /boot, swap

Disk1: FC attach – 7
36GB disks 10k RPM,
RAID 0

(ext3 – no LVM):
Disk0: /, /boot, swap

Disk1: FC attach – 7
36GB disks 10k RPM,
RAID 0

(ext3 – no LVM):
Disk0: /, /boot, swap

Disk1: FC attach – 7
36GB disks 10k RPM,
RAID 0

(ext3 – no LVM):
Disk0: /, /boot, swap

Disk1: FC attach – 7
36GB disks 10k RPM,
RAID 0

File System
Partitioning

RHEL5 AS u1 SMP
kernel (2.6.18-53.el5)
with errata updates

Operating
System

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

SQL Query Syntax

Type of Query

SELECT c FROM sbtest WHERE id=N

Point queries

SELECT c FROM sbtest WHERE id BETWEEN N and M

Range queries

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

Range SUM()
queries

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

Ordered range
queries

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

Distinct range
queries

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

Updates on
indexed column

UPDATE sbtest SET c=N WHERE id=N

Updates on
non-index column

DELETE FROM sbtest WHERE id=N

Delete queries

INSERT INTO sbtest VALUES (...)

Insert queries

Table 4

lists the configuration options that were used for SysBench.

SysBench Configuration