Summary of the content on the page No. 1
HP O SM S: M yS QL Si zing Gui de f o r HP
Pr oL i an t c -C la s s Blade S e r v e r s
HP P ar t Numbe r : 5 9 9 2 - 4 7 5 5
P u blished: Mar c h 200 8
E diti o n: 1 . 0
Summary of the content on the page No. 2
© Copyright 2008 Hewlett-P ackard Dev elopment Company , L.P . Leg al Notice Confidential computer softw are. V alid license from HP required for possession, use or copying. Consistent with F AR 12.211 and 12.212, Commercial Computer Softw are, Computer Softw are Documentation, and T echnical Data for Commercial Items are licensed to the U.S. Gov ernment under v endor's standard commercial license. The information contained herein is subject to change without notice. The only w arranties for HP
Summary of the content on the page No. 3
T a ble o f C o n t e n ts Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Executiv e Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Summary of the content on the page No. 4
4
Summary of the content on the page No. 5
L is t o f F i gur e s 1 SysBench Results for the HP ProLiant BL460c Serv er . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 2 SysBench Results for the HP ProLiant BL465c Serv er . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 3 SysBench Results for the HP ProLiant BL480c Serv er . . . . . . . . . . . . . . . . . . . . .
Summary of the content on the page No. 6
6
Summary of the content on the page No. 7
L is t o f T a ble s 1 T est Softw are Environment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2 T est Hardw are Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Summary of the content on the page No. 8
8
Summary of the content on the page No. 9
In tr odu c ti o n HP Open Source Middlew are Stacks (OSMS) offer building block applications, such as the W eb Serv er; technical blueprints, and documents such as this MySQL Sizing Guide which describes the maximum MySQL w orkload that HP ProLiant c-Class Blade Serv ers are capable of supporting; and consulting services to speed the successful implementation of an open source strategy . Ex ec u ti v e Summar y The HP Open Source Integrated P ortfolio (HP OSIP) comprises a range of products and
Summary of the content on the page No. 10
• In Asia P acific: +8522 599 7777 • In Europe/Africa/Middle East: +41 22 780 81 11 10
Summary of the content on the page No. 11
T y pogr a phi c C o n v e n ti o ns This document uses the following typographic conv entions. A command name or qualified command phrase. Command ComputerOut T ext display ed by the computer . Ctrl-x A key sequence. A sequence such asCtrl-x indicates that y ou must hold down the key labeledCtrl while y ou press another key or button. ENVIRONVAR The name of an environment v ariable, for example,PATH. [ERRORNAME] The name of an error , usually returned in theerrno v ariable. Key The name of a ke
Summary of the content on the page No. 12
Be nc hmar k S o f t w ar e The SysBench test suite is an open source, cross-platform, multi-threaded benchmark tool for ev aluating system performance when running a database under a heavy load. Depending on the options used, SysBench can be used to test the following system components: • File I/O performance • Scheduler performance • Memory allocation and transfer speed • POSIX threads implementation performance • Database serv er performance (OL TP benchmark) The results documented in this do
Summary of the content on the page No. 13
T abl e 2 T est H ar d w ar e En v ir onm ent (co n tin ued) H ar d w ar e BL4 6 0c BL4 6 5c BL4 80c BL6 8 5c File System (ext3 – no L VM): (ext3 – no L VM): (ext3 – no L VM): (ext3 – no L VM): Partitioning Disk0: /, /boot, sw ap Disk0: /, /boot, sw ap Disk0: /, /boot, sw ap Disk0: /, /boot, sw ap Disk1: FC attach – 7 Disk1: FC attach – 7 Disk1: FC attach – 7 Disk1: FC attach – 7 36GB disks 10k RPM, 36GB disks 10k RPM, 36GB disks 10k RPM, 36GB disks 10k RPM, RAID 0 RAID 0 RAID 0 RAID 0 Operating
Summary of the content on the page No. 14
T abl e 4 S y sB enc h O ptions S y sB enc h option V alue Des c r iption --test oltp OL TP emulates operations that a read database w ould 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 y es Sets the v alue for whether the storage engine used is transactional. --oltp-test-mode complex Determines how transactions are performed. Options are simple (v ery simple SELECT s), complex (transac
Summary of the content on the page No. 15
T abl e 6 M yS QL T est Conf igur ation (co n tin ued) m y s qld O ption V alue Des c r iption 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 serv er threads to cache for reuse. thread_stack 192K P er-thread stack size. The default is 192K. query_cache_size 0 Amount of memory allocated for caching query results. The v alue “0” disables query cache. ft_min_w ord_len 4 Minimum length of the w ord to be included in a f
Summary of the content on the page No. 16
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 Serv ers in the test can still handle almost the same number of transactions ev en 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. NO TE: For read
Summary of the content on the page No. 17
T abl e 7 S y sB enc h R esults f or t h e HP Pr oL iant BL4 6 0c Ser v er (co n tin ued) R ead/W r ite (tps) R ead O nl y (tps) R ead/W r ite (tps) F ibr e R ead O nl y (tps) F ibr e Conn ec tions Inter nal S A S Inter nal S A S C hann el S AN C hann el S AN 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 F igur e 1 S y sB enc h R esults f or t h e HP Pr oL iant BL4 6 0c Ser v er HP Pr o li an t BL4 6 5c S
Summary of the content on the page No. 18
T abl e 8 S y sB enc h R esults f or t h e HP Pr oL iant BL4 6 5c Ser v er (co n tin ued) R ead/W r ite (tps) , R ead O nl y (tps) , Inter nal R ead/W r ite (tps) , F ibr e R ead O nl y (tps) , F ibr e Conn ec tions Inter nal S A S S A S C hann el S AN C hann el S AN 64 885 2097 911 2148 128 621 1962 630 2049 F igur e 2 S y sB enc h R esults f or t h e HP Pr oL iant BL4 6 5c Ser v er HP Pr o li an t BL4 8 0c S e r v e r The HP ProLiant BL480c serv er is a 2-w ay serv er blade designed for maximu
Summary of the content on the page No. 19
F igur e 3 S y sB enc h R esults f or t h e HP Pr oL iant BL4 80c Ser v er HP Pr o li an t BL6 8 5c S e r v e r The HP ProLiant BL685c serv er blade deliv ers no-compromise performance and expansion in the densest four processor serv er blade form factor av ailable. W ith up to four AMD Opteron™ 8000 Series processors, 64GB of DDR2 memory , tw o hot-plug Serial Attached SCSI (SAS) or Serial A T A (SA T A) hard-driv es, four embedded Gigabit NICs, and three I/O expansion slots, the HP ProLiant BL
Summary of the content on the page No. 20
F igur e 4 S y sB enc h R esults f or t h e HP Pr oL iant BL6 8 5c Ser v er Summar y The results of the SysBench testing indicated that the HP Proliant c-Class Blade Serv ers provide a solid platform for the MySQL database serv er . Along with the integrated Smart Array controller these serv ers provide the security of RAID storage to the host operating system and database files, while also offering excellent performance for many applications. The results of the benchmarks tests are provided in
