Bug #90705 Assigning resource groups automatically based on database
Submitted: 30 Apr 2018 18:52 Modified: 5 Dec 2019 13:50
Reporter: Jason Rahman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Apr 2018 18:52] Jason Rahman 
Description:
Currently queries/connections are associated with resource groups via query hint or special functions. However, in some environments, an administrator may want to isolate queries against a given database because each database may represent a shard owned by a different tenant.

How to repeat:
Documentation does not appear to indicate this is possible today.

Suggested fix:
Support a mechanism to automatically associate queries run from a connection with a default database with a resource group associated with that database. Alternatively, if the query involves a table in a database, the resource group associated with that database is used.
[5 Dec 2019 13:50] MySQL Verification Team 
Hi Mr. Rahman,

I find your feature request acceptable.

Verified as reported.