DelphiFAQ Home Search:

How to limit the size of a MySQL database


commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

MySQL has no option to set a size limits, but since mysql runs on your operating system's file system, you might be able to specify disk limits there.

When your disk is full or you've reached your quota, mysql will not be in an inconsistent state. The exact
behaviour to this condition is documented in the mysql manual. You may be getting some 'hanging threads' but they'll resume as soon as you make space.

Content-type: text/html


2009-06-03, 10:59:04
anonymous from Lithuania  
2009-12-22, 22:48:13 from India  
Is there any way, I can set the limit for Database in mysql.
Example: I want to set the limit that, mysql db should not grow more than 10 MB.
like that...any idea ?



NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: