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://cwiki.apache.org/confluence/display/ASTERIXDB/APE+18%3A+Dynamic+Workload+Configuration+Statement+Syntax> * To view the previous DWM APE: *Dynamic Workload Management APE* <https://cwiki.apache.org/confluence/display/ASTERIXDB/APE+13%3A+Dynamic+Workload+Management> Greatly appreciate any feedback on the syntax design to help identify potential issues and refine it further. Thanks so much! Best, Hongyu
