HP 5992-4755 User Manual

HP OSMS: MySQL Sizing Guide for HPProLiant c-Class Blade ServersHP Part Number: 5992-4755Published: March 2008Edition: 1.0

• In Asia Pacific: +8522 599 7777• In Europe/Africa/Middle East: +41 22 780 81 1110

Typographic ConventionsThis document uses the following typographic conventions.CommandA command name or qualified command phrase.ComputerOutText disp

Benchmark SoftwareThe SysBench test suite is an open source, cross-platform, multi-threaded benchmark tool forevaluating system performance when runni

Table 2 Test Hardware Environment (continued)BL685cBL480cBL465cBL460cHardware(ext3 – no LVM):Disk0: /, /boot, swapDisk1: FC attach – 736GB disks 10k R

Table 4 SysBench OptionsDescriptionValueSysBench optionOLTP emulates operations that a read database would perform. Otheroptions are CPU, threads, mut

Table 6 MySQL Test Configuration (continued)DescriptionValuemysqld OptionBuffer size for joins that do not use indices and require afull table scan.1M

Depending on whether the application requires many read/write queries, it may help to set thedatabase connection pool to the number of processing core

Table 7 SysBench Results for the HP ProLiant BL460c Server (continued)Read Only (tps) FibreChannel SANRead/Write (tps) FibreChannel SANRead Only (tps)

Table 8 SysBench Results for the HP ProLiant BL465c Server (continued)Read Only (tps), FibreChannel SANRead/Write (tps), FibreChannel SANRead Only (tp

Figure 3 SysBench Results for the HP ProLiant BL480c ServerHP Proliant BL685c ServerThe HP ProLiant BL685c server blade delivers no-compromise perform

© Copyright 2008 Hewlett-Packard Development Company, L.P.Legal NoticeConfidential computer software. Valid license from HP required for possession, u

Figure 4 SysBench Results for the HP ProLiant BL685c ServerSummaryThe results of the SysBench testing indicated that the HP Proliant c-Class Blade Ser

MySQL http://www.mysql.comHP BladeSystem http://www.hp.com/go/bladesystem/http://h18004.www1.hp.com/products/blades/components/bladeservers.htmlHP Act

Table of ContentsIntroduction...

4

List of Figures1 SysBench Results for the HP ProLiant BL460c Server...172 SysBench Res

6

List of Tables1 Test Software Environment...12

8

IntroductionHP Open Source Middleware Stacks (OSMS) offer building block applications, such as the WebServer; technical blueprints, and documents such