Comments - Database corruption and data loss in mariadb

2 years, 11 months ago Daniel Black

While there are a number of scenarios around disk full when the server will either fail the transaction, potentially crash, there are a significant number of failure cases and not all can be easily tested. Therefore I say sadly I cannot guarantee 0% dataloss in the case of partition being full case.

Please try to avoid the situation of MariaDB running out of disk space.

 
2 years, 11 months ago Jan Steinman

If disk full is a concern, I suggest a simple cron job that runs every so often, alerting you to potential disk full conditions.

That will be much less overhead than if every single MariaDB transaction checks if there is space available before committing!

  1. df . | tail -1 | awk '{ print $5 } 41%
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.