I am able to set cpulimit, iolimit, etc for a process using its pid through cgroups v2. But for some threads of a single mysql process, how can I achieve that?
![image.png](attachments/pngcg9h_bqown.png)
![image.png](attachments/png8mkL4jkSRT.png)
When I see the database processlist, I get the TID of the mysql queries executed.
![image.png](attachments/pngcg9h_bqown.png)
I can see those TIDs consuming alot of cpu usage through htop command.
![image.png](attachments/png8mkL4jkSRT.png)
I am doing this because I want to set resource limits for some mysql users. Is there any way I can do this?