Document Type
Article
Abstract
Unexpected long query latency of a database system can cause domino effects on all the upstream services and severely degrade end users’ experience with unpredicted long waits, resulting in an increasing number of users disengaged with the services and thus leading to a high user disengagement ratio (UDR). A high UDR usually translates to reduced revenue for service providers. This paper proposes UTSLO, a UDR-oriented SLO guaranteed system, which enables a database system to support multi-tenant UDR targets in a cost-effective fashion through UDR-oriented capacity planning and dynamic UDR target enforcement. The former aims to estimate the feasibility of UDR targets while the latter dynamically tracks and regulates per-connection query latency distribution needed for accurate UDR target guarantee. In UTSLO, the database service capacity can be fully exploited to efficiently accommodate tenants while minimizing resources required for UDR target guarantee.
Publication Date
10-1-2023
Language
English
License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Recommended Citation
Ning, Li; Che, Hao; Zhijun, Wang; Nguyen, Minh Q.; and Rosenkrantz, Todd, "User Disengagement-Oriented Target Enforcement for Multi-Tenant Database Systems" (2023). Association of Computing Machinery Open Access Agreement Publications. 53.
https://mavmatrix.uta.edu/utalibraries_acmoapubs/53