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 reccommendations for dual-opteron 64-bit Linux distributions or any experience or tips on running MySQL on a ramdrive I'd like to hear them.
Thanks Seth
Seth,
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. You may also want to try using a RAM disk for the MySQL temp directory because it needs to create a new table for table sorts, group by's (and joins?).
See: http://www.mysql.com/doc/en/Temporary_files.html
I tried using a RAM disk in Win2k was the ram disk was too unstable (had nothing to do with MySQL) There are hardware based RAM cards that don't steal memory from the OS, that will solve the problem but are still fairly expensive. For Windows see http://www.cenatek.com/. Your performance may increase by a factor of 2 or 3. Don't expect anything like 10x faster or you'll be disappointed.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
