Messages in this thread | | | From | Mike Harrold <> | Subject | Re: O_DIRECT please; Sybase 12.5 | Date | Fri, 29 Jun 2001 08:49:28 -0400 (EDT) |
| |
> > Alan Cox wrote: > > > > > the boss say "If Linux makes Sybase go through the page cache on > > > reads, maybe we'll just have to switch to Solaris. That's > > > a serious performance problem." > > > > Thats something you'd have to benchmark. It depends on a very large number > > of factors including whether the database uses mmap, the average I/O size > > and the like > > I'll probably benchmark raw vs. non-raw I/O with Sybase ASE 12.5 > on our application once we've come up to speed on basic performance > issues (we're database newbies).
Quite obviously. One of the primary things a DBA is supposed to do is ensure that the disk is accessed as *few* times as possible. What size database do you have? How much memory has the machine have? How much memory does the database have? How many engines is the database running?
We can take this off-list if you want, but disk I/O shouldn't really be an issue for any database as long as other parameters are set correctly. Sybase recommends raw devices *not* because they are faster, but because it's the only way that they (Sybase) can guarantee the data is actually written to disk (legal liability, etc.).
/Mike (Sybase DBA)
- To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/
| |