HP (Hewlett-Packard) 5992-4755 manuale d’uso

HP O SM S: M yS QL Si zing Gui de f or HP Pr oL i ant c -C las s Blade Ser v er s HP P art Number: 5 99 2 -4 7 5 5 P ublished: Mar ch 2008 E dition: 1 .0[...]

© Copyright 2008 Hewlett-P ackard Development Company , L.P . Legal 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 Software Documentation, and T echnical Data for Commercial Items are licensed to the U.S. Gov ern[...]

T able o f C ont ents Introduction ............................................................................................................................................ 9 Ex ec ut iv e Su m ma r y...........................................................................................................................9 In te nd ed A ud ie nc[...]

4[...]

L ist o f F i gur es 1 Sy sB en ch R es ul ts f or th e HP Pr oL ia nt B L4 60 c Se r v e r...................................................................1 7 2 Sy sB en ch R es ul ts f or th e HP Pr oL ia nt B L4 65 c Se r v e r...................................................................1 8 3 Sy sB en ch R es ul ts f or th e HP Pr oL ia [...]

6[...]

L ist o f T ables 1 T e st S o ft w ar e En vi ro nm en t...........................................................................................................1 2 2 T e st H a rd w ar e En vi ro nm e nt .........................................................................................................12 3 SQ L Qu er ie s.................[...]

8[...]

Intr oducti on HP Open Source Middlew are Stacks (OSMS) offer building block applications, such as the W eb 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 implement[...]

• In Asia P acific: +8522 599 7777 • In Europe/Africa/Middle East: +41 22 780 81 11 10[...]

T y pogr aphi c Con v enti ons This document uses the following typographic conventions. Command A command name or qualified command phrase. ComputerOut T ext 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 y ou press another key or button. ENVIRONVAR The name[...]

Benc hmar k So ft 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 al[...]

T able 2 T est Hard ware En vir onment (continued) BL68 5c BL480c BL46 5c BL46 0c Hardw are (ext3 – no L VM): Disk0: /, /boot, swap Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 (ext3 – no L VM): Disk0: /, /boot, swap Disk1: FC attach – 7 36GB disks 10k RPM, RAID 0 (ext3 – no L VM): Disk0: /, /boot, swap Disk1: FC attach – 7 36GB disk[...]

T able 4 S ysBench Options Description V alue S ysBench option OL TP emulates operations that a read database would perform. Other options are CPU, threads, mutex, memory , and fileio. oltp --test Sets the number of rows in the test table. 1000000 --oltp-table-size Sets the v alue for whether the storage engine used is transactional. yes --mysql-en[...]

T able 6 M ySQL T est Configuration (co ntinued) Description V alue my sqld Option Buffer size for joins that do not use indices and require a full table scan. 1M join_buffer_size Number of server threads to cache for reuse. 16 thread_cache_size P er-thread stack size. The default is 192K. 192K thread_stack Amount of memory allocated for caching qu[...]

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 even though the number of concurrent threads is double the number [...]

T able 7 S ysBench Results for the HP ProL iant BL460c Server (continued) Read Only (tps) F ibre Channel SAN Read/W rite (tps) F ibre Channel SAN Read Only (tps) Internal S AS Read/W rite (tps) Internal S AS Connections 2593 1910 2615 1893 4 4297 3145 4301 3088 8 4353 2690 4374 2604 16 4271 2423 4148 2382 32 3990 2271 4006 2220 64 3722 1626 3641 14[...]

T able 8 Sy sBenc h Results for the HP ProL iant BL46 5c Ser ver (continued) Read Only (tps), Fibre Channel SAN Read/W rite (tps), Fibre Channel SAN Read Only (tps), Internal SA S Read/W rite (tps), Internal S AS Connections 2148 911 2097 885 64 2049 630 1962 621 128 Figur e 2 S ysBench Results for the HP ProL iant BL46 5c Ser ver HP Pr oliant BL4 [...]

Figur e 3 S ysBench Results for the HP ProL iant BL480c Server HP Pr oliant BL6 8 5c Serv er The HP ProLiant BL685c server blade delivers no-compromise performance and expansion in the densest four processor serv er blade form factor available. W ith up to four AMD Opteron™ 8000 Series processors, 64GB of DDR2 memory , two hot-plug Serial Attache[...]

Figur e 4 S ysBench Results for the HP ProL iant BL68 5c Server Summary 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 servers provide the security of RAID storage to the host operating system a[...]

MySQL http://www .mysql.com HP BladeSystem http://www .hp.com/go/bladesystem/ http://h18004.www1.hp.com/products/blades/components/bladeserv ers.html HP ActiveAnsw ers for MySQL Database Server http://h71019.www7.hp.com/Activ eAnswers/cache/81882-0-0-0-121.html SysBench Benchmark Softw are http://sysbench.sourceforge.net/ Resources 21[...]