Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Linux File system and Oracle setup

Re: Linux File system and Oracle setup

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Sun, 12 Jun 2005 07:27:58 GMT
Message-ID: <2uRqe.1013685$b5.43842186@news3.tin.it>


Noons wrote:

>
> Has anyone played with this at all? I saw a reference on the kernel
> docs for 2.6 to the tune of elevators being redundant with this
> level of the software. Any ideas?
>

In 2.6 the ioscheduler changed and lvtune is now deprecated.

You have to mess with sysfs now:
/sys/block/<device>/queue/iosched

Since I like to quote:

"Nick Piggin <piggin_at_cyberone.com.au> 13 Sep 2003

Attention! Database servers, especially those using "TCQ" disks should investigate performance with the 'deadline' IO scheduler. Any system with high
disk performance requirements should do so, in fact."

And again:

"For some workloads the anticipatory scheduler is around 10% slower

   than deadline. Most notably, database workloads which seek all over the    disk performing reads and synchronous writes. Database folks will likely    want to boot with elevator=deadline to get that last bit of performance back."

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe
Received on Sun Jun 12 2005 - 02:27:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US