Question Request to Confirm Database Query and Change Limits

[Thomas Oryon]

Server operating system version

Rhel

Plesk version and microupdate number

18.0.78

Hello Support Team,

We would like to check whether the following database usage limits can be configured and enforced on our Plesk hosting server:

1. Database queries should not exceed 1,000 queries per hour.
2. Database changes such as INSERT, UPDATE, and DELETE should not exceed 300 changes per hour.

Please confirm whether these limits can be applied per subscription/account or per database user in Plesk.

If this is not supported directly in Plesk, kindly advise the recommended solution or workaround to monitor and restrict excessive database usage.

Also, please let us know whether there is any built-in reporting, alerting, or automatic suspension option if a customer exceeds these database limits.

Awaiting your advice.

 

[Sebahat.hadzhi]

Hi, @Thomas Oryon . No, you cannot directly limit the number of SQL queries per subscription/user through Plesk. The closest ready alternative I can think of is CloudLinux's MySQL Governor that can help you indirectly enforce limits by controlling database resource consumption per user.

 

[Thomas Oryon]

Hello @Sebahat.hadzhi

Thanks for the update. But we are not using Cloudlinux in our plesk servers. We need an alternative solution for our requirments.

Kindly check and let us know.

Awaiting your reply.