Online Transaction Processing (OLTP) is a classic application with a growing business. CPU-based OLTP has low lock serving efficiency. The main reason is that most locks are cold, and the lock agent must issue frequent memory accesses to retrieve the lock details to determine whether to grant it. This motivates us to propose dedicated hardware-based lock agents with integrated lock tables to remove the DRAM access overhead. In this paper, we propose hardware-accelerated lock management and transaction processing for database systems. First, we propose a low-latency lock agent optimized for both lock acquiring and releasing requests. Second, we design a scalable transaction agent that executes the full transaction lifecycle. We present the architecture, optimizations, and design-space exploration of the proposed lock management and transaction processing system. The experiment results show up to 51X higher transaction throughput over the CPU baseline on the TPC-C benchmark.
翻译:在线事务处理(OLTP)是一种经典的、业务持续增长的应用程序。基于CPU的OLTP锁服务效率低下,主要原因是大部分锁是冷锁,锁代理需要频繁发起内存访问以检索锁的详细信息来判断是否授予锁。这促使我们提出专用硬件锁代理,通过集成锁表来消除DRAM访问开销。本文针对数据库系统提出了硬件加速的锁管理与事务处理方法。首先,我们提出了一种针对锁获取与释放请求均进行优化的低延迟锁代理。其次,我们设计了一个可扩展的事务代理,用于执行完整的事务生命周期。我们展示了所提出的锁管理与事务处理系统的架构、优化方案及设计空间探索。实验结果表明,在TPC-C基准测试中,事务吞吐量相比CPU基线实现了高达51倍的提升。