HP OSMS: MySQL Sizing Guide for HP ProLiant c-Class Blade Servers

Table 2 Test Hardware Environment (continued)
BL685cBL480cBL465cBL460cHardware
(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
RHEL5 AS u1 SMP
kernel (2.6.18-53.el5)
with errata updates
RHEL5 AS u1 SMP
kernel (2.6.18-53.el5)
with errata updates
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 SyntaxType 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 13