+1 On Jan 16, 2025 at 14:56:59, Hongyu Shi <h...@scu.edu.invalid> wrote:
> Hi *DB Dev community, > > Starting a discussion thread to propose new DDL/DML syntax that allows > users to define group names with corresponding priorities, adjust query > scheduler parameters for dynamic management, and incorporate these > configurations into queries. > > *Feature:* Syntax for configuring the dynamic workload scheduler's metadata > via DDL/DML and related statements. > *Details:* The new scheduler allows the system to prioritize queries > according to user-defined classifications and priorities. Additionally it > also ensures that short, low-resource queries are prioritized, while also > maintaining fair scheduling by balancing wait times relative to execution > times. > This proposal outlines the syntax for configuring relevant metadata. To > provide users with a structured approach to manage these configurations, > scheduler settings are stored in a dedicated metadata table. The proposed > syntax enables users to add or remove query groups, adjust their > priorities, and modify parameters related to the dynamic workload module as > described in this document. > > The new syntax APE: > *Metadata Configuration Syntax APE > < > https://urldefense.com/v3/__https://cwiki.apache.org/confluence/display/ASTERIXDB/APE*18*3A*Dynamic*Workload*Configuration*Statement*Syntax__;KyUrKysrKw!!CzAuKJ42GuquVTTmVmPViYEvSg!N6OgQ_Js6tUcWTPhlPUr-rMDOVV6uAgF4Yd34jt11rrQ44TOj3h7ohoMLBON8hILidNGScSTo_gHmH16EA$ > > > * > To view the previous DWM APE: > *Dynamic Workload Management APE* > < > https://urldefense.com/v3/__https://cwiki.apache.org/confluence/display/ASTERIXDB/APE*13*3A*Dynamic*Workload*Management__;KyUrKys!!CzAuKJ42GuquVTTmVmPViYEvSg!N6OgQ_Js6tUcWTPhlPUr-rMDOVV6uAgF4Yd34jt11rrQ44TOj3h7ohoMLBON8hILidNGScSTo_iudkWuZw$ > > > > > Greatly appreciate any feedback on the syntax design to help identify > potential issues and refine it further. Thanks so much! > > Best, > Hongyu >
