硬件孤岛上的OLTP
OLTP on Hardware Islands
摘要:
现代硬件大量并行,并且越来越异构。众多处理核具有对主存储器和处理器高速缓存的非均匀访问权限,这导致通信成本的变化。不幸的是,数据库系统大多假设所有的处理核心都是相同的,并且微架构的差异不足以出现在关键的数据库执行路径中。然而,正如我们在本文中所展示的,硬件异构性确实出现在关键路线中,并且传统的数据库架构实现了次优甚至更差的不可预测的性能。我们对每个CPU有多个内核(多核)和每个服务器有多个CPU(多插槽)的服务器中的OLTP部署进行了详细的性能分析。我们比较了不同的数据库部署策略,其中我们改变了在单个服务器上运行的独立数据库实例的数量和大小,从单个共享一切实例到细粒度的无共享配置。我们通过以下方式量化非统一硬件对各种部署的影响:(a)检查每个部署使用可用硬件资源的效率;(b)测量分布式事务和偏斜请求对不同工作负载的影响。最后,我们主张支持无共享部署,即拓扑和工作负载感知,并利用同一插槽上的核心岛屿之间的快速片上通信。
英文摘要:
Modern hardware is abundantly parallel and increasingly heterogeneous. The numerous processing cores have non-uniform access latencies to the main memory and to the processor caches, which causes variability in the communication costs. Unfortunately, database systems mostly assume that all processing cores are the same and that microarchitecture differences are not significant enough to appear in critical database execution paths. As we demonstrate in this paper, however, hardware heterogeneity does appear in the critical path and conventional database architectures achieve suboptimal and even worse, unpredictable performance. We perform a detailed performance analysis of OLTP deployments in servers with multiple cores per CPU (multicore) and multiple CPUs per server (multisocket). We compare different database deployment strategies where we vary the number and size of independent database instances running on a single server, from a single shared-everything instance to fine-grained shared-nothing configurations. We quantify the impact of non-uniform hardware on various deployments by (a) examining how efficiently each deployment uses the available hardware resources and (b) measuring the impact of distributed transactions and skewed requests on different workloads. Finally, we argue in favor of shared-nothing deployments that are topology- and workload-aware and take advantage of fast on-chip communication between islands of cores on the same socket.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。