Re: [00/17] Large Blocksize Support V3

[William Lee Irwin III <wli@holomorphy.com>]

On Fri, Apr 27, 2007 at 08:22:07PM +1000, Nick Piggin wrote:
>>> Just a random aside question... doesn't Oracle db do direct IO from
>>> hugepages?

William Lee Irwin III wrote:
>> If and when configured to use direct IO and hugepages, yes.

On Fri, Apr 27, 2007 at 11:06:36PM +1000, Nick Piggin wrote:
> Sweet. I wonder if you would see a much improvement for allowing more
> than 128 sglist entries, then.

There should be some. Oracle does its own IO scheduling, so it's able
to submit relatively large IO's (IIRC also configurable). I'm not sure
what's done for the non-aio case, but aio might be tricky to catch the
vectoring with all the blocking on get_request_wait() and the way the
vector elements are handled there. So turning off aio may also help.

Another useful idea is to look at the results from pagemap patches.


William Lee Irwin III wrote:
> >It's also
> >noteworthy thar Oracle has more code than its database.
> 
On Fri, Apr 27, 2007 at 11:06:36PM +1000, Nick Piggin wrote:
> Anything noteworthy in this context, that you care to note?

The RMAN backup utility is often used to back up Oracle databases
and there are always complaints when backups disturb anything.

EM (enterprise management stuff), RAC (clustering affairs), various
database applications (typically in-depth for whatever field they're
pertinent to), ASM middleware (abstraction layer for database file
access), and more are out there.


-- wli