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:

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.
It seems that you are from Washington, US . Info/ Feedback on this	Show city and country Show country only Hide my location
Leave your comment here:
Please type in the code:
Add a picture: 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.