An empirical study of transaction throughput thrashing across multiple relational DBMSes
作者:
Highlights:
•
• We propose a novel structural causal model to explain the origins of DBMS thrashing.
• We present a space of hypotheses that can refine and support the proposed model.
• We extend a recent DBMS-centric research infrastructure for thrashing experiments.
• We propose a novel analysis protocol that can be applied to obtained thrashing data.
• We suggest engineering implications to DBMS developers and DBAs for better performance.
摘要
Highlights •We propose a novel structural causal model to explain the origins of DBMS thrashing.•We present a space of hypotheses that can refine and support the proposed model.•We extend a recent DBMS-centric research infrastructure for thrashing experiments.•We propose a novel analysis protocol that can be applied to obtained thrashing data.•We suggest engineering implications to DBMS developers and DBAs for better performance.
论文关键词:DBMS Thrashing,Transaction,Throughput,Factors,Structural Causal Model,Empirical Study
论文评审过程:Received 17 November 2015, Revised 8 August 2016, Accepted 21 December 2016, Available online 27 December 2016, Version of Record 27 April 2017.
论文官网地址:https://doi.org/10.1016/j.is.2016.12.004