v.23.4Experimental Feature

Per-user Quotas in Query Cache Now Possible

It is now possible to define per-user quotas in the query cache. #48284 (Robert Schulze).
Per-user quotas support in query cache. It is now possible to define and enforce individual query cache quotas for different users.

Why it matters

This feature enables finer control over query cache resource allocation by setting quotas on a per-user basis. It helps prevent a single user from consuming excessive query cache resources, ensuring fair usage and improving overall system stability in multi-tenant environments.

How to use it

To use this feature, configure the query cache quotas for specific users in the server settings or user profiles. Define the appropriate quota limits under each user's configuration to control their query cache usage.