List:General Discussion« Previous MessageNext Message »
From:Rick James Date:July 2 2013 7:37pm
Subject:RE: Mysql resource limits.
View as plain text  
cgroups won't work for individual MySQL "users", only for mysqld as a whole.

Monitor the slowlog and help the naughty users fix their naughty queries.

> -----Original Message-----
> From: Rafał Radecki [mailto:radecki.rafal@stripped]
> Sent: Tuesday, July 02, 2013 3:07 AM
> To: mysql@stripped
> Subject: Mysql resource limits.
> 
> Hi All.
> 
> I would like to limit resources available to a given user in mysql. I know
> that there is https://dev.mysql.com/doc/refman/5.5/en/user-resources.html,
> I also know that cgroups can be used at operating system level.
> 
> What are your experiences in limiting resources in mysql? I've user
> percona statistics and had information provided by it. Are there any
> better solutions?
> 
> Best regards,
> Rafal Radecki.
Thread
Mysql resource limits.Rafał Radecki2 Jul
  • RE: Mysql resource limits.Rick James2 Jul