List:General Discussion« Previous MessageNext Message »
From:Dean Harding Date:September 1 2002 12:03am
Subject:RE: limiting the user
View as plain text  
Hey,

You can limit the size of the database by specifying a quota on the
directory created by MySQL for that database.

When you create a database, all MySQL does is create a directory under
the data directory for that database.  You can then set a quota on that
directory using whatever tools your OS supplies.

This won't limit the number of tables, or the specific size of any one
table, but it might be all you need...

Dean.

> -----Original Message-----
> From: Soheil Shaghaghi [mailto:soheils@stripped]
> Sent: Sunday, 1 September 2002 9:35 am
> To: mysql@stripped
> Subject: limiting the user
> 
> Hi everyone,
> I am running a FreeBSD server with MySQL 3.23
> I want to let my virtual users create/drop tables and limit the size
of
> each
> table, and also the number of tables they can create.
> 
> Can someone please tell me how I can do this?
> Is it possible wit applications such as webmin, or phpMyAdmin?
> 
> Thanks so much
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread118505@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-
> deanie=bigpond.net.au@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
performance tunning 4.xSean Hager28 Aug
  • Re: performance tunning 4.xIikka Meriläinen28 Aug
    • RE: performance tunning 4.xSean Hager28 Aug
      • RE: performance tunning 4.xIikka Meriläinen28 Aug
        • RE: performance tunning 4.xmos29 Aug
          • Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander29 Aug
            • Re: Installing mysql 4.0.3 with linux threads on freebsdDan Nelson29 Aug
              • Re: Installing mysql 4.0.3 with linux threads on freebsdVarshavchick Alexander30 Aug
            • limiting the userSoheil Shaghaghi30 Aug
              • limiting the userSoheil Shaghaghi1 Sep
                • RE: limiting the userDean Harding1 Sep
          • RE: performance tunning 4.xIikka Meriläinen29 Aug
          • Re: RE: performance tunning 4.xVictoria Reznichenko30 Aug
            • Re: RE: performance tunning 4.xmos30 Aug
              • Re: RE: performance tunning 4.xPaul DuBois30 Aug
              • Re: Re: RE: performance tunning 4.xVictoria Reznichenko31 Aug