3 ms·
From MySQL's documentation: https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.ht... > C
by neuronexmachina 9y ago
From MySQL's documentation:
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.ht...
> Caution: Many operating systems and some disk hardware fool the flush-to-disk operation. They may tell mysqld that the flush has taken place, even though it has not. In this case, the durability of transactions is not guaranteed even with the setting 1, and in the worst case, a power outage can corrupt InnoDB data. Using a battery-backed disk cache in the SCSI disk controller or in the disk itself speeds up file flushes, and makes the operation safer. You can also try to disable the caching of disk writes in hardware caches.
- ausjke 9y agogreat, thanks for the finding.
- stronglikedan 9y agoPardon my ignorance, but do you know if this would affect PG as well, since it's an OS/hardware sourced issue?
- ddorian43 9y agoIt's same issue grandparent mentioned.