Re: [PERFORM] Advice sought : new database server

2012-03-07 Thread Shaun Thomas
On 03/07/2012 03:07 PM, Craig James wrote: echo 4294967296 >/proc/sys/kernel/shmmax # 4 GB shared memory echo 4096 >/proc/sys/kernel/shmmni echo 1572864 >/proc/sys/kernel/shmall # 6 GB max shared mem (block size is 4096 bytes) For what it's worth, you can just make these entries in your /etc/

Re: [PERFORM] Advice sought : new database server

2012-03-07 Thread Craig James
On Wed, Mar 7, 2012 at 12:18 PM, Merlin Moncure wrote: > On Mon, Mar 5, 2012 at 10:56 AM, Craig James > wrote: > > On Sun, Mar 4, 2012 at 10:36 AM, Rory Campbell-Lange > > wrote: > >> > >> We do have complex transactions, but I haven't benchmarked the > >> performance so I can't describe it. Fe

Re: [PERFORM] Advice sought : new database server

2012-03-07 Thread Scott Marlowe
On Mon, Mar 5, 2012 at 9:56 AM, Craig James wrote: > On Sun, Mar 4, 2012 at 10:36 AM, Rory Campbell-Lange > wrote: >> >> We do have complex transactions, but I haven't benchmarked the >> performance so I can't describe it. Few of the databases are at the many >> million row size at the moment, an

Re: [PERFORM] Advice sought : new database server

2012-03-07 Thread Merlin Moncure
On Mon, Mar 5, 2012 at 10:56 AM, Craig James wrote: > On Sun, Mar 4, 2012 at 10:36 AM, Rory Campbell-Lange > wrote: >> >> We do have complex transactions, but I haven't benchmarked the >> performance so I can't describe it. Few of the databases are at the many >> million row size at the moment, a

Re: [PERFORM] SSD and RAID

2012-03-07 Thread Andrea Suisani
On 03/06/2012 10:34 AM, Yeb Havinga wrote: On 2012-03-06 09:34, Andrea Suisani wrote: On 03/06/2012 09:17 AM, Yeb Havinga wrote: PS: we applied the same philosophy (different brands) also to motherboards, io controllers and memory, but after testing, we liked one IO controllers software so m

Re: [PERFORM] SSD and RAID

2012-03-07 Thread Andrea Suisani
On 03/06/2012 09:17 AM, Yeb Havinga wrote: On 2012-03-05 23:37, Mark Kirkwood wrote: Which brings up the question of should it be a pair in RAID 1 or just a singe drive? Traditionally this would have been a no brainer "Of course you want RAID 1 or RAID 10"! However our experience with SSD fail

Re: [PERFORM] SSD and RAID

2012-03-07 Thread Yeb Havinga
On 2012-03-07 01:36, Mark Kirkwood wrote: On 06/03/12 21:17, Yeb Havinga wrote: One thing to note is that linux software raid with md doesn't support discard, which might shorten the drive's expected lifetime. To get some numbers I tested the raid 1 of ssd's setup for mediawear under a Post