Re: Optimizing write performance

Joe Lumbley wrote: > > Stefan Weideneder (stefan@weideneder.de) wrote: > : Stephen Walmsley wrote: > : > > : > Further to the recent discussion about the relative merits of mirroring, > : > RAID etc., what if I had a database which is updated in bulk and queried > <snip> > > : Hi, > > : first I guess it's a good idea to spread the huge table across > : several disks and perform the i/o in parallel mode. It's also > > He's on 4.1. Any parallelism will have to be done programmatically, because > the engine doesn't support it. > > -- -------------------------Original text-------------------------------- > I thought of using plain old raw partition allocation and arranging > for the chunk allocation to happen in such a way that each of the big > tables reside on seperate disks and then do the batch inserts, deletes > and updates across multiple tables simultaneously. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I guess Steven wants to run several programs concurrently on seperate disks. This is a kind of parallel I/O, isn't it ? Stefan Weideneder