Create performance limit for a user

[József Mesics]

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.