Bug #75089 Enhance Account Resource Limits types
Submitted: 3 Dec 2014 13:20
Reporter: Tim Smith Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.6.20/5.7 OS:Any
Assigned to: CPU Architecture:Any

[3 Dec 2014 13:20] Tim Smith
After look up the manual http://dev.mysql.com/doc/refman/5.6/en/user-resources.html, I think some types of resource limit is missing: CPU, RAM & Disk limits.

Limiting the max connections or queries are not enough. A single large query (i.e. very high counts of row examined) may needs lots of CPU, RAM & Disk limits.

How to repeat:
(It is a suggestion. No existing procedure or command to repeat it.)

Suggested fix:
Please add CPU, RAM & Disk limits. For example, max CPU or RAM usage per query. Take disk as another example, limit the max I/O per second or bytes read or write per second.