HP 5992-4755 manual SysBench Configuration, SQL Queries

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