> If you are using MySQL 4.x, using a RAM disk isn't going to speed
> up similar Selects very much because it caches them. If you are doing a
lot
> of different Selects then it will help.
Its a web search engine with 10-15 search options, so yes the selects will
vary and very often every row will
At 12:51 PM 1/28/2004, Seth Brundle wrote:
After some research, I chose a dual Opteron MySQL server for my new search
box. For storage, I only update the tables once a day, so I plan on
putting my data directory on a Linux ramdrive and backing it up to the
hard disk after each update for maximum
- Original Message -
From: "Seth Brundle" <[EMAIL PROTECTED]>
To: "Eric" <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 5:50 PM
Subject: Re: 64-bit Linux MySQL and ramdisks
> > I am curious, is there really that big of a benefit to using a
Hi,
I am curious, is there really that big of a benefit to using a ramdisk this way? If
you have enough memory for your keycache and buffers and don't have to use tmp space
for any queries? Add the query cache in 4 to that and I wonder what is left to
ramdisk?
Thanks,
Eric
At 10:51 AM 1/28
After some research, I chose a dual Opteron MySQL server for my new search box. For
storage, I only update the tables once a day, so I plan on putting my data directory
on a Linux ramdrive and backing it up to the hard disk after each update for maximum
performance.
If anyone has any reccommend