Á¤º¸°úÇÐȸ³í¹®Áö (Journal of KIISE)
ÇѱÛÁ¦¸ñ(Korean Title) |
¸ÖƼÅ׳ÍÆ® ȯ°æ¿¡¼ SSD ³»ºÎ ä³Î °£¼· ¿Ïȸ¦ À§ÇÑ µ¥ÀÌÅͺ£À̽º Æ©´× ±â¹ý |
¿µ¹®Á¦¸ñ(English Title) |
Database Tuning Techniques to Mitigate SSD-internal Interference among Multi-tenant Databases |
ÀúÀÚ(Author) |
¿À½ÂÁø
¹ÚÁ¾Çõ
ÀÌ»ó¿ø
Seung-Jin Oh
Jong-Hyeok Park
Sang-Won Lee
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 49 NO. 05 PP. 0388 ~ 0396 (2022. 05) |
Çѱ۳»¿ë (Korean Abstract) |
¸ÖƼÅ׳ÍÆ® ȯ°æ¿¡¼ ´Ù¼öÀÇ Å׳ÍÆ®µéÀº ´ÜÀÏ SSD¸¦ ÀúÀåÀåÄ¡·Î °øÀ¯ÇÑ´Ù. IOÀÇ Æ¯¼ºÀÌ »óÀÌÇÑ ¸ÖƼÅ׳ÍÆ®´Â SSD ³»ºÎ ä³Î ¼öÁØÀÇ °£¼·ÀÌ ¹ß»ýÇÑ´Ù. º» ³í¹®¿¡¼´Â SSD ³»ºÎ ä³Î ¼öÁØÀÇ º´·Ä¼ºÀ» ÃæºÐÈ÷ È°¿ëÇϱâ À§ÇÑ µÎ °¡Áö Æ©´× ±â¹ýÀÎ ÆäÀÌÁö Å©±â Á¤·Ä ±â¹ý°ú Readahead Å©±â Áõ°¡ ±â¹ýÀ» Á¦¾ÈÇÏ°í, µµÄ¿ ÄÁÅ×ÀÌ³Ê ±â¹Ý ȯ°æ¿¡¼ Linkbench¿Í TPC-H¸¦ µ¿½Ã ¼öÇàÇÏ¿© Æ®·£Àè¼Ç 󸮷® ¹× ÀÀ´ä(¼öÇà)½Ã°£ ¼º´ÉÀ» Æò°¡ÇÑ´Ù. ¼º´ÉÆò°¡ °á°ú, ÆäÀÌÁö Å©±â Á¤·Ä ±â¹ýÀº SSD ³»ºÎ¿¡¼ ºÒÇÊ¿äÇÑ µ¥ÀÌÅÍ Æеù/ºÐÇÒ ÀÛ¾÷ÀÇ ¿À¹öÇìµå¸¦ ÁÙÀÌ°í, IO ¿äûÀÇ ºÒÇÊ¿äÇÑ Ã¤³ÎÁ¡À¯¸¦ ¹æÁöÇϱ⠶§¹®¿¡ ³»ºÎ °£¼·À» ¿ÏȽÃÄÑ, Linkbench¿Í TPC-H ¸ðµÎ ¼º´ÉÀÌ Çâ»óµÇ¾ú´Ù. ÇÏÁö¸¸, Readahead Å©±â Áõ°¡ ±â¹ýÀº ¼øÂ÷ Àб⠿äûÀÇ SSD ³»ºÎ ä³Î Á¡À¯À²À» ³ô¿©, LinkbenchÀÇ ºñ±³Àû ÀÛÀº Å©±âÀÇ ÀÓÀÇ IO ¿äû¿¡ ÀÇÇÑ °£¼·À» ÁÙÀ̱⠶§¹®¿¡, TPC-HÀÇ ¼º´É¸¸ Çâ»óµÇ¾ú´Ù. |
¿µ¹®³»¿ë (English Abstract) |
In a multi-tenant environment, multi-tenants share an SSD(Solid State Drive) as their storage device. Multi-tenants with different IO characteristics can interfere with each other at the channel level in terms of storage performance. In this paper, to harness the full potential of channel level parallelism of SSD, we proposed two tuning techniques: page size alignment and increasing readahead size. We measured transaction throughput and latency (execution time) while running Linkbench and TPC-H simultaneously in Docker container-based environment. Our evaluation showed that the page size alignment technique reduced unnecessary data padding/division overhead and prevented unnecessary IO requests from occupying the channel to mitigate interference, improving the performance of the Linkbench and the TPC-H. However, increasing readahead size raised SSD internal channel occupancy of sequential read requests and reduced the interference of the Linkbench, whose request size was small and access type was random. Thus, it only improved the TPC-H in terms of query execution performance. |
Å°¿öµå(Keyword) |
¸ÖƼÅ׳ÍÆ®
ä³Î ¼öÁØ °£¼·
Ç÷¡½Ã ¸Þ¸ð¸®
µ¥ÀÌÅͺ£À̽º Æ©´×
multi-tenant
channel level interference
flash memory
database tuning
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|