Re: Efficiently handling large amounts of data in mysql

2004-01-31 Thread mos
Kyle, Sounds like you've thought of everything. How much disk space does your largest table take up? Probably too much for what I'm about to suggest. There are commercial external ram disks that support gb volumes. You could create a temporary database on the RAM disk, file copy

Re: Efficiently handling large amounts of data in mysql

2004-01-30 Thread mos
At 01:20 PM 1/30/2004, you wrote: I routinely see people requesting information on how to efficiently handle *large* tables in mysql. Hopefully, the following will be helpful to those individuals. I have several tables that are 500M to 4B rows in size and require me to drop and re-cre

Efficiently handling large amounts of data in mysql

2004-01-30 Thread Kyle J. Munn
I routinely see people requesting information on how to efficiently handle *large* tables in mysql. Hopefully, the following will be helpful to those individuals. I have several tables that are 500M to 4B rows in size and require me to drop and re-create indices at regular interval