3 ms·
> And what if it's not your PhD thesis in Libre Office but a busy database server which can easily get corrupted if you don't flush. Wouldn't that make it an u
by garblegarble 13y ago
> And what if it's not your PhD thesis in Libre Office but a busy database server which can easily get corrupted if you don't flush.
Wouldn't that make it an unsafe database server?
- slashdotaccount 13y agoYes, I agree, but just several weeks ago I had to recover a MySQL InnoDB database after a power problem. MySQL is very popular, and it turns out it is an unsafe database server according to your definition. Well maybe it is. Edit: Besides, hard drives have write caches, and they can report a successful write operation to the OS when the data is still in its cache physically.
- deelowe 13y agoI don't believe MySQL is ACID compliant. You may have just ran into one of the reasons how.
- cookiecaper 13y agoMySQL is only ACID compliant under a very specific set of configuration parameters. This makes it even more dangerous than an RDBMS with binary acidity.
- marcosdumay 13y agoYep, MySQL is an unsafe database. The fact that it's popular just goes to show how powerful marketing is on th emind of most people. Hard drivers are supposed to flush their caches before they report the end of a flush operation to the OS (some flush into flash, but they flush). If your does not, it's defective. Go ahead and make use of the warranty.
- fulafel 13y agoRe HD lying, this is rare except with dubious cheap flash sticks. The caching command set is well defined and operating systems know how to issue the relevant SCSI/SATA commands. It's critical for correct functioning of journaling filesystems such as NTFS and Ext4.