MySQL Forums
Forum List  »  Performance

Create performance limit for a user
Posted by: József Mesics
Date: July 21, 2021 11:56PM

Hi All,

I would like a create a user who has strong limitation of resource (cpu).
The our tables filled by measuring tool and sometimes the user makes big querys.
This queries spend lot of resource.

I have tried to set RESOURCE GROUP, but I cannot assing to user or threadid.

CREATE RESOURCE GROUP slowuser type=user vcpu=1 THREAD_PRIORITY = 19;
SELECT THREAD_ID FROM performance_schema.threads; --- read threadid
SET RESOURCE GROUP RG_slowuser FOR 3793
and I got error:
Error Code: 3660. Invalid thread id (3793)

What is the good way to make limitation for a user?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Create performance limit for a user
125
July 21, 2021 11:56PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.