发明名称 |
AUTOMATIC DETECTION AND CORRECTION OF HOT PAGES IN A DATABASE SYSTEM |
摘要 |
According to one embodiment of the present invention, a method for detecting and correcting hot pages in a database system is provided. According to one embodiment of the present invention, a method includes monitoring transactions involving pages in a database and determining if one of the transactions had to wait for access to one of the pages; incrementing a page contention counter each time one of the transactions had to wait for access to one of the pages. The method then determines if the page contention counter exceeds a predetermined threshold and monitors transactions on one of the pages for which the page contention count was exceeded. The method then determines if a row was accessed in the page for which the page contention count was exceeded and increments a reference count for the accessed row. the accessed rows are flagged when the reference count exceeds a second predetermined threshold. The flagged rows are moved to another page in the database. |
申请公布号 |
US2010223243(A1) |
申请公布日期 |
2010.09.02 |
申请号 |
US20090394786 |
申请日期 |
2009.02.27 |
申请人 |
INTERNATIONAL BUSINESS MACHINES CORPORATION |
发明人 |
HURAS MATTHEW ALBERT;ROMANUFA KERILEY KAY;SACHEDINA AAMER;XUE XUN |
分类号 |
G06F12/02;G06F17/30 |
主分类号 |
G06F12/02 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|