Re: mysql on tmpfs

2006-04-10 Thread Werner Puschitz
Atle Veka wrote: Anyone have any experience to share about running mysql on a linux tmpfs (using memory)? tmpfs is swappable. I would use ramfs which is not swappable. For us it's worked out pretty well and is normally operating lightning fast compared to an identical SCSI based system. Howev

Re: mysql on tmpfs

2006-04-08 Thread Atle Veka
That would be pretty dangerous if I ever needed to say rebuild a table and run out of memory. Atle - Flying Crocodile Inc, Unix Systems Administrator On Sat, 8 Apr 2006, Gabriel PREDA wrote: > If there is plenty of free memory... > Can't you completly disable SWAP ? > -- > Gabriel PREDA > S

Re: mysql on tmpfs

2006-04-08 Thread Gabriel PREDA
If there is plenty of free memory... Can't you completly disable SWAP ? -- Gabriel PREDA Senior Web Developer On 4/7/06, Atle Veka <[EMAIL PROTECTED]> wrote: > > However, even though > there is plenty of free memory linux makes weird decisions from time to > time, temporarily killing performan

mysql on tmpfs

2006-04-07 Thread Atle Veka
Anyone have any experience to share about running mysql on a linux tmpfs (using memory)? For us it's worked out pretty well and is normally operating lightning fast compared to an identical SCSI based system. However, even though there is plenty of free memory linux makes weird decisions from time