Disk striping using mirroring 
Author Message
 Disk striping using mirroring

We are trying to optimize disk performance, and we came up with this
idea of achieving a rudimentry disk striping using OnLine mirroring.

Currently we have two 1.5 GB disks, one of which has 3 Primary chunks
and the other one has three Mirror chunks.  During execution of
large "select" queries the drive containing Primary chunks has
utilization of 100% whereas the other drive is idle.  That means that
Informix doesn't use Mirror chunks for reading (this is probably burried
somewhere in the manual but I didn't see it in my first glance).

So the idea is to make one of the chunk (or two if we divide the dbspace into
four chunks) on the second drive a primary chunk and change the corresponding
chunk on the first drive as Mirror chunk.  So now, during a read both the
drives have teh chance to participate.  This should ideally improve
the performance during reads.

Now, the question is has anyone tried this before or are there any
potential problems/issues with this approach?

Thanks for any responses.

---------------
Yogen Sanghani

(212)972-4266



Mon, 22 Apr 1996 07:15:53 GMT
 Disk striping using mirroring

I received four responses , the summary is that it is a good, standard way
of optimizing disk performance.  One of the response was that Informix 6.0
is going to be using mirror chunks for reading.  Thanks for the responses.

: ---------------
: Yogen Sanghani

: (212)972-4266



Wed, 24 Apr 1996 02:29:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Sybase Disk Mirroring vs Solaris Disk Mirroring

2. Disk mirroring using a RAID disk setup

3. Effect of disk striping on disk layout

4. Informix dbspace mirroring VS. Operating System disk mirroring

5. Disk Mirroring using AP on Lantastic Net: ????

6. AIX disk mirroring versus specifying separate physical disks

7. Stripe + Mirror vs. RAID 5

8. Striping AIX Mirrored Devices

9. Disk Stripe Sizing for SQL Database

10. Disk Striping Question...

11. XP256 Disk Striping for an Oracle 8.1.7 DataWarehouse

12. datafiles vs. logical volumes for disk striping


 
Powered by phpBB® Forum Software