Database Tuning Techniques to Mitigate SSD-internal Interference among Multi-tenant Databases

Seung-Jin Oh, Jong-Hyeok Park, Sang-Won Lee

http://doi.org/10.5626/JOK.2022.49.5.388

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.