ページ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
ページ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
ページ3に含まれる内容の要旨
T a ble o f C o n t e n ts Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Executiv e Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
ページ4に含まれる内容の要旨
4
ページ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 . . . . . . . . . . . . . . . . . . . . .
ページ6に含まれる内容の要旨
6
ページ7に含まれる内容の要旨
L is t o f T a ble s 1 T est Softw are Environment. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 2 T est Hardw are Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
ページ8に含まれる内容の要旨
8
ページ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
ページ10に含まれる内容の要旨
• In Asia P acific: +8522 599 7777 • In Europe/Africa/Middle East: +41 22 780 81 11 10
ページ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
ページ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
ページ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
ページ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
ページ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
ページ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
ページ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
ページ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
ページ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
ページ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