2GB limit (more info)?

[Christopher E. Brown]

On Thu, 27 Jan 2000, Khimenko Victor wrote:

> Ext2 is not relevant here. Since VFS in 2.2.x does not support files with
> more then 2GiB size you can not have such files with ANY filesystem.
> 
> > So, to accomplish the task I must use more tables with maximum size of
> > 2GB.
> 
> Exactly. Each table should be under 2GiB in size but full database can be much
> bigger. About mysql/postgresql... MySQL is VERY fast on small and medium sized
> databases but it's not very suited to handle REALLY large ones: I've seen
> big performance drop after 500'000-1'000'000 records in table (sometimes even
> 100'000 was enough). Not know about postgresql...


	Are you confusing MySQL with msql?  With larger tables
optimizing you indexes is important, but I have used MySQL wel beyond
the  500,000-1,000,000 mark (8 - 10 million rows is about normal
for most of our logging and capture systems).

---
As folks might have suspected, not much survives except roaches, 
and they don't carry large enough packets fast enough...
        --About the Internet and nuclear war.



-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo en vger.rutgers.edu
Please read the FAQ at http://www.tux.org/lkml/