Page 5 - List of Figures
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 B...
Page 7 - List of Tables
List of Tables 1 Test Software Environment...........................................................................................................12 2 Test Hardware Environment.........................................................................................................12 3 SQL Queries...
Page 9 - Executive Summary; For the location of the nearest sales office, call:
Introduction HP Open Source Middleware Stacks (OSMS) offer building block applications, such as the WebServer; technical blueprints, and documents such as this MySQL Sizing Guide which describesthe maximum MySQL workload that HP ProLiant c-Class Blade Servers are capable of supporting;and consulting...
Page 11 - Typographic Conventions; Command; Ctrl; ENVIRONVAR; Key; VARIABLE; Publishing History; HP Encourages Your Comments
Typographic Conventions This document uses the following typographic conventions. Command A command name or qualified command phrase. ComputerOut Text displayed by the computer. Ctrl-x A key sequence. A sequence such as Ctrl-x indicates that you must hold down the key labeled Ctrl while you press an...
Page 12 - Benchmark Software; Table 1; Hardware Test Environment; Table 2
Benchmark Software The SysBench test suite is an open source, cross-platform, multi-threaded benchmark tool forevaluating system performance when running a database under a heavy load. Depending onthe options used, SysBench can be used to test the following system components: • File I/O performance ...
Page 13 - Table 2 Test Hardware Environment; statements around each of the transactions.; Table 4
Table 2 Test Hardware Environment (continued) BL685c BL480c BL465c BL460c Hardware (ext3 – no LVM):Disk0: /, /boot, swap Disk1: FC attach – 736GB disks 10k RPM,RAID 0 (ext3 – no LVM):Disk0: /, /boot, swap Disk1: FC attach – 736GB disks 10k RPM,RAID 0 (ext3 – no LVM):Disk0: /, /boot, swap Disk1: FC a...
Page 14 - Table 4 SysBench Options; MySQL Installation; Table 5; MySQL Configuration; Table 6
Table 4 SysBench Options Description Value SysBench option OLTP emulates operations that a read database would perform. Otheroptions are CPU, threads, mutex, memory, and fileio. oltp --test Sets the number of rows in the test table. 1000000 --oltp-table-size Sets the value for whether the storage en...
Page 15 - Table 6 MySQL Test Configuration
Table 6 MySQL Test Configuration (continued) Description Value mysqld Option Buffer size for joins that do not use indices and require afull table scan. 1M join_buffer_size Number of server threads to cache for reuse. 16 thread_cache_size Per-thread stack size. The default is 192K. 192K thread_stack...
Page 16 - Table 7
Depending on whether the application requires many read/write queries, it may help to set thedatabase connection pool to the number of processing cores. For read-only testing, all HP Proliantc-Class Blade Servers in the test can still handle almost the same number of transactions eventhough the numb...
Page 17 - Table 7 SysBench Results for the HP ProLiant BL460c Server; Figure 1 SysBench Results for the HP ProLiant BL460c Server; HP Proliant BL465c Server; Table 8
Table 7 SysBench Results for the HP ProLiant BL460c Server (continued) Read Only (tps) FibreChannel SAN Read/Write (tps) FibreChannel SAN Read Only (tps)Internal SAS Read/Write (tps)Internal SAS Connections 2593 1910 2615 1893 4 4297 3145 4301 3088 8 4353 2690 4374 2604 16 4271 2423 4148 2382 32 399...
Page 18 - Table 8 SysBench Results for the HP ProLiant BL465c Server; Figure 2 SysBench Results for the HP ProLiant BL465c Server; HP Proliant BL480c Server; Table 9
Table 8 SysBench Results for the HP ProLiant BL465c Server (continued) Read Only (tps), FibreChannel SAN Read/Write (tps), FibreChannel SAN Read Only (tps), InternalSAS Read/Write (tps),Internal SAS Connections 2148 911 2097 885 64 2049 630 1962 621 128 Figure 2 SysBench Results for the HP ProLiant ...
Page 19 - Figure 3 SysBench Results for the HP ProLiant BL480c Server; HP Proliant BL685c Server; , and were obtained using a ProLiant BL685c server
Figure 3 SysBench Results for the HP ProLiant BL480c Server HP Proliant BL685c Server The HP ProLiant BL685c server blade delivers no-compromise performance and expansion inthe densest four processor server blade form factor available. With up to four AMD Opteron™8000 Series processors, 64GB of DDR2...
Page 20 - Figure 4 SysBench Results for the HP ProLiant BL685c Server; Summary; The results of the benchmarks tests are provided in; Resources; HP and MySQL
Figure 4 SysBench Results for the HP ProLiant BL685c Server Summary The results of the SysBench testing indicated that the HP Proliant c-Class Blade Servers providea solid platform for the MySQL database server. Along with the integrated Smart Array controllerthese servers provide the security of RA...
