On Monday 20 June 2011 21:24:05 Peter Laursen wrote: > @Marain .. you probably know this: > http://dev.mysql.com/doc/refman/5.1/en/user-resources.html . This is same > for MySQL and MariaDB.
Yup, I know those. But I need to have those also per 24h period not only 1h. > > I_S is a *read-only* database. And if you want to add more configurable > per-user limitations such should IMHO go to the `mysql` database. I also > don't think (for compability) that it should be more rows added > `mysql`.`user` then, but maybe rather a new table specific for such patch ( > `mysql`.`user_addon` or whatever). > > But what per-user limitations do you want to add exactly? > I'm working in the shared hosting industry and I'm interested in the CPU_TIME, BUSY_TIME, BYTES_RECEIVED and BYTES_SEND. I agree that the best place would be the mysql database and a separate table/tables. However I believe that it would be best if once the values are changed, they appear in the INFORMATION_SCHEMA. > > Peter > (from Webyog and thus not a MariaDB developer - just a follower here) > > On Mon, Jun 20, 2011 at 20:03, Marian Marinov <[email protected]> wrote: > > Hello guys, > > I have a lot of clients requesting some kind of per user limiting based > > on the > > information from the STATISTICS tables. > > > > I'm thinking of creating a patch that will add this functionality by > > creating > > > > two more tables in the INFORMATION_SCHEMA: > > USER_LIMITS > > CLIENT_LIMITS > > > > They will have some parts of the structure of USER_STATISTICS and > > CLIENT_STATISTICS and will keep only values for limits. By default a 0 > > would > > mean no limit. > > > > Do you have any comments about my aproach? > > > > Would you be willing to accept a patch that adds such functionality? > > > > I want to know before I start work on this project if the community is > > interested in such enhancement of MariaDB. > > > > Regards, > > Marian > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-developers > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~maria-developers > > More help : https://help.launchpad.net/ListHelp -- Best regards, Marian Marinov
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
