Re: Managing MySQL /w large tables

2001-09-19 Thread Jeremy Zawodny
On Wed, Sep 19, 2001 at 09:37:57AM -0400, Phillip Spademan wrote: > Hello: > > I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system > with 1G ram, it takes forever to get anything out, i have even tryed > selecting the data into a file. Is there any tricks/tips anyone can > give me

Re: Managing MySQL /w large tables

2001-09-19 Thread Carl Troein
Phillip Spademan writes: > I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G > ram, it takes forever to get anything out, i have even tryed selecting the > data into a file. Is there any tricks/tips anyone can give me for managing > large DB's? Spend some time on re

Managing MySQL /w large tables

2001-09-19 Thread Phillip Spademan
Hello: I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G ram, it takes forever to get anything out, i have even tryed selecting the data into a file. Is there any tricks/tips anyone can give me for managing large DB's? It also likes to crash tables every month or so t