Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 3
T a ble o f C o n t e n ts Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Executiv e Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Résumé du contenu de la page N° 4
4
Résumé du contenu de la page N° 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 . . . . . . . . . . . . . . . . . . . . .
Résumé du contenu de la page N° 6
6
Résumé du contenu de la page N° 7
L is t o f T a ble s 1 T est Softw are Environment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2 T est Hardw are Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Résumé du contenu de la page N° 8
8
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 10
• In Asia P acific: +8522 599 7777 • In Europe/Africa/Middle East: +41 22 780 81 11 10
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
Résumé du contenu de la page N° 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
