Home > Archive > ASE Database forum > October 2005 > solaris ramdisk and tempdbs









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author solaris ramdisk and tempdbs
Jesus M. Salvo Jr.

2005-10-27, 8:21 am


Solaris9 SPARC.

Is there any difference, performance wise, between using:

1) tempdbs on tmpfs
2) tempdbs on ufs on ramdisk
3) tempdbs on raw on ramdisk


Opera

2005-10-27, 8:21 am

Jesus M. Salvo Jr. wrote:
> Solaris9 SPARC.
>
> Is there any difference, performance wise, between using:
>
> 1) tempdbs on tmpfs
> 2) tempdbs on ufs on ramdisk
> 3) tempdbs on raw on ramdisk
>
>

a filesystem with fs-type "tmpfs" will use solaris virtual memory.
This is your physical memory + your swap space.

if you place tempdb on a raw device or (Veritas) Volume,
then the Solaris kernel / IO system will do an optimal I/O chaching for you.

using a tmpfs-filesystem does not bring a real benefit.
there is on ufs on a tmpfs-filesystem.
Jesus M. Salvo Jr.

2005-10-27, 8:21 am

Opera wrote:

> Jesus M. Salvo Jr. wrote:
> a filesystem with fs-type "tmpfs" will use solaris virtual memory.
> This is your physical memory + your swap space.
>
> if you place tempdb on a raw device or (Veritas) Volume,
> then the Solaris kernel / IO system will do an optimal I/O chaching for
> you.
>
> using a tmpfs-filesystem does not bring a real benefit.
> there is on ufs on a tmpfs-filesystem.



So I presume no-one has use tempdbs on a raw device on ramdisk ??




Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com