Fighting Back: Using Observability Tools to Improve the DBMS (Not Just Diagnose It)

Observability tools increase the transparency of the system and help practitioners identify a wide variety of bugs and bottlenecks. In this paper we claim that such tools (DTrace, in our case) can play a much more active role: the same features which allow effective, but largely passive, measurement also have the potential to provide a powerful tool for actively improving the system. This capability proves particularly useful with database engines, which have complexity approaching that of operating systems but are nevertheless hosted by -- and often impeded by -- an underlying OS. We illustrate our point with several non-traditional use cases for DTrace where the DBMS and OS communicate, leading to elegant solutions for OS-DBMS interaction problems that are otherwise difficult to solve.


Published in:
Proceedings of the 5th International Workshop on Testing Database Systems, 10:1--10:6
Presented at:
5th International Workshop on Testing Database Systems, Scottsdale, Arizona, USA, May 20-24, 2012
Year:
2012
Publisher:
New York, NY, USA, ACM
ISBN:
978-1-4503-1429-9
Keywords:
Note:
PUBLICATION_SHORE_MT
Laboratories:




 Record created 2013-05-02, last modified 2018-03-17

External link:
Download fulltext
URL
Rate this document:

Rate this document:
1
2
3
 
(Not yet reviewed)