Instruction/ maintenance manual of the product 5992-4755 HP (Hewlett-Packard)
Go to page of 21
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 .
© 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.
T able o f C ont ents Introduction ............................................................................................................................................ 9 Ex ec ut iv e Su m ma r y................................................
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...................
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 ...........................................
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 .
• 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.
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.
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 V.
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.
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.
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.
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) Intern.
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), I.
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.
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 .
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.
An important point after buying a device HP (Hewlett-Packard) 5992-4755 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought HP (Hewlett-Packard) 5992-4755 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data HP (Hewlett-Packard) 5992-4755 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, HP (Hewlett-Packard) 5992-4755 you will learn all the available features of the product, as well as information on its operation. The information that you get HP (Hewlett-Packard) 5992-4755 will certainly help you make a decision on the purchase.
If you already are a holder of HP (Hewlett-Packard) 5992-4755, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime HP (Hewlett-Packard) 5992-4755.
However, one of the most important roles played by the user manual is to help in solving problems with HP (Hewlett-Packard) 5992-4755. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device HP (Hewlett-Packard) 5992-4755 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
