MCCDB: Minimizing Cache Conflicts in Multi-Core Processors for Databases

Free registration required

Executive Summary

In a typical commercial multi-core processor, the Last Level Cache (LLC) is shared by two or more cores. Existing studies have shown that the shared LLC is beneficial to concurrent query processes with commonly shared data sets. However, the shared LLC can also be a performance bottleneck to concurrent queries, each of which has private data structures, such as a hash table for the widely used hash join operator, causing serious cache conflicts. The authors show that cache conflicts on multi-core processors can significantly degrade overall database performance.

  • Format: PDF
  • Size: 315.6 KB