472,131 Members | 1,464 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,131 software developers and data experts.

disk quota in MySQL


Is there a way to assign a limit on the size of a specific database? For
example database A can take up no more than 500 MB.
One of my databases can potentially grow without any bounds and possibly
stop other critical databases from operating.
We are using MySQL 4.0.21 on Linux. We use innodb tables.

- Rajesh
Aug 23 '05 #1
1 2404
Rajesh Kapur wrote:
Is there a way to assign a limit on the size of a specific database?

This question comes up on this newgroup from time to time.
I've searched for a solution, but there are no satisfactory ones.

Some solutions involve having a scheduled job detect when a database has
exceeded the authorized space, and then raise it to the attention of the
system administrator.

Some solutions involve trying to use the operating system's quota
enforcement (where available), but this solution is complex and usually
insufficient, because MySQL databases are generally all owned by one
user id, and stored under one directory. So unless the quota
enforcement can be made per-directory or per-file, it's hard to use this
way. Also, InnoDB tables are all stored together in one physical file,
regardless of how many databases they belong to.

Some solutions involve putting the database files on separate
filesystems, and symbolically link them into MySQL's data directory.
When the filesystem fills up, further writes get fatal errors. But this
is not a very good strategy for graceful error handling.

MySQL has no built-in property to define and enforce a limit to the size
or number of records in a database or table. At least, not that I've found.

Bill K.
Aug 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bart Simpson | last post: by
reply views Thread by Andrew Crook | last post: by
1 post views Thread by Simon Hall | last post: by
2 posts views Thread by Joe | last post: by
3 posts views Thread by =?Utf-8?B?bWFkY3lyeWw=?= | last post: by
5 posts views Thread by mostro713 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.