Buffer Pool Aware Query Scheduling via Deep Reinforcement Learning. (arXiv:2007.10568v3 [cs.DB] UPDATED)

In this extended abstract, we propose a new technique for query scheduling
with the explicit goal of reducing disk reads and thus implicitly increasing
query performance. We introduce SmartQueue, a learned scheduler that leverages
overlapping data reads among incoming queries and learns a scheduling strategy
that improves cache hits. SmartQueue relies on deep reinforcement learning to
produce workload-specific scheduling strategies that focus on long-term
performance benefits while being adaptive to previously-unseen data access
patterns. We present results from a proof-of-concept …

arxiv learning query reinforcement reinforcement learning scheduling