EasyControl: improve database throughput under overloading

Authors:
Chengkai Tao;Qizhi Liu;Yan Zhang
Affiliations:
State Key Laboratory for Novel Software Technology, Nanjing University, China;State Key Laboratory for Novel Software Technology, Nanjing University, China;State Key Laboratory for Novel Software Technology, Nanjing University, China
Venue:
WAIM'13 Proceedings of the 14th international conference on Web-Age Information Management
Year:
2013

Citing 7
Cited 0

Load control for locking: the “half-and-half” approach

PODS '90 Proceedings of the ninth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Performance Guarantees for Web Server End-Systems: A Control-Theoretical Approach

IEEE Transactions on Parallel and Distributed Systems
Thrashing in Two-Phase Locking Revisited

Proceedings of the Eighth International Conference on Data Engineering
Adaptive Load Control in Transaction Processing Systems

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Performance Evaluation of an Adaptive and Robust Load Control Method for the Avoidance of Data-Contention Thrashing

VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
How to Determine a Good Multi-Programming Level for External Scheduling

ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Self-tuning database technology and information services: from wishful thinking to viable engineering

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

When facing big data, overloading in database usually occurs, leading to the decline in performance. This is a problem that has been studying for long but still not completely solved yet. Preventing overloading while fully utilize resources is challenging. In this paper, we present EasyControl, a prototype admission control system that reduces the impact of overloading. The most significant distinction between EasyControl and existing overloading controls is that the users don't need to study the system beforehand. Experiments show that adding EasyControl increases the throughput during overloading periods and will not affect the throughput when the load is mild.