Re: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Ken Jones
Szeki - Inc wrote: Hi, It is a good idea to use heap tables for vpopmail query-s ? MyISAM tables for UPDATES, and HEAP for selects (they will be created from MyISAM)? I wanna to minimalize the disk subsystem impact. System is always waiting for disks(big load, can even reach 20-25). What is

RE: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Nicholas Harring
What if I put qmails queue to ramdisk (or tmpfs ramdisk) ? (memory cards ? are good enough ?) I would try putting /var/qmail/queue on the ramdisk since you have the RAM already. I would also comment out the fsync() calls in the qmail source code. If you're going to do this, and care

Re: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Tom Collins
On Nov 4, 2005, at 7:10 AM, Ken Jones wrote: I would try putting /var/qmail/queue on the ramdisk since you have the RAM already. Does the OS back up the ramdisk to a physical disk on shutdown? If not, and you have to reboot your server (or if it goes down for maintenance), you'll lose any

[vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-03 Thread Szeki - Inc
Hi, It is a good idea to use heap tables for vpopmail query-s ? MyISAM tables for UPDATES, and HEAP for selects (they will be created from MyISAM)? I wanna to minimalize the disk subsystem impact. System is always waiting for disks(big load, can even reach 20-25). What is the ideal maximum