ÆÁ¾ØÅ¥
2017.05.29 / 10:46

tpmC ¶õ?

½Å´Ïºñ
Ãßõ ¼ö 162

tpmC ¶õ?
TPC(Transaction Processing Performance Council, http://www.tpc.org) ¿¡¼­ TPC-C º¥Ä¡¸¶Å© ½Ã³ª¸®¿À¿¡ ´ëÇÑ 1ºÐ´ç ÃÖ´ë󸮰Ǽö¸¦ ³ªÅ¸³»´Â ¼öÄ¡·Î½á, DB±â¹Ý OLTP ¹Ìµé¿þ¾î ½Ã½ºÅÛ ¼­ºñ½º¸¦ À§ÇÑ H/WÀÇ ¼º´ÉÀ» ÃøÁ¤ÇÏ´Â ´ëÇ¥ÀûÀÎ ¹æ¹ýÀÔ´Ï´Ù. ±×·¯³ª, ÃÖ±Ù µé¾î °¢ º¥´õµéÀº tpmC¼öÄ¡¸¦ Á¦½ÃÇÏÁö ¾Ê´Â Ãß¼¼À̸ç, °¢ÀÚ °íÀ¯ÇÑ ¼öÄ¡ÀÇ ¼º´ÉÀڷḦ Á¦½ÃÇÕ´Ï´Ù.

TPC´Â Transcation Processing Perfomance Council(www.tpc.org)À̶ó´Â ±â°ü¿¡¼­´Â TPM(Transaction per munitue)¶ó´Â ¼öÄ¡¸¦ ¹ßÇ¥ÇÕ´Ï´Ù.
TPC-C´Â ¾çÆÇÁ¡(wholesale supplier)ÀÇ °Å·¡¸¦ ´ë»óÀ¸·Î ¸¸µç º¥Ä¡¸¶Å© ¸ðµ¨·Î ´ÙÀ½°ú °°Àº µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÕ´Ï´Ù. 

* Data Base

Table NameSize of Table per Warehouse
WareHosuse
0.089K
District
0.95K
Customer
19.65K
History
1.38K
Order
720K
New-Order
72K
Order-Line
16.2M
Stock
306M
Item
8.2M


* ´Ù¼¸°¡Áö Æ®·£Àè¼ÇÀÇ Á¾·ù°¡ Á¸ÀçÇÕ´Ï´Ù.
New Order, Payment, Order-Status, Delivery, Stock-Level

Æ®·£Àè¼ÇÀÇ ¼Óµµ¸ÞÆ®¸¯½º´Â ½Å±ÔÁÖ¹®(New-Order)Æ®·£Àè¼ÇÀÇ ºÐ´ç 󸮼ö·Î Ç¥½ÃµÇ´Â (tpmC)·Î °á°ú°¡ ¹ßÇ¥µË´Ï´Ù.

tpmC = µ¿½Ã»ç¿ëÀÚ¼ö¡¿ºÐ´ç Æ®·£Àè¼Ç(»ç¿ëÀÚ¼ö¡¿Æ®·£Àè¼Ç º¹Àâµµ(50%))+ÀÎÅÍÆäÀ̽º(°¡ÁßÄ¡%)¡¿³×Æ®¿öÅ© º¸Á¤(30%)¡¿ÇÇÅ© ŸÀÓ º¸Á¤(50%)¡¿I/O ºÎÇÏ(20%)¡¿³â°£ ¾÷¹«Áõ°¡ ¹× ¿©À¯À²(¿¬ 20%)
¸Þ¸ð¸® ¿ë·® = {(OS Ä¿³Î(100M)+[SGA()]+»ç¿ëÀÚ¼ö¡¿5MB)+[Webserver()]+ÀÎÅÍÆäÀ̽º(°¡ÁßÄ¡%)}+¿©À¯À²(30%)

tpm°ú tpmCÀÇ Â÷ÀÌÁ¡
1. tpmÀº °¢ vendor¿¡¼­ ³»ºÎÀû(ºñ°ø½Ä)À¸·Î estimateÇÑ °ª.
2. tpmC´Â TPC¶ó´Â º¥Ä¡¸¶Å·¾÷ü¿¡¼­ °ø½ÄÁ¤À¸·Î testÇÑ °ª.
    ¿©±â¼­ C´Â º¥Ä¡¸¶Å·¾÷ü¿¡¼­ on-line transaction processing (OLTP) benchmark¿¡
    ±Ù°ÅÇÑ °ªÀ» ¸»ÇÑ´Ù°í ÇÕ´Ï´Ù.
µû¶ó¼­ ¸ðµç ±âÁ¾ÀÇ tpmCÀÚ·á´Â ¾ø°í º¥Ä¡¸¶Å·¾÷ü°¡ testÇÑ ÀϺΠhigh-end¼­¹öÀÇ °ªÀÌ
°ø½ÄÀûÀ¸·Î tpc.org¶ó´Â »çÀÌÆ®¿¡ µî·ÏµÇ¾î ÀÖ´Ù°í ÇÕ´Ï´Ù. ´Ù¸¥ vendorµµ ¸¶Âù°¡ÁöÀÔ´Ï´Ù.



Ãâó: http://ukzzang.tistory.com/category/Dev Note/System [ukzzang]