On Fri, 08 Oct 1999, Joe Pearson wrote:
> What about raw partitions on linux. I thought linux does not support
> raw partitions (maybe this has changed?) Since Sybase really
> recommends databases be put on raw partitions so that disk writes are
> not buffered by the OS.
Doesn't seem to have hindered it in any way for me. Linus has discussed raw
partitions several times - the upshot being that they tend to be no faster
than using e2fs because e2fs is very fast anyway, and you'd simply have to
implement a lot of the e2fs functions inside of your database anyway.
Anyhow - I don't know about all the internal workings of these things -
just that it works and is damn quick for me.
BTW: Someone benchmarked Oracle on Linux vs Oracle on NT (using TPC code)
and found the Linux version to be about 4-7 (depending on the test) times
faster. So I guess that's a finger in the eye to raw partitions (I think
the NT version can use raw partitions - correct me if I'm wrong).
--
<Matt/>
Details: FastNet Software Ltd - XML, Perl, Databases.
Tagline: High Performance Web Solutions
Web Sites: http://come.to/fastnet http://sergeant.org
Available for Consultancy, Contracts and Training.