How to limit the size of a MySQL database

This 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.

Comments:

2009-06-03, 10:59:04

anonymous from Lithuania

parasyta

2009-12-22, 22:48:13

http://www.hire-web-developers.com/ 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 Off-topic Very Helpful Helpful Ok article Not useful Very bad	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. Add a picture: