HP OSMS: MySQL Sizing Guide for HP ProLiant c-Class Blade Servers HP Part Number: 5992-4755 Published: March 2008 Edition: 1.
© 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 change without notice.
Table of Contents Introduction............................................................................................................................................9 Executive Summary...........................................................................................................................9 Intended Audience............................................................................................................................9 Scope and Purpose......................................
List of Figures 1 2 3 4 5 SysBench Results for the HP ProLiant BL460c Server...................................................................17 SysBench Results for the HP ProLiant BL465c Server...................................................................18 SysBench Results for the HP ProLiant BL480c Server ..................................................................19 SysBench Results for the HP ProLiant BL685c Server...................................................................
List of Tables 1 2 3 4 5 6 7 8 9 10 Test Software Environment...........................................................................................................12 Test Hardware Environment.........................................................................................................12 SQL Queries...................................................................................................................................13 SysBench Options..............................................
Introduction HP Open Source Middleware Stacks (OSMS) offer building block applications, such as the Web Server; technical blueprints, and documents such as this MySQL Sizing Guide which describes the maximum MySQL workload that HP ProLiant c-Class Blade Servers are capable of supporting; and consulting services to speed the successful implementation of an open source strategy.
• • 10 In Asia Pacific: +8522 599 7777 In Europe/Africa/Middle East: +41 22 780 81 11
Typographic Conventions This document uses the following typographic conventions. Command ComputerOut Ctrl-x ENVIRONVAR [ERRORNAME] Key Term UserInput VARIABLE \ (continuation character) ... | A command name or qualified command phrase. Text displayed by the computer. A key sequence. A sequence such as Ctrl-x indicates that you must hold down the key labeled Ctrl while you press another key or button. The name of an environment variable, for example, PATH.
Benchmark Software The SysBench test suite is an open source, cross-platform, multi-threaded benchmark tool for evaluating system performance when running a database under a heavy load.
Table 2 Test Hardware Environment (continued) Hardware BL460c BL465c BL480c BL685c File System Partitioning (ext3 – no LVM): Disk0: /, /boot, swap (ext3 – no LVM): Disk0: /, /boot, swap (ext3 – no LVM): Disk0: /, /boot, swap (ext3 – no LVM): Disk0: /, /boot, swap Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 RHEL5 AS u1 SMP kernel (2.6.18-53.
Table 4 SysBench Options SysBench option Value Description --test oltp OLTP emulates operations that a read database would perform. Other options are CPU, threads, mutex, memory, and fileio. --oltp-table-size 1000000 Sets the number of rows in the test table. --mysql-engine-trx yes Sets the value for whether the storage engine used is transactional. --oltp-test-mode complex Determines how transactions are performed.
Table 6 MySQL Test Configuration (continued) mysqld Option Value Description join_buffer_size 1M Buffer size for joins that do not use indices and require a full table scan. thread_cache_size 16 Number of server threads to cache for reuse. thread_stack 192K Per-thread stack size. The default is 192K. query_cache_size 0 Amount of memory allocated for caching query results. The value “0” disables query cache. ft_min_word_len 4 Minimum length of the word to be included in a full-text index.
Depending on whether the application requires many read/write queries, it may help to set the database connection pool to the number of processing cores. For read-only testing, all HP Proliant c-Class Blade Servers in the test can still handle almost the same number of transactions even though the number of concurrent threads is double the number of processing cores. Therefore, more database connections than the number of processing cores for read-only applications can be used.
Table 7 SysBench Results for the HP ProLiant BL460c Server (continued) Connections Read/Write (tps) Internal SAS Read Only (tps) Internal SAS Read/Write (tps) Fibre Channel SAN Read Only (tps) Fibre Channel SAN 4 1893 2615 1910 2593 8 3088 4301 3145 4297 16 2604 4374 2690 4353 32 2382 4148 2423 4271 64 2220 4006 2271 3990 128 1478 3641 1626 3722 Figure 1 SysBench Results for the HP ProLiant BL460c Server HP Proliant BL465c Server The HP ProLiant BL465c server is a two-way
Table 8 SysBench Results for the HP ProLiant BL465c Server (continued) Connections Read/Write (tps), Internal SAS Read Only (tps), Internal Read/Write (tps), Fibre Read Only (tps), Fibre SAS Channel SAN Channel SAN 64 885 2097 911 2148 128 621 1962 630 2049 Figure 2 SysBench Results for the HP ProLiant BL465c Server HP Proliant BL480c Server The HP ProLiant BL480c server is a 2-way server blade designed for maximum performance and scalability.
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 in the densest four processor server blade form factor available.
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 provide a solid platform for the MySQL database server. Along with the integrated Smart Array controller these servers provide the security of RAID storage to the host operating system and database files, while also offering excellent performance for many applications.
MySQL http://www.mysql.com HP BladeSystem http://www.hp.com/go/bladesystem/ http://h18004.www1.hp.com/products/blades/components/bladeservers.html HP ActiveAnswers for MySQL Database Server http://h71019.www7.hp.com/ActiveAnswers/cache/81882-0-0-0-121.html SysBench Benchmark Software http://sysbench.sourceforge.