2 ms·
> No DB systems have raw access to sectors or direct raw access to files. Oracle can use raw disks without having a filesystem on them, though it's more common
by ndsipa_pomu 2y ago
> No DB systems have raw access to sectors or direct raw access to files.
Oracle can use raw disks without having a filesystem on them, though it's more common to use ASM (Automatic Storage Management) which is Oracle's alternative to raw or OS managed disks.
- kalleboo 2y agoMySQL also supported this a million years ago, I'm not sure if it still does
- theGeatZhopa 2y agoOh nooo, I forgot, there are real databases existing in the wild, too ... :) https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ntqrf/raw-partition-overview.html https://docs.oracle.com/en/database/oracle/oracle-database/1... Indeed. Offers 10-12 percent performance writing direct on a block device. But, this block device is still attached to a running system :)