The recommended mode is 'abusers' - in that mode once user goes over the limits specified in the MySQL Governor , all his queries will execute inside that user's LVE. We strongly recommend using this mode of operations, please switch to it with:
Code:
dbctl --lve-mode abusers
About the slow query execution - the limit can be configured per user as well, the config block will be the following:
Code:
<user name="specific_user" mysql_name="specific_user_mysql" mode="restrict"> <limit name="slow" current="10"/> </user>
Leave a comment: