v.21.3Improvement

Quota Enhancements in SHOW TABLES and SYSTEM Queries

Quota improvements: SHOW TABLES is now considered as one query in the quota calculations, not two queries. SYSTEM queries now consume quota. Fix calculation of interval's end in quota consumption. #20106 (Vitaly Baranov).
Quota improvements: The SHOW TABLES command is now counted as a single query in quota calculations instead of two. Additionally, SYSTEM queries are now included in quota consumption, and the calculation of the quota interval's end has been fixed.

Why it matters

These improvements provide more accurate and consistent enforcement of query quotas by correctly counting and including SYSTEM queries, and by fixing the interval boundary calculation. This ensures users are fairly limited according to quota policies and prevents unintended quota overruns or miscalculations.

How to use it

No explicit action is required. The quota calculations and enforcement automatically incorporate these changes once the updated version is used.