Re: [PERFORM] Very poor read performance, query independent

2017-07-15 Thread Mark Kirkwood
Right, that is a bit of a show stopper for those SSD (the Intel needs SATA 6Gb/s and the Sammy's need PCIe 3.0 to perform to their rated specs). regards Mark On 16/07/17 04:12, Charles Nadeau wrote: Mark, The server is a . It doesn't really work with SATA drives. And when you find one

Re: [PERFORM] Very poor read performance, query independent

2017-07-15 Thread Scott Marlowe
On Sat, Jul 15, 2017 at 11:53 AM, Charles Nadeau wrote: > Mark, > > I increased the read ahead to 16384 and it doesn't improve performance. My > RAID 0 use a stripe size of 256k, the maximum size supported by the > controller. Are your queries still spilling to disk for

Re: [PERFORM] Very poor read performance, query independent

2017-07-15 Thread Charles Nadeau
Mark, I increased the read ahead to 16384 and it doesn't improve performance. My RAID 0 use a stripe size of 256k, the maximum size supported by the controller. Thanks! Charles On Sat, Jul 15, 2017 at 1:02 AM, Mark Kirkwood < mark.kirkw...@catalyst.net.nz> wrote: > Ah yes - that seems more

Re: [PERFORM] Very poor read performance, query independent

2017-07-15 Thread Charles Nadeau
Mark, The server is a HP DL 380 G6. It doesn't really work with SATA drives. And when you find one that is compatible, it is only used at 3Gb/s with a maximum of 5 IOPS (a well know caracteristic of the HP P410i SAS RAID controller). I am looking at getting a Kingston Digital HyperX Predator