数据库管理系统通常绕过文件系统是真的吗？ [英] Is it true that database management systems typically bypass file systems..?

问题描述

我的一般理解是，典型的数据库管理系统绕过文件系统是否正确？我理解他们在磁盘上管理自己的空间，他们将实际的数据和索引系统（如B树）直接写入磁盘块，绕过文件系统中的任何中间帮助。

Is my general understanding that a typical database management systems bypass file system correct? I understand that they manage their own space on disk and they write actual data and index systems like B tree directly into disk blocks bypassing any intermediate help from file system.

该根将为数据库用户提供从磁盘块直接读取和写入的权限。在Linux中，这更容易，因为磁盘可以当作一个文件处理。

This assumes that root would provide the database user permission to directly read and write from disk blocks. In Linux, this is still easier as disk can be treated as a file.

任何指向真实案例研究的指南都将非常感谢。

Any pointer to real case studies will be greatly appreciated.

推荐答案

大多数依赖于底层文件系统 WAL etc：基本上它们将它们外包给操作系统。

Most rely on the underlying file system for WAL etc: basically they outsource it to the OS.

一些DBMS支持（Oracle，MySQL）原始分区，典型。太麻烦（查看关于Postgres的这个聊天），因为你仍然需要WAL等原始分区。

Some DBMS support (Oracle, MySQL) "raw" partitions, but it isn't typical. Too much hassle (see this chat about Postgres) because you still need WAL etc on your raw partition.

这篇关于数据库管理系统通常绕过文件系统是真的吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！