List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 11 2001 5:23am
Subject:Re: Mysql Quota Support/DB Size Limitations
View as plain text  
At 10:23 PM -0700 5/10/01, Nathan Boley wrote:
>Hi, I was interested in implementing size limitations on specific databases.
>I've searched the mysql docs for an mention of quota support, but I am not
>able to find any.  I found that by chown the individual database directories
>and their files and then chmod them to be world readable I can access the
>database.  My assumption (as of yet untested) is that given the databases
>group read permission would give me similar results. Then, I can make use of
>Linux's quota system.  The problem arises with the creation of new tables;
>mysql creates all new tables as the user mysql. It doesn't seem as if it
>would be too large a chore to change the source code so that the physical
>files are created in the user connected to the database through (surprise!)
>a mysql database.  However, I don't know where I would begin such an
>endeavor (any responses suggesting I start in the source code will be duly
>ignored).  My question is whether anyone has encountered a similar situation
>and, if so, how he/she worked around/fixed it or, barring that, where I
>would insert code to dynamically change the files' ownership.

In order to make this work, you'd have to have the server run as root
so that it could chown files to different owners.

That's a huge security risk.


Paul DuBois, paul@stripped
Mysql Quota Support/DB Size LimitationsNathan Boley11 May
  • Re: Mysql Quota Support/DB Size LimitationsPaul DuBois11 May
  • Re: Mysql Quota Support/DB Size LimitationsDan Nelson11 May