Bug #75089 Enhance Account Resource Limits types

• Submitted: 3 Dec 2014 13:20
• Reporter: Tim Smith
• Status: Open
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 5.6.20/5.7
• OS: Any
• CPU Architecture: Any

[3 Dec 2014 13:20] Tim Smith

Description:
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.