Bug #15250 Limit a user CPU usage
Submitted: 25 Nov 2005 18:31 Modified: 26 Nov 2005 14:30
Reporter: Bernardo Torres Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0, 5.1, 5.5 OS:Any
Assigned to: CPU Architecture:Any
Tags: bfsm_2007_03_01

[25 Nov 2005 18:31] Bernardo Torres
How can I control a user's CPU usage? Because even if I limit his requests and he launches a huge request, he will bring the server down.

Is there anyway I can launch the requests in a proccess-based manner? This way I could limit the proccess, not the user.

How to repeat:
Create a huge query, and watch your server going bye bye...

Suggested fix:
Create a per-user CPU limit...

or a better solution would give the user an option to create a proccess to each request (or user), so the OS could limit it better.
[26 Nov 2005 14:30] Valeriy Kravchuk
Thank you for a useful feature request. We already have plans to deal with per-user CPU usage limits in future versions.

As for creating separate process for each user connection, it is not a MySQL way to implement multiuser support. This will never be done, I believe.
[26 Nov 2005 17:33] Sergei Golubchik
There is max_join_size that can be used for that to a certain extent.
[20 Dec 2006 19:42] Paul Botelho
As a MySQL Customer I'd like to add a our "Vote" for this request as well.
[15 Feb 2007 23:24] Frederic Wenzel
Any news on this improvement? When we recently discovered problems with complicated queries bringing our database server down, we realized that this feature would have saved us as well. A rate limit would not catch this, unfortunately.

[20 Oct 2011 13:10] James Grinter
Any progress on this? It's been nearly 7 years...
[23 Oct 2014 10:45] Nyaapa Arseny
Any progress on this? It's been nearly 9 years...
[19 Jan 2017 15:39] Ivan Ivanov
Any progress on this? It's been nearly 12 years...
[26 Apr 2020 5:57] Derek Perkins
Just checking in again
[26 Apr 2020 8:27] MySQL Verification Team
Does this help?
[29 May 2020 7:22] Derek Perkins
Yes, that looks great, I'll have to dig into it.