Re: practical MySQL database size limits

2003-11-10 Thread Eric Jain
> our database is about 20 Gb and growing daily. so far, I still see > nearly constant time query performance on tables with ~10M rows. I > don't think mysql is limited by file size per se. I guess performance depends a lot on what your tables look like, and your hardware, obviously. From my own e

Re: practical MySQL database size limits

2003-11-08 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 05:08:54PM -0700, Jeff Mathis wrote: > our database is about 20 Gb and growing daily. so far, I still see > nearly constant time query performance on tables with ~10M rows. I don't > think mysql is limited by file size per se. It is limited to the extent that your operating

Re: practical MySQL database size limits

2003-11-06 Thread Jeff Mathis
our database is about 20 Gb and growing daily. so far, I still see nearly constant time query performance on tables with ~10M rows. I don't think mysql is limited by file size per se. Ari Davidow wrote: > > We're talking about storing binary files (images) inside a MySQL database > to take advan

practical MySQL database size limits

2003-11-06 Thread Ari Davidow
We're talking about storing binary files (images) inside a MySQL database to take advantage of the granularity and control we get over file access that way. But we already have 1.5GB, and that could lead to a very large database very quickly. What are people's experiences with large MySQL data