Max Limits For Hostings

[tansu]

Hi to all,
I remember when I used to use shared hostings, when your site gets bigger, there would be some problems about max queery limits per hour, etc.
How can we set this values up in directadmin for certain user packages.
For example I want X user package to have max 50 000 querry limit per hour..
Regards

 

[Rich-Boy]

Hi Tansu,
First of all, it sounds like you are referring to user database limits that can be imposed by MySQL am I correct? If this is the case then as far as I'm aware it isn't possible to use DirectAdmin to either manually or automatically add/remove/alter query limits imposed by MySQL.
MySQL allows you to set MAX QUERIES PER HOUR, MAX UPDATES PER HOUR, MAX CONNECTIONS PER HOUR and MAX USER_CONNECTIONS limitations (and possibly more) either directly via the shell or via a nice GUI courtesy of PHPMyAdmin (which ships with DirectAdmin) but DirectAdmin plays no part in setting these values.

I would suggest either reading up on the MySQL syntax for setting privileges for users/databases or log into phpmyadmin and edit privileges from there.

 

[tansu]

Thanks a lot Rich-Boy