"What makes my queries slow?": Subgroup Discovery for SQL Workload Analysis - Archive ouverte HAL Accéder directement au contenu
Communication Dans Un Congrès Année : 2021

"What makes my queries slow?": Subgroup Discovery for SQL Workload Analysis

Résumé

Among daily tasks of database administrators (DBAs), the analysis of query workloads to identify schema issues and improving performances is crucial. Although DBAs can easily pinpoint queries repeatedly causing performance issues, it remains challenging to automatically identify subsets of queries that share some properties only (a pattern) and simultaneously foster some target measures, such as execution time. Patterns are defined on combinations of query clauses, environment variables, database alerts and metrics and help answer questions like what makes SQL queries slow? What makes I/O communications high? Automatically discovering these patterns in a huge search space and providing them as hypotheses for helping to localize issues and root-causes is important in the context of explainable AI. To tackle it, we introduce an original approach rooted on Subgroup Discovery. We show how to instantiate and develop this generic data-mining framework to identify potential causes of SQL workloads issues. We believe that such data-mining technique is not trivial to apply for DBAs. As such, we also provide a visualization tool for interactive knowledge discovery. We analyse a one week workload from hundreds of databases from our company, make both the dataset and source code available, and experimentally show that insightful hypotheses can be discovered.
Fichier principal
Vignette du fichier
What makes my queries slow Subgroup Discovery for SQL Workload Analysis.pdf (731.69 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)

Dates et versions

hal-03318172 , version 1 (09-08-2021)
hal-03318172 , version 2 (01-04-2022)

Identifiants

Citer

Youcef Remil, Anes Bendimerad, Romain Mathonat, Philippe Chaleat, Mehdi Kaytoue. "What makes my queries slow?": Subgroup Discovery for SQL Workload Analysis. 36th IEEE/ACM International Conference on Automated Software Engineering, ASE 2021, Nov 2021, Melbourne, Australia. pp.642-652, ⟨10.1109/ASE51524.2021.9678915⟩. ⟨hal-03318172v2⟩
138 Consultations
349 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More