Re: 2x Oracle slowdown from 2.2.16 to 2.4.4

Chris Mason (mason@suse.com)
Wed, 11 Jul 2001 13:23:56 -0400


On Wednesday, July 11, 2001 07:08:21 PM +0200 Andrea Arcangeli
<andrea@suse.de> wrote:

> On Wed, Jul 11, 2001 at 09:44:19AM -0700, Brian Strand wrote:
>> Our Oracle configuration is on reiserfs on lvm on Mylex. Our workload
>> is not entirely cached, as we are working against an 8GB table, Oracle
>> is configured to use slightly more than 1GB of memory, and there is
>> always several MB/s of IO going on during our queries. The "working
>> set" of the main table and indexes occupies over 2GB.
>
> As I suspected there is the VM in our way. Also reiserfs could be an
> issue but I am not aware of any regression on the reiserfs side, Chris?

reiserfs has a big O_SYNC penalty right now, which can be fixed by a
transaction tracking patch I posted a month or so ago. It has been tested
by a few people as a large improvement. Brian, I'll update this to 2.4.6
and send along.

-chris

-
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/