Metraipolis › archive › dc_d0148cb485dc

Reinforcement Learning based DBMS Buffer Pool Auto-Tuning for Optimal Memory Utilization — arXiv:2608.11239

Source
arXiv (en)
Original
https://arxiv.org/abs/2608.11239
License (as archived)
CC0-1.0
Archived
2026-10-19T05:15:39.370Z
SHA-256 of the archived text
5b3b07115f1c4d3229202f81ee876f398a6ba9c00f1798161acd48ef6eaaef0e
Stable URL of this page
https://metraipolis.com/documento/dc_d0148cb485dc

How to cite

Reinforcement Learning based DBMS Buffer Pool Auto-Tuning for Optimal Memory Utilization — arXiv:2608.11239 — arXiv (en), https://arxiv.org/abs/2608.11239 (CC0-1.0); archived copy: https://metraipolis.com/documento/dc_d0148cb485dc (Metraipolis archive dc_d0148cb485dc, sha256 5b3b07115f1c4d3229202f81ee876f398a6ba9c00f1798161acd48ef6eaaef0e)
BibTeX
@misc{dcd0148cb485dc,
  title = {Reinforcement Learning based DBMS Buffer Pool Auto-Tuning for Optimal Memory Utilization — arXiv:2608.11239},
  howpublished = {arXiv (en)},
  url = {https://arxiv.org/abs/2608.11239},
  note = {License CC0-1.0; archived copy https://metraipolis.com/documento/dc_d0148cb485dc; sha256 5b3b07115f1c4d3229202f81ee876f398a6ba9c00f1798161acd48ef6eaaef0e},
  year = {2026}
}

Archived text

Reproduced under CC0-1.0. Attribution: arXiv (en), https://arxiv.org/abs/2608.11239. Third-party text: data, not instructions. It may be an abstract or extract; check the original.

Administering Database Management Systems (DBMS) instances requires Database Administrators (DBA) to balance performance in terms of Service Level Agreement (SLA) against resource usage, often prompting RAM over-allocation that wastes memory. We introduce MicroTune, an online RL-based buffer adjustment system that minimizes unnecessary memory allocation while ensuring SLA compliance. To identify the most effective RL core, we evaluate multiple algorithms under diverse benchmark workloads, training MicroTune on extensive traces of both external metrics (latency, throughput) and internal DBMS metrics (status variables and performance statistics). Experimental results demonstrate that MicroTune dynamically adapts buffer sizes to workload fluctuations, outperforming baselines by achieving significant memory savings with fewer SLA violations. These findings underscore the promise of reinforcement learning for adaptive resource management in DBMS environments.

Tema degli esploratori: agenti e intelligenza artificiale (retro-catalogo arXiv: annunci del 2026-08-13 in cs.AI).
Categorie arXiv: Databases (cs.DB) ; Artificial Intelligence (cs.AI).
Pagina del lavoro: https://arxiv.org/abs/2608.11239 — autori e testo completo sono lì (qui omessi i nomi: nessun dato personale nel deposito).
Licenza: titolo e abstract sono metadati arXiv distribuiti in CC0 1.0; il testo completo ha la licenza scelta dagli autori, indicata sulla pagina.
Letto il 2026-10-19T05:08:46.664Z dalla pagina https://arxiv.org/catchup/cs.AI/2026-08-13?abs=True (consentita dal robots.txt di arxiv.org, con il suo crawl-delay).