Iavor,
if you use the directory quota method and InnoDB's
innodb_file_per_table
option in 4.1.9, I would be interested to hear the results. If the space
runs out in a database directory, then INSERTs etc. in that database should
fail with the error 'Table is full' and the SQL statement should be
Hi Iavor,
On Fri, 2005-01-21 at 02:33, Iavor Stoev wrote:
> I have trouble with setting mysql database quota per user at my
> server.
>
> I`m using MySQL 4.0.22 on Linux with kernel 2.4.29.
>
> I`m using group quota on my server and all user`s files, mails and
> databases are with group $user (
I think you can set a max quota for a table.
Insane
- Original Message -
From: "Henry Umansky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 21, 2002 8:08 PM
Subject: mysql quota
> I want to let users on my system use MySQL, but I want them to have some
> sort of quot
Alex,
Mysql does not do quota for users (atleast as far as I know). But I
read once in sysadmin mag that an programmer at an isp wrote a mysql
quota daemon. The article is not on the web but here is the issue:
http://www.sysadminmag.com/articles/2002/0202/
There is a link on the left ha
Alex,
Thursday, August 22, 2002, 4:54:01 AM, you wrote:
AJ> We want to set quota per user. Is that possible on MySQL ? If so
AJ> how can that be done?
Depends on what you want to limit per user. Some info you can find
here:
http://www.mysql.com/doc/en/User_resources.html
--
For technic
In the last episode (May 10), Nathan Boley said:
> 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 fi
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 an
