HP 5992-4755 User Manual
HP OSMS: MySQL Sizing Guide for HP ProLiant c-Class Blade Servers
HP Part Number: 5992-4755
Published: March 2008
Edition: 1.0
© Copyright 2008 Hewlett-Packard Development Company, L.P.
Legal Notice
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial
Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under
vendor's standard commercial license.
The information contained herein is subject to changewithoutnotice.The only warranties for HP products and services are set forth in the express
warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP
shall not be liable for technical or editorial errors or omissions contained herein.
Acknowledgments
Intel and Itanium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
RED HAT READY Logo and RED HAT CERTIFIED PARTNER Logo are trademarks of Red Hat, Inc.
Table of Contents
Introduction............................................................................................................................................9
Executive Summary...........................................................................................................................9
Intended Audience............................................................................................................................9
Scope and Purpose............................................................................................................................9
HP Services........................................................................................................................................9
Typographic Conventions...............................................................................................................11
Publishing History...........................................................................................................................11
HP Encourages Your Comments.....................................................................................................11
Benchmark Software.............................................................................................................................12
Hardware Test Environment................................................................................................................12
SysBench Configuration.......................................................................................................................13
MySQL Installation...............................................................................................................................14
MySQL Configuration..........................................................................................................................14
Benchmark Results................................................................................................................................15
Interpreting the Data.......................................................................................................................16
HP Proliant BL460c Server..............................................................................................................16
HP Proliant BL465c Server..............................................................................................................17
HP Proliant BL480c Server..............................................................................................................18
HP Proliant BL685c Server..............................................................................................................19
Summary...............................................................................................................................................20
Resources..............................................................................................................................................20
Table of Contents 3
4
List of Figures
1 SysBench Results for the HP ProLiant BL460c Server...................................................................17
2 SysBench Results for the HP ProLiant BL465c Server...................................................................18
3 SysBench Results for the HP ProLiant BL480c Server ..................................................................19
4 SysBench Results for the HP ProLiant BL685c Server...................................................................20
5 Benchmark Test Results.................................................................................................................20
5
6
List of Tables
1 Test Software Environment...........................................................................................................12
2 Test Hardware Environment.........................................................................................................12
3 SQL Queries...................................................................................................................................13
4 SysBench Options..........................................................................................................................14
5 MySQL Installation Packages........................................................................................................14
6 MySQL Test Configuration ...........................................................................................................14
7 SysBench Results for the HP ProLiant BL460c Server...................................................................16
8 SysBench Results for the HP ProLiant BL465c Server...................................................................17
9 SysBench Results for the HP ProLiant BL480c Server ..................................................................18
10 SysBench Results for the HP ProLiant BL685c Server...................................................................19
7
Loading...